Change Name Range In Excel

Name range is of the most useful features in excel.The challenge in our day to day excel activities are that we do not have fixed data table, data may vary from pint to point hence the range that has been defined on that particular data table has to be edited in order to include those new rows of additional data.

Changing name range is an easy task with couple of steps mentioned below.

Let’s see how to change the name of an already defined range in excel.

We have a name range called “Customer” and we would like to change the name of the range to “CustomerArchive”.

Capture

Step 1




Press keyboard shortcut Ctrl+F3 to open the Name Manager in excel and select the name range to change its name and click on the Edit button.

Capture

Step 2

Enter the new name for the range in the Name box, in this case I have typed “CustomerArchive”.

Capture

And press OK, your name range has been renamed.

Hope this helped.

Share The Knowledge

Random Posts

  • Find Some Values And Make Them Bold in Excel

    find some values inn excel and make them bold, how to make some values bold in excel, vba to find some values and make them bold, make a list of values bold in excel

    Share The Knowledge
  • Create Files From Cell Content In Excel

    how to create file content from cell content i excel, excel vba to create file names from cell content, vba to create files from cell content, how to name file from cell content.

    Share The Knowledge
  • Make Certain Character Bold In A Cell In Excel

    make certain characters bold in excel, vba to make some characters in a cell bold, make substring bold in a cell, make a substring bold in a cell.

    Share The Knowledge
  • VBA Loop Is Missing Rows While Deleting Rows

    vba loop is missing rows while deleting records,. excel vba loop is skipping rows to be deleted, vba loop is deleting records but is also missing records, vba to delete records in loop based on some condition

    Share The Knowledge

Leave a Reply