» Viewing Selecting Data in a Sheet
CATEGORY - Excel Data
VERSION - All Microsoft Excel Versions
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.


Book Store:
Recommended Books:
- Financial Statement Analysis: A Practitioner's Guide, 3rd Edition
- The Fall of Advertising and the Rise of PR
- Definitive Guide to Excel VBA
- F1 Get the Most out of Excel! The Ultimate Excel tip Help Guide
- Advanced modelling in finance using Excel and VBA
- Windows XP All-in-One Desk Reference For Dummies
No comments have been submitted.

