“Ctrl + Shift + F3” keys are used to “create names” for a row or column from the labels of columns and rows. You can create the names for the selected cell or cells from the values of the top row, bottom row, left column, or right column. Once you click Ctrl + Shift + F3, a dialog box will appear asking you to select the option on the basis of which you wan to create the named ranges.
Note – If this function is not accessible in your system use – Ctrl+Shift+Fn+F3
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.
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 + 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 + 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.