« Format Painter | Main | Copying Video URLs at the Current Time. »

Excel Tips

Here are some quick tips for working with Excel:

Clearing the Print Area:

In Excel 2007

  1. Click anywhere on the worksheet for which you want to clear the print area.
  2. On the Page Layout tab, in the Page Setup group, click Clear Print Area.

In Excel 2003

  1. Choose File > Print Area > Clear Print Area from the menu.

How to Hide a Column:

In Excel 2007

  1. Select the column(s) you want to hide. 
  2. On the Home command tab, in the Cells group click Format.
  3. From the Format menu, in the Visibility section, select Hide & Unhide.
  4. Select Hide Columns.

In Excel 2003

  1. Select the column(s) you want to hide.
  2. On the Format menu, point to Column, and then click Hide.

To hide a row in either Excel 2007 or Excel 2003, use the same steps except substitute row for column.

How to Unhide a Column:

In Excel 2007

  1. Select at least one cell from both of the column(s) around the hidden column(s).
    EXAMPLE: If column B is hidden, select a cell from both columns A and C.
  2. On the Home command tab, in the Cells group, click Format.
  3. From the Format menu, in the Visibility section, select Hide & Unhide.
  4. Select Unhide Columns.

In Excel 2003

  1. Select at least one cell from both of the column(s) around the hidden column(s).
    EXAMPLE: If column B is hidden, select a cell from both columns A and C.
  2. On the Format menu, point to Column, and then click Unhide.

To unhide a row in either Excel 2007 or Excel 2003, use the same steps except substitute row for column.

More Tips for both Excel 2007 and Excel 2003:

Quick Sum of a Column
Hold down the Alt key while you type the equal sign. Excel will automatically write a SUM formula for the cells above or to the left.

Some Keyboard Shortcuts

Ctrl+;(semicolon) - Inserts current date

Ctrl+shift+:(colon) - Inserts current time

Ctrl+Page Down - Move to the next worksheet

Ctrl+Page Up -  Move to the previous worksheet

Ctrl+Home - Go to upper left most cell (usually A1)

Ctrl+End - Go to the bottom right corner of used cells

Ctrl+1 - Opens the format cell window

Ctrl+s - Saves workbook

Ctrl+z - Undo (My personal favorite!)

For even more shortcuts, open up Help in Excel and search for the word "shortcuts".

Comments

Feed You can follow this conversation by subscribing to the comment feed for this post.

Good list of shortcuts. CTRL W is a good one for closing files. I like the fact that in 2007 and 2010 you can press ALT and get shortcuts displayed on the Ribbon and Quick Access Toolbar.

Post a comment