Ctrl + 0 (zero) - This shortcut quickly resets your zoom level back to 100%.
ZOOM SHORTCUTS EXCEL PLUS
Simply hold down the Ctrl key and then press the plus key to zoom in or the minus key to zoom out. Ctrl + +/- This shortcut also lets you zoom in and out of your spreadsheet, but instead of using your mouse wheel, you use the plus and minus keys on your keyboard.Simply hold down the Ctrl key on your keyboard and then scroll up or down with your mouse wheel to zoom in or out. Ctrl + Mouse Wheel Up/Down - This shortcut lets you quickly zoom in and out of your spreadsheet by using your mouse wheel.Here are 9 essential zoom shortcuts that every excel user should know:
ZOOM SHORTCUTS EXCEL UPDATE
Update your Macabacus software to take advantage of the latest features.If you're an excel user, then you know how important it is to be able to zoom in and out of your spreadsheet quickly and easily. Some features and descriptions of these features may not apply to older versions of Macabacus.
This documentation refers to the latest Macabacus version. Lock the scrollable area of the active worksheet to the current selection, or Unlock the scrollable area of the active worksheet to allow unrestricted scrolling. This works like Excel's native Split tool, except that it can split multiple worksheets at once. Use this tool to split all selected worksheets at the address of the active cell on the active worksheet, or remove splits from all selected worksheets. Splitting divides the window into different panes that each scroll separately. This works like Excel's native Freeze Panes tool, except that it can freeze multiple worksheets at once. Use this tool to freeze panes on all selected worksheets at the address of the active cell on the active worksheet, or unfreeze panes on all selected worksheets. Freeze / Unfreeze Paneįreezing panes keeps the first rows and columns visible while the rest of the worksheet scrolls. For these reasons, NavAid is generally intended to be used when reviewing models and data, rather than actively building models and populating data.Īccess the following tools from the Macabacus > View menu to modify how worksheets can be scrolled. NavAid will disable automatically upon saving a workbook, and NavAid clears Excel's Undo stack (an Excel limitation) when enabled. NavAid shades rows and columns intersecting the selected range for improved visibility while navigating cells, and can be enabled / disabled from the Macabacus > View menu. Some Macabacus notifications and features may not work while the Status Bar is hidden. You can specify which workspace items Macabacus will hide/show in the Excel > Interface section of the Settings dialog, and your Maximize View preferences can be loaded upon starting Excel.
ZOOM SHORTCUTS EXCEL FULL
Maximize View is similar to Excel's native Full Screen mode available in some versions of Excel, except that the latter is for presentation only, not editing-pressing the Escape key (necessary in the course of modeling) exits Excel's native Full Screen mode. This is especially useful when screen real estate is limited (e.g., laptops). Toggle the visibility of various workspace items (e.g., Formula Bar, Status Bar, ribbon, row/column headers, task panes) in Excel's application window to maximize the spreadsheet viewing area. To do this using native Excel functionality, you must remove print areas on each worksheet individually. Remove print areas for all selected worksheets and set their view to Normal. With native Excel functionality, you must set print areas of each worksheet individually.
You can select a single range of cells or even multiple non-contiguous ranges. Performing this operation will put the selected worksheets in Page Break Preview mode and retain their original zoom levels (Excel randomly changes zoom level when setting Page Break Preview mode).
Set print areas for all selected worksheets to the address of the currently selected range.
0 kommentar(er)
