|
» Viewing Selecting Data in a Sheet
CATEGORY: Excel Data |
VERSIONS: All Microsoft Excel Versions |
|
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.   |
|
RATING:
2.94
VIEWS: 38550 |
||||
Sponsors:
 |
Book Store:
Recommended Books:
- Microsoft Windows XP Inside Out
- Microsoft Excel 2002 Visual Basic for Applications Step by Step
- Financial Risk Manager Handbook, Second Edition
- The McGraw-Hill 36-Hour Course in Finance for Nonfinancial Managers
- The Total Money Makeover. : A Proven Plan for Financial Fitness
- Microsoft Outlook Version 2002 Step by Step (With CD-ROM)
Related MS EXCEL TIPS:
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.
