Shortcuts

How to Create Name Ranges from the Selection in Excel?

Pinterest LinkedIn Tumblr
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

Related Posts

Write A Comment