View All Data in a Worksheet: MS Excel
by Carol Bratt on August, 13 2006 at 08:08AM EDT
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:
- Select the current region an press CTRL + *.
- Choose View | Zoom.
- Select Fit selection.
- 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.
- Choose Tools | Options.
- Select the View tab.
- Clear the check boxes for Row & column headers. Horizontal scroll bar, Vertical scroll bar, Sheet tabs, Formula bar and Status bar.
- 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!
Filed under:
Rate this article:
Do you need Tech Support?

I can help! Send me a message on the bottom left of the screen (using the Zopim Chat button), or click my picture to read more about how I can fix your computer over the Internet. Optionally you can read all about my credentials, here.

I can help! Send me a message on the bottom left of the screen (using the Zopim Chat button), or click my picture to read more about how I can fix your computer over the Internet. Optionally you can read all about my credentials, here.