- 1 Ctrl + C – Copy the text or value in a workbook
- 2 Ctrl + X – Cut selected cells
- 3 Ctrl + V – Paste content from clipboard
- 4 Ctrl + S – Save workbook
- 5 Ctrl + P – Print file
- 6 Ctrl + N – Create new workbook
- 7 Ctrl + O – Open workbook
- 8 Ctrl + Z – Undo last action
- 9 Ctrl + Y – Redo last action
- 10 Ctrl + F – Find the Data
- 11 Ctrl + H – Replace the Data
- 12 Ctrl + G – Display GO TO dialog box
- 13 Ctrl + B – Apply or remove bold
- 14 Ctrl + U – Apply or remove underline
- 15 Ctrl + I – Apply or remove italic
There are no shortcuts in life; luckily Excel isn’t life. Keyboard Shortcuts are an absolute necessity for an Excel user in order to achieve optimal efficiency. For those differently-abled in relation to mobility and vision, shortcuts provide an essential alternative to using a mouse or the touchscreen to navigate through Excel.
This article aims at itemizing the keyboard shortcuts that work across all Microsoft Office products and even applies to many NET framework-based applications which include most Microsoft products such as the Windows OS.
Here are a few ground rules you need to be aware of before we delve into the shortcut keys :
- The shortcuts referred to in this article are for the English US, India and UK keyboards. Keys may or may not correspond exactly to the other keyboards.
- Commands that require you to simultaneously press and release multiple keys together are indicated with a plus sign (+), whereas commands which require sequential press and release will be indicated with a comma (,) as a separator.
Without further ado, let me introduce the 15 Shortcut commands that work across platforms making your workflow process more robust and streamlined.
15 keyboard shortcuts:
The Copy shortcut key in Excel (Ctrl + C) helps to copy the selected cells, text, values, formulas, pictures et cetera.
This can be followed by another step using a different shortcut key to paste the copied details elsewhere in the worksheet or in a new workbook or on any other platform that supports this action.
The Cut shortcut key in Excel (Ctrl + X) helps to cut the selected cell or a single range of cells with its contents like text, values, pictures, and formulas.
The cells with the contents thus cut are placed on the clipboard to be pasted wherever required in the worksheet or in a new workbook or on any other platform that supports this action.
The paste shortcut key in Excel (CTRL + V) helps to paste the content on which copy or cut action has been applied. It pastes everything on the clipboard to all the platforms that support this action and is not restricted to just Excel.
The paste option can be applied either by (CTRL + V) or by pressing the Enter key in the cell where the cut/copied cells are to be pasted
The (CTRL + S) shortcut key helps to save the file in the current location. This shortcut works for files that already have a saved location. In case of new workbooks opened, a dialog box pops up requesting approval for a location to save the workbook.
The (Ctrl + P)shortcut key will display the print pane in the File tab in windows.
The (CTRL + N) shortcut key helps to create a new workbook.
The (Ctrl + O) shortcut key helps to open an existing workbook.
Pressing (CTRL + O) guides you to the open tab, which displays the list of workbooks, from which we can choose the required one.
The (CTRL + F) shortcut key helps to display the “Find” dialog box.
This function helps to find data within a sheet or a workbook, which can be typed here to be searched.
The (CTRL + H) shortcut key helps to Display the “Replace” dialog box.
This function helps to find and replace the found word in the worksheet or Excel file.
The (Ctrl + G)shortcut key is useful to open the “Go to dialog”, it allows us to go to the address or named range that we had applied/supplied.
The “Go to dialog” will return the valid “named range” available in the Excel sheet that is currently opened.
The “Go to” has ‘special’ button which allows us to select cells based on many criteria such as cell with constant, cells with formulas, blank one.
The (Ctrl + G) key helps in time-saving by letting us go directly to specific cells we want.
The (CTRL + B) shortcut key will bold or un-bold the cell when one or more cell is selected.
This shortcut works for the new text you type after using it, or you can highlight existing text and then bold it via the shortcut.
The (CTRL + U) shortcut key will add or remove underline to the content in one or more selected cells.
The (CTRL + I) shortcut key will add italic or remove italic in the cell when one or more cell is selected.
This shortcut works for the new text you type after using it, or you can highlight existing text and then add italics via the shortcut.
We can see that the 15 control shortcut keys discussed in this article give immense time save, besides ease of use and improves efficiency and facilitates quick output. MS Excel has many more of these useful shortcuts which are discussed in our other articles.
Please visit our YOUTUBE channel to view our collection of videos.