1) To select all cells on a worksheet, do one of the following: Click the Select All button. Press Ctrl+A.
2) On the Home tab, in the Cells group, click Format.
3) Do one of the following: Under Visibility, point to Hide & Unhide, and then click Unhide Rows or Unhide Columns.
And speaking of "hiding and unhiding," when you find the button that raises and lowers the partition to the front of my limo, please don't play with it like an idiot. The wiring breaks down easily, and remember, I do have your credit card number for the deposit. Play safe, kids.