View All Data in Worksheet: MS Excel

Dennis Faas's picture

An Excel worksheet is packed with hundreds, and sometimes thousands, of cells containing data. You can either view the complete data region (the area where you have input data) in the worksheet, or magnify / reduce the selected data region to the size of the window using the following method:

  1. Select the current region.
     
  2. Press Ctrl + *.
     
  3. Choose View | Zoom.
     
  4. Select Fit selection.
     
  5. Click OK.

Increase the amount of data that appears in the window by hiding window elements such as the sheet tabs, toolbars, formula bar and status bar.

  1. Choose Tools | Options.
     
  2. Select the View tab.
     
  3. Clear the check boxes for Row & column headers, Horizontal scroll bar, Vertical scroll bar, Sheet tabs, Formula bar and Status bar.
     
  4. Click OK.
     
  5. Select View (from the Excel menu), and uncheck the selection of Formula Bar and Status bar.
     
  6. Select any one of the toolbars ad right-click. From the shortcut menu, clear the check boxes beside each of the toolbars displayed.

Only the title row is displayed and more rows are now visible.

To quickly increase or decrease the percentage of the screen magnification: select cell A1 and press Ctrl, then roll the mouse wheel forward or backward.

Visit Carol's web site to learn more tips like this one!

| Tags:
Rate this article: 
No votes yet