« Windows 7 tip: Snipping Tool for screen shots | Main | Better email »

Excel Tips

Please note that these tips are for Excel 2007 or 2010.  They may or may not work for earlier versions.

How to hide a row or column

  1. Select rows or columns to hide
  2. On the Home tab of the menu ribbon, choose Format in the Cells section of the ribbon
  3. Choose Hide & Unhide option
  4. Choose Hide Rows or Hide Columns

Keyboard shortcuts:

  • To hide current row, press CTRL+9
  • To hide current column, press CTRL+0

How to unhide a row or column

  1. Select rows or columns on either side of the hidden area
  2. On the Home tab of the menu ribbon, choose Format in the Cells section of the ribbon
  3. Choose Hide & Unhide option
  4. Choose Unhide Rows or Unhide Columns

Keyboard shortcuts:

  • To unhide rows in selected range, press CTRL+SHIFT+9
  • To unhide columns in selected range, press CTRL+SHIFT+0

How to enter a line break in a cell

  1. Put cursor at point you wish to start a new line
  2. Press ALT+ENTER

How to wrap text automatically

  1. Select the cells with text to wrap
  2. On the Home tab of the menu ribbon, go to the Alignment section of the ribbon
  3. Choose Wrap Text
     
    Note: Data in the cell wraps to fit the column width. When you change the column width, data wrapping adjusts automatically.  If all wrapped text is not visible, it may be because the row is set to a specific height.

Comments

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

Post a comment