Excel Tips
Page 1

Underlining Text in Excel
Everyone knows that you can underline text by simply selecting what you want underlined and then clicking on the underline tool on the toolbar. This adds a single underline. If you want a double underline, you can add one quickly by simply holding down the Shift key as you click on the underline tool. The double underline is added to your selected text. If you want any fancier underlines, you must choose Cells from the Format menu and then do your work on the Font tab.

Format Excel Worksheets Simultaneously
If you want to apply the same formatting to every sheet in a workbook, you don't need to tediously perform the same steps on each worksheet. To apply formatting to an entire workbook, right-click on one of the worksheet tabs and then choose Select All Sheets. At this point, any formatting you apply or text you enter will be applied to all the sheets. To ungroup the sheets, just click on a worksheet tab or right-click on a tab and choose Ungroup Sheets from the shortcut menu. If you want to exclude some sheets from the changes, click on the tabs of the worksheets you want to exclude while holding the [Ctrl] key. Note that you can also group sheets by holding the [Shift] key and selecting the worksheet tabs.

AutoFill in Excel
You can gain more control over the AutoFill process if, instead of clicking on the fill handle, you right-click on it and then drag. When you release the mouse button a Context menu appears that allows you to select the type of fill you want to perform.

Shortcut for Entering the Sum Formula in Excel
If you want to sum a row or column of numbers, you can simply hold down the Alt key while you type in an equal sign (=).  For example, suppose you enter 1, 2, 3, 4, 5 into cells A1 through A5. Then click in cell A7 and press Alt as you type the equal sign. This enters the Sum formula. Then press Enter and you have your sum of 15.

Fill Multiple Cells With the Same Information in Excel
If you need to fill a group of cells with the same information, you can first select the cells you want to use and then type the information into one cell. Press Ctrl-Enter, and the data appears in all the selected cells. To enter the data into noncontiguous cells, select the first group of cells, then press and hold the Ctrl key while you select other ranges. When you finish selecting all the ranges, type in your data. For this to work, you simply type your data as soon as you finish selecting cells. Don't click a cell first - this will deselect all your cells.