Show-Me  Academy Menu  |  FAQ  |  About  |  Contact  |  See all the latest video tutorials from Show-Me Academy with our RSS feed

Show me how to freeze panes in Microsoft Excel 2007

Excel -> Microsoft Excel 2007

Problem: When I scroll down or to the right on a spreadsheet, I can no longer see the column headers.

  1. Open Microsoft Excel 2007
  2. Select an entire column or an entire row
  3. Click the "View" tab
  4. On the "Window" section, click the "Freeze Panes" button
  5. Click the "Freeze Panes" option
  6. Select the same row or column
  7. Click the "Freeze Panes" button
  8. Select the "Unfreeze Panes" button

Menu  |  FAQ  |  About  |  Contact  |  Terms  |  Privacy  |  RSS
© Copyright 2008 by Show-Me Academy, Inc. - All rights reserved