Other Tip Collections

• Excel Data Entry Tips and Tricks

  Beyond the Basics - More Excel Tips and Tricks

  General Microsoft Office Tips

1. Keyboard shortcut/toggle -- Ctrl-~ (Ctrl-Tilde)
   
   
2. Tools | Options | View tab | Window Options section, check Formulas

1. Select the cell(s) containing the dates you want to format.
2. Right-click the selected cell(s) and choose Format Cells. The Format Cells dialog box appears.
3. Click the Number tab.
4. In the Category list, select Custom.
5. In the Type text box, type mm/dd/yyyy
6. Click OK to close the Format Cells dialog box.

1. Group together: Right-click on a sheet tab, Choose Select All Sheets
2. Spell Check: Choose Tools, Spelling
3. Ungroup sheets: Right-click on a sheet tab, Choose Ungroup Sheets

1. Select the cell(s)
2. Format | Cells
3. In the Format Cells dialog box click the Font tab
4. Click the arrow at the right side of the Color list box and select white from the list
5. Click OK to close the dialog box and apply your new font color
6. Print the worksheet without showing the unwanted cells. After you finish printing, select the cells again and set the color back to black (or automatic).

Sub CustomFooter()
'   Inserts the file name and path into the page footer
'   for each sheet in the active workbook

    For Each sht In ActiveWorkbook.Sheets
        sht.PageSetup.LeftFooter = ActiveWorkbook.FullName
    Next sht
End Sub 

• To move to the next sheet in a workbook, press Ctrl + PgDn.
• To move to the previous sheet in a workbook, press Ctrl + PgUp.
• To move to the next window (open workbook), press Ctrl + Tab.

1. Right-click in the gray area of the toolbar to the right of Help
2. Choose Customize
3. Go to the Commands tab
4. Choose the Edit category
5. Scroll all the way to the bottom of the list of Edit Commands
6. You should find the Select Visible Cells command
7. Click and drag this command and drop it where you want it to appear on a toolbar.

• Position your cell pointer to define the rows and columns to freeze.
• Go to the Window menu and choose Split or Freeze Panes.
• Return to the Window menu to Remove Split or Unfreeze Panes.

1. Select the cells to transpose, Edit | Copy
2. Right-click on the upper-lefthand corner of a range of empty cells that can accommodate the transposed result.
3. Choose Paste Special and check the transpose checkbox

1. Create a workbook that contains the sheets, default text (such as page headers and column and row labels), formulas, macros, styles, zoom percentage, and other formatting you want in new workbooks that you base on the template.
2. On the File menu, click Save As.
3. In the Save as type box, click Template (*.xlt).
4. In the Save in box, select the folder where you want to store the template.
5. To create the default workbook template, select the XLStart folder in the Microsoft Excel folder. (You'll probably find the XLStart folder in c:\Program Files\Microsoft Office\office\ )
6. In the File name box, type BOOK to create a default workbook template.