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.
About This Shortcut Move one Screen Left – It moves one screen to the left with the shortcut command. Keybord Shortcut key Window: Alt + PgDn Mac: Fn + Alt + ↑ Example:
Excel Shortcut: Move one Screen Left Read Post »
About This Shortcut Move one Screen Right – It goes right by one screen. Keybord Shortcut key Window: Alt + PgDn Mac: Fn + Alt + ↓ Example:
Excel Shortcut: Move one Screen Right Read Post »
About This Shortcut Move one Cell Down – The down key moves the cursor down one row. Keybord Shortcut key Window: ↓ Mac: ↓ Example:
Excel Shortcut: Move one Cell Down Read Post »
About This Shortcut Move one Cell up – The up-arrow key moves the screen up one row. Keybord Shortcut key Window: ↑ Mac: ↑ Example:
Excel Shortcut: Move one Cell up Read Post »
About This Shortcut Move one Cell Left – The left arrow shortcut key moves the screen left by one column. Keybord Shortcut key Window: ← Mac: ← Example:
Excel Shortcut: Move one Cell Left Read Post »
About This Shortcut Move one Cell Right – The shortcut key moves to the right by one column. Keybord Shortcut key Window: → Mac: → Example:
Excel Shortcut: Move one Cell Right Read Post »
About This Shortcut Close Current Workbook – If you press “Ctrl” and “F4” at the same time, you can close the open Excel workbook window. Keybord Shortcut key Window: Ctrl + F4 or W Mac: Cmd + W Example:
Excel Shortcut: Close Current Workbook Read Post »
About This Shortcut Maximize Current Workbook Window – Ctrl+F10 maximizes the currently selected window. Keybord Shortcut key Window: Ctrl + F10 Mac: Fn + Ctrl + F10 Example:
Excel Shortcut: Maximize Current Workbook Window Read Post »
About This Shortcut Drag to Duplicate Worksheet – Worksheet tabs can be rearranged by dragging and dropping them at the workbook’s footer. When you right-click a worksheet and select “Duplicate,” you’ll see this option. Within a document, the cursor will transform into a plus (+) sign. When you let go of the mouse, a new
Excel Shortcut: Drag to Duplicate Worksheet Read Post »
About This Shortcut Protect workbook – The shortcut keys help protect the workbook in Excel. Keybord Shortcut key Window: Alt + R, P W Example:
Excel Shortcut: Protect workbook Read Post »