View All Data in a Worksheet: MS Excel

Dennis Faas's picture

An Excel worksheet is packed with hundreds or thousands of cells containing data. You can either view the complete data region in the worksheet or magnify or reduce the selected data region to the size of the window.

Follow the steps below:

  1. Select the current region an press CTRL + *.
     
  2. Choose View | Zoom.
     
  3. Select Fit selection.
     
  4. Click OK.

You can 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.

Select View and uncheck the selection of Formula Bar and Status Bar.

Select any one of the toolbars and right-click. From the shortcut menu, clear the check boxes beside each of the toolbars displayed.

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

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

| Tags:
Rate this article: 
No votes yet