Tips and Tutorials for Excel - View
Using these add-ins can really save your time:
|
Kutools for Excel: includes more than 120 handy functions and tools to free you from time-comsuming operations in Excel 2007/2010. Free Trial |
|
Office Tab: brings you a handy tabbed interface in your Microsoft Office applications as follows. Free Trial  |
View|Range & Cells | Editing & Formula|Workbook & Worksheet|Others
Navigation Pane
- List all worksheets in one workbook
- Navigate between windows in Workbooks
- Show navigation pane
- Navigate between cells
- List named ranges
- List column header names
Work Area Size
Toggle columns/worksheets
Toggle View Setting
- Show or hide formula bar
- Display or hide row & column headers
- Display Selection Pane
- Display or hide status bar
- Display or hide sheet tabs
- Show or hide Horizontal/Vertical scroll bar
- Show & hide gridlines
- Hide page breaks
- Hide or display cells with zero value in selected ranges
- Hide or display cells with zero value in a worksheet
- Display or hide zero values in cells of Microsoft Excel
- Hide rows with zero value
Show / Hide
- Set scroll position or hide other cells
- Hide other sheets
- Unhide all hidden sheets
- Hide other workbooks
- Unhide all hidden workbooks
- Show hidden ranges (columns and rows)
- Show formulas in cells 2007/2010
- Hide unused cells, rows, and columns
View|Range & Cells | Editing & Formula|Workbook & Worksheet|Others
