Datasheet

•

Select a range that consists of cells to the left and to the right of the hidden columns,

and press Ctrl+Shift+0 (that’s a zero).

To unhide one or more hidden rows, use any of these methods:

•

Select a range that consists of cells above and below the hidden rows. Then choose

Home ➪ Cells ➪ Format ➪ Hide & Unhide ➪ Unhide Rows.

•

Select entire rows above and below the hidden rows, and then right-click and choose

Unhide from the shortcut menu.

•

Select a range that consists of cells above and below the hidden rows, and press

Ctrl+Shift+9.

Tip 16: Hiding Columns or Rows

Part I

04_137666 ch01.qxp 5/22/07 7:31 PM Page 47