Ctrl+Alt+O: Select cells based on content, formatting and more. Ctrl+Alt+N: Add new worksheet (fill in a name). Ctrl+Alt+M: Move or resize selected range. Ctrl+Alt+Shift+Down Arrow: Extend selection to the last used row Ctrl+Alt+Shift+Right Arrow: Extend selection to the last used column Ctrl+Alt+J: Start the last used utility again. Ctrl+Alt+I: Apply formula/calculation to selected cells. Ctrl+Alt+H: Find and/or replace in all sheets. Ctrl+Alt+G: Export selection or active sheet as new file. Ctrl+Alt+F: Create a list of filenames and properties in a folder. Ctrl+Alt+E: Set default path to current file Ctrl+Alt+C: Color each n'th row or column in selection. Ctrl+Alt+B: Reload all installed add-ins (rebuilds the menu) Ctrl+Alt+A: Select adjacent cells in column with the same value
With the "Favorite tools" you can add the tools from ASAP Utilities that you use most frequently and assign your own shortcuts to them.īy default the list is filled with the following tools: Favorites & Shortcut keys » Edit your favorite tools and shortcut keys.ĪSAP Utilities contains a lot of different utilities. (additional keywords: view comment, tabs, unhiding, fullscreen, headings, pagebreaks) 2. This will reset the statusbar, set the calculation to automatic, enable the display of alerts (Application.DisplayAlerts = True), set the cursor to default and enable all toolbars.īy default this utility can be started with the shortcut Ctrl+Shift+I. Reset everything to default application settings. Useful when the status bar is locked, for example with a certain message due to a macro that was not properly finished. This causes the dialogs for opening and saving files to start in this folder the next time you use them. Set the default folder to the path of the selected workbook. Remove the selection restrictions in all worksheets. Quickly change the way your worksheet, workbook or Excel is displayed. Browse through the worksheets in your workbook and quickly see the settings per worksheet. Comments: none, comment indicator only or comment & indicator Show objects: show all, show placeholders or hide allĭisplay settings for Excel on the application level: You can quickly apply the settings of the selected worksheets to all worksheets in your workbook. As you slide you will immediately see the result. Zoom, you can use a slider to set the zoom percentage.
This tool shows the immediate result or your changes, for example if you uncheck the grid, you will see the effect immediately. Quickly navigate through your worksheets and change the way they are displayed.
0 kommentar(er)
