Excel « 360Photography

RSS

Posts Tagged ‘Excel’

Microsoft Excel 2010 – Quick Tip: Add a Manual Line Break

24 Jul

A keyboard shortcut to manually add a line break inside a cell.

If you have a lot of text that needs to be placed inside a cell in a Microsoft Excel 2010 workbook, you could decrease the size of the font to fit more text inside, but do so too much and the text will become ineligible. You could increase the cell width, but this affects every cell in the column. And you could merge neighbor cells together so the text flows automatically to the right, but depending on your layout this may not be feasible.

Or, one other option is to wrap the text in a cell. But pressing ENTER while typing data into a cell moves the cell pointer down, so how can this be done? …

Comments Off

Posted in Technology

Microsoft Excel 2010 – Working on a Wide Worksheet? Make ENTER Move to the Right

20 May

If you’re editing a wide worksheet with the 10-key, you might find it more convenient to have the ENTER key move the cursor to the cell to the right.

By default, when editing a worksheet in Microsoft Excel 2010, you can press the Tab key to move the selection cursor to the cell to the right, and Enter moves to the below cell.

If you’re editing a wide worksheet with a 10-key, you might find it more convenient to have the Enter key move to the cell to the right, just like the Tab key. The following shows you how to make this change. In fact, you can have Enter move up or to the left, if desired:…

Comments Off

Posted in Technology

Microsoft Excel 2010 – Change the Tab Color of a Worksheet

17 Mar

Tabs representing different worksheets in an Excel 2010 workbook can be colored for organizational purposes.

If you are editing a Microsoft Excel 2010 workbook containing multiple worksheets, you probably use the tabs at the bottom-left of the window to switch between them.

Instead of displaying all tabs in the same color, you might find it useful, especially if you have many tabs, to give them different colors. You might want to organize all worksheets related to a particular year in one color, or change tab colors representing P&L worksheets of particular quarters if the organization was in the red or black. You could also make every tab a different color for variety so you can tell people accounting is not boring….

Comments Off

Posted in Technology

Microsoft Excel 2010 – Hide Recent Documents or Show More

08 Feb

Configure Excel 2010 to hide the list of recent documents for privacy, or show more of them.

As with other Office 2010 applications, Microsoft Excel 2010 keeps a list of recent workbooks, allowing you to directly access frequently-edited documents without having to navigate your computer or network drives. If you have workbooks located in a variety of locations, this Recent list may prove very useful.

While Excel 2010 by default displays the last 25 documents, if you work on many workbooks you may want to increase this number up to 50. On the other hand, if you are worried about privacy you may wish to disable this list altogether….

Comments Off

Posted in Technology

Microsoft Excel 2010 – Change the Default Font for New Workbooks

30 Oct

Tired of every Excel 2010 workbook using 11 point Calibri as the default for cells? Change the default font for all new workbooks.

Just as in other Office 2010 applications, Microsoft Excel 2010 has a default font for new documents – 11 point “Body Text” (Calibri). While you can change the font for individual cells or groups of them, what if you grow tired of every new spreadsheet using this standard font? Maybe you want to use Arial or Verdana, or want cells a little larger so they are easier to read?

1. Select the “File” tab in the Ribbon….

Comments Off

Posted in Technology

Microsoft Excel 2010 – Stop Creating Workbooks with Multiple Worksheets

30 Oct

Or, create every Excel 2010 workbook with even more than 3 worksheets.

When you create a new workbook in Microsoft Excel 2010, it is automatically created with three worksheets. Depending on your needs, you may rarely use more than one worksheet in an Excel 2010 workbook, finding the extra worksheets gratuitous. Or, you may often create complex workbooks where many more worksheets are needed. Editing the default setting to create more worksheets may save you time in the long run.

1. Select the “File” tab in the Ribbon….

Comments Off

Posted in Technology

Microsoft Excel 2010 – Fill Cell with Attention Grabbing Gradient

17 Oct

Add a dual-color gradient to title or header cells in an Excel 2010 worksheet; several styles are available.

It’s easy to color the background of a cell in a Microsoft Excel 2010 worksheet. Just click the “Home” tab of the Ribbon, then in the “Font” section click the “Fill Color” button (the paint bucket icon).

However, what if you want to grab more attention than with a drab mono-color fill? Here’s how to add a dual-color gradient fill to a selected cell or group of cells in your worksheet. Note that this looks best on only the title and/or header text and not for cells containing actual data, though if you really want to, you can……

Comments Off

Posted in Technology

360Photography

Posts Tagged ‘Excel’

Microsoft Excel 2010 – Quick Tip: Add a Manual Line Break

Microsoft Excel 2010 – Working on a Wide Worksheet? Make ENTER Move to the Right

Microsoft Excel 2010 – Change the Tab Color of a Worksheet

Microsoft Excel 2010 – Hide Recent Documents or Show More

Microsoft Excel 2010 – Change the Default Font for New Workbooks

Microsoft Excel 2010 – Stop Creating Workbooks with Multiple Worksheets

Microsoft Excel 2010 – Fill Cell with Attention Grabbing Gradient

Pages

Archives

Categories