Google Exceltip.com
Account Icon
Shopping Cart
CheckOut

» Viewing Selecting Data in a Sheet

CATEGORY: Excel Data
To increase or reduce the selected data region to the size of the window:

1. Select a range of cells containing data.
2. From the View menu, select Zoom.
3. In the Zoom dialog box, select Fit Selection.
4. Click OK.

To increase the number of cells appearing in the window, hide window elements, such as sheet tabs, toolbars, the formula bar, and the status bar:

1. From the Tools menu, select Options, and then select the View tab.
2. Clear the checkboxes for Row & Column headers, Horizontal scroll bar, Vertical scroll bar, Sheet tabs, and then click OK.
3. Select View and deselect the Formula Bar and Status Bar checkboxes.
4. Select any one of the toolbars, right-click, and clear the checkboxes beside each of the displayed toolbars from the shortcut menu.




Rate this tip
12 34 5
  RATING: 2.94
  VIEWS: 38550
  No comments have been submitted.


REGISTERED USERS click here to post comments


GUESTSclick here to Register
Name
Comment Title
Comments


Terms and Conditions of use
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Copyright © 2003 ExcelTip.com
Microsoft, Microsoft Excel is a U.S. registered trademark of Microsoft Corporation