Create Name Ranges from the Selection

“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

Create Name Ranges from the Selection
Amazing 15 Keyboard Shortcuts in MS

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:

Ctrl + C – Copy the text or value in a workbook

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.

Ctrl + X – Cut selected cells

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.

Ctrl + V – Paste content from clipboard

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

Ctrl + S – Save workbook

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.

Ctrl + P – Print file

The (Ctrl + P)shortcut key will display the print pane in the File tab in windows.

Ctrl + N – Create new workbook

The (CTRL + N) shortcut key helps to create a new workbook.

Ctrl + O – Open 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.

Ctrl + Z – Undo last action

The Undo shortcut key in Excel (CTRL + Z) helps to undo the previous action
Undo (CTRL + Z) will not be possible when the file is in edit mode (F2)

Ctrl + Y – Redo last action

The Redo Shortcut Key In Excel (Ctrl + Y) Or (F4) Helps to reverse the previous Undo Actions
This Shortcut Key will Work Only when there has been an Undo action at least once.

Ctrl + F – Find the Data

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.

Ctrl + H – Replace the Data

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.

Ctrl + G – Display GO TO dialog box

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.

Ctrl + B – Apply or remove bold

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.

Ctrl + U – Apply or remove underline

The (CTRL + U) shortcut key will add or remove underline to the content in one or more selected cells.

Ctrl + I – Apply or remove italic

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.