Excel Shortcut: Set Print Area
About This Shortcut Set Print Area – You can use the shortcut command Alt + P, R S to quickly set the print area in Excel. Keybord Shortcut key Window: Alt + P, R S Example:
Excel Shortcut: Set Print Area Read Post »
Excel Shortcuts
Microsoft Excel stores and analyses data worldwide. Excel is still the go-to data analytics tool despite newer tools. Its many features simplify data organization. Moreover, Excel shortcuts speed up data manipulation. Excel uses shortcuts, and Excel shortcut keys speed up our work and boost productivity. These shortcut keys work with most Windows versions of Excel.
Excel Shortcut: Clear Print Area
About This Shortcut Clear print area – The keyboard shortcut command clears the print area in Excel. Keybord Shortcut key Window: Alt + P , R C Example:
Excel Shortcut: Clear Print Area Read Post »
Excel Shortcut: Zoom in
About This Shortcut Zoom in – When your mouse has a scroll wheel, you can zoom in on your spreadsheet by holding down the Ctrl key and moving the scroll wheel up. Keybord Shortcut key Window: Ctrl + Alt + [+] Mac: Alt + Cmd + [+] Example:
Excel Shortcut: Zoom in Read Post »
Excel Shortcut: Zoom Out
About This Shortcut Zoom out – The shortcut command zooms out your spreadsheet. Keybord Shortcut key Window: Ctrl + Alt + – Mac: Alt + Cmd + – Example:
Excel Shortcut: Zoom Out Read Post »
Excel Shortcut: Protect Sheet
About This Shortcut Protect sheet – The shortcut key protects or unprotects the worksheet in Excel. Keybord Shortcut key Window: Alt + R , P S Example:
Excel Shortcut: Protect Sheet Read Post »
Excel Shortcut: Toggle Full Screen
About This Shortcut Toggle Full Screen – It hides and unhides the Excel Ribbon, the title, and the status bar at the bottom of the window. It provides you with something like a full-page view of your sheet. Keybord Shortcut key Window: Ctrl + Shift + F1 Mac: Ctrl + Cmd + F Note: The
Excel Shortcut: Toggle Full Screen Read Post »
Excel Shortcut: Toggle Scroll Lock
About This Shortcut Toggle scroll lock – Scroll Lock is a key on the keyboard that locks and unlocks the screen, just like the CAPS LOCK key. When pressed, the scroll lock button turns on. You can press the Scroll Lock key again to turn it off. Keybord shortcut key: Window: ScrLk Mac: Fn +
Excel Shortcut: Toggle Scroll Lock Read Post »
Excel Shortcut: Select Non-adjacent Worksheets
About This Shortcut Select non-adjacent worksheets – In Excel, the shortcut key is to select non-adjacent cells and cell ranges. Keybord shortcut key: Window: Ctrl + Click Mac: Cmd + Click Example: Ctrl + Click is to unselect cells.
Excel Shortcut: Select Non-adjacent Worksheets Read Post »
Excel Shortcut: Select Adjacent Worksheets
About This Shortcut Select adjacent worksheets – It is a shortcut command for selecting adjacent worksheets. Keybord shortcut key: Window: Ctrl + Shift + PgUp/PgDn
Excel Shortcut: Select Adjacent Worksheets Read Post »
Excel Shortcut: Move to Next Pane
About This Shortcut Move to Next Pane – Move between the worksheet, Ribbon, task pane and zoom controls in a worksheet that has been split- In a split worksheet, the shortcut keys move between the worksheet, the Ribbon, the task pane, and the zoom controls. You can move between the worksheet, the Ribbon, the task
Excel Shortcut: Move to Next Pane Read Post »