Author name: Umesh Manral

About This Shortcut Get Help on Selected Control – F1 displays help for the currently selected command. If there is no Help article linked with the specified command, the Help table of contents for that programme is displayed instead. Keybord Shortcut key Window: F1 Example: Note: The shortcut key will work with function key [Fn] […]

About This Shortcut Drag and cut – You can move a selection by selecting the cells, holding the mouse over the selection until it changes into a four-headed arrow, then releasing it in the new place. Keybord Shortcut key Window: Drag Mac: Drag Example:

About This Shortcut Drag and Copy – The default behaviour for drag and drop is to cut data in cells, but you can also copy cells during drag and drop. Use this shortcut before or after you start to drag the selection to copy cells. Excel will display a small plus (+) symbol to indicate

About This Shortcut Drag and Insert – The shortcut will insert cells at the new location. Additionally, it functions when dragging complete rows or columns. Keybord Shortcut key Window: Shift + Drag Mac: Shift + Drag Example:

About This Shortcut Drag and Insert Copy – The shortcut keys copies values and inserts cells at the new location. It also works when dragging entire rows or columns. It is an effective method for duplicating a row in an Excel table, as tables only allow you to copy and paste entire rows. Keybord Shortcut

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

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:

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:

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:

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: