The ASAP Utilities menu in Excel (English)
The Display & Navigation... utility
Quickly navigate between your workbooks and worksheets and adjust their display settings. Any changes you make will appear immediately. For example, if you turn off gridlines, you will see the effect right away. Worksheet settings: - Gridlines - Page breaks - Row & column headers - Zero values - Formulas - Outline symbols - Zoom, you can use a slider to set the zoom percentage. As you slide, you will immediately see the result. You can quickly apply the settings of the selected worksheets to all worksheets in your workbook. Workbook settings: - Sheet tabs - Horizontal scroll bar - Vertical scroll bar - Reference style: A1 or R1C1 - Show objects: show all, show placeholders, or hide all Display settings for Excel on the application level: - Formula bar - Status bar - Toolbars - Fullscreen - Comments: none, comment indicator only or comment & indicator With this tool, you can also: - Browse through all open workbooks. - Browse the worksheets in your workbook and quickly see the settings for each worksheet. - Quickly change how your worksheet, workbook, or Excel is displayed. - Remove the selection restrictions in all worksheets. - Set the default folder to the path of the selected workbook, causing the Open and Save dialogs to start in that folder next time. - Reset the status bar if it becomes locked (for example, after a macro that did not finish properly). - Reset everything to the default application settings, which restores the status bar, sets calculation to automatic, enables display alerts (Application.DisplayAlerts = True), returns the cursor to default, and re-enables all toolbars. By default, you can launch this tool using the Ctrl+Shift+I shortcut.In the Excel menu choose: ASAP Utilities › Display & Navigation...
Submenu screenshot
ASAP Utilities helps you save time and do what Excel alone cannot.With 300+ tools, our Excel Add-in automates repetitive tasks, increases your productivity, and simplifies complex tasks.
Excel with ASAP Utilities in its menu
Choose your language preference below
English (us) ⁄ Nederlands ⁄ Deutsch ⁄ Español ⁄ Français ⁄ Português do Brasil ⁄ Italiano ⁄ Русский ⁄ 中文(简体) ⁄ 日本語
« Return to the list of tools.
©1999-2025 ∙ ASAP Utilities ∙ A Must in Every Office BV ∙ The Netherlands
🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
For over 25 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.
🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
For over 25 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.