About This Shortcut Go to next worksheet – CTRL+PAGE DOWN helps to move to the next sheet in the workbook. Keybord shortcut key: Window: Ctrl + PgDn Mac: Fn + ⌃ + ↓ Note: The shortcut key will work with function key [Fn] if you are using laptop like Dell, or other companies laptop etc. […]
Excel Shortcut: Go to Next Worksheet Read Post »
About This Shortcut Insert new worksheet – It inserts a new worksheet in your Excel workbook. Keybord shortcut key: Window: Shift + F11 Note: The shortcut key will work with function key [Fn] if you are using laptop like Dell, or other companies laptop etc. Example:
Excel Shortcut: Insert New Worksheet Read Post »
About This Shortcut Display control menu – ALT+SPACEBAR displays the Excel window’s Control menu. Keybord shortcut key: Window: Alt + Space Example:
Excel Shortcut: Display Control Menu Read Post »
About This Shortcut Show right-click menu – It is the same as right-clicking on the selected cell to bring up the shortcut window. Keybord shortcut key: Window: Shift + F10 Mac: Fn + Shift + F10 Note: The shortcut key will work with function key [Fn] if you are using laptop like Dell, or other
Excel Shortcut: Show Right-click Menu Read Post »
About This Shortcut Open Modify Cell Style dialogue box – The shortcut key brings up the Excel dialogue box where you can change the style of a cell. Keybord shortcut key: Window: Alt + ‘ Mac: cmd + Shift + L Example:
Excel Shortcut: Open Modify Cell Style Dialogue Box Read Post »
About This Shortcut Hide or show objects – It can hide objects, show objects, or show placeholders for things. Keybord shortcut key: Window: Ctrl + 6 (^) Mac: Ctrl + 6 (^) Example: The shortcut key hides any objects on the excel or displays the hiding objects. Go to Insert > Select any Shapes in
Excel Shortcut: Hide or Show Objects Read Post »
About This Shortcut Snap to the grid (whilst dragging) – It will let you move data while holding the mouse key and switching between Excel Worksheets. Keybord shortcut key: Window: Alt Mac: Alt Example:
Excel Shortcut: Snap to Grid Read Post »
About This Shortcut Duplicate object, formula, text – When you press Ctrl + D, the contents of the cell one column up will be copied into the one you’re editing. It doesn’t work on rows. Keybord shortcut key: Window: Ctrl + D Mac: cmd + D Example:
Excel Shortcut: Duplicate Object Read Post »
About This Shortcut Open VBA Editor – If you press Alt+F11, you’ll be sent to the Visual Basic for Applications Editor, where you can write a macro using that language (VBA). Keybord shortcut key: Window: Alt + F11 Mac: Fn + Alt + F11 Note: The shortcut key will work with function key [Fn] if
Excel Shortcut: Open VBA Editor Read Post »
About This Shortcut Open Macro dialogue box – When you press Alt+F8, the Macro dialogue box appears, where you can create, run, amend, or remove a macro. Keybord shortcut key: Window: Alt + F8 Mac: Fn + Alt + F8 Note: The shortcut key will work with function key [Fn] if you are using laptop
Excel Shortcut: Open Macro Dialogue Box Read Post »