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 Drag to Worksheet – The drag and drop feature is limited to the same worksheet. Alt + Drag is useful to move a selection to a different worksheet. Keybord Shortcut key Window: Alt + Drag Mac: Cmd + Drag
Excel Shortcut: Drag to Worksheet Read Post »
About This Shortcut Create new workbook – Ctrl + N is a shortcut key that helps to create a new document, window, workbook, or file. Keybord Shortcut key Window: Ctrl + N Mac: Cmd + N Example:
Excel Shortcuts: Create new Workbook Read Post »
About This Shortcut Open workbook – Ctrl + O is a shortcut key most often helpful for opening a new Excel document. Keybord Shortcut key Window: Ctrl + O Mac: Cmd + O Example:
Excel Shortcut: Open Workbook Read Post »
About This Shortcut Save workbook – The current worksheet is saved when you press Ctrl + S in Microsoft Excel or other spreadsheet programs. If your worksheet has never been saved before, the Save As window will appear so you can give it a name and select an appropriate file extension. Keybord Shortcut key Window:
Excel Shortcut: Save Workbook Read Post »
About This Shortcut Save as – F12 displays the Save As dialogue box in Microsoft Excel. Keybord Shortcut key Window: F12 Mac: Cmd + Shift + S Example:
Excel Shortcut: Save as Read Post »
About This Shortcut Go to next workbook – In Microsoft Excel, Ctrl + Tab switches between the open workbooks if multiple workbooks are available. Keybord Shortcut key Window: Ctrl + Tab Mac: Cmd + [ ‘ ] Example:
Excel Shortcut: Go to Next Workbook Read Post »
About This Shortcut Go to the previous workbook – You can also use the “Ctrl + Shift + Tab” shortcut to move backwards through the tabs once. Keybord Shortcut key Window: Ctrl + Shift + Tab Mac: Cmd +Shift + [ ‘ ]
Excel Shortcut: Go to the Previous Workbook Read Post »
About This Shortcut Minimize Current Workbook Window – Ctrl + F9 keys minimize your excel window to an icon. Keybord Shortcut key Window: Ctrl + F9 Mac: Cmd + M
Excel Shortcut: Minimize Current Workbook Window Read Post »
About This Shortcut Print – In Microsoft Excel, Ctrl + P opens the print preview window. Keybord Shortcut key Window: Ctrl + P Mac: Cmd + P Example:
Excel Shortcut: Print Read Post »
About This Shortcut Open Print Preview Window – The shortcut key opens the Print window, where you can preview and print your document. Keybord Shortcut key Window: Ctrl + F2 Example:
Excel Shortcut: Open Print Preview Window Read Post »