How to Edit or Modify Named in Excel

How to Edit or Modify Named in Excel

1.    Open Microsoft Excel in your computer.

2.    Click “Formulas” and the Click “Name Manager”

3.     Select Name which you want to edit or Modify. Click to Edit or Press alt+e

4.       Edit Name if there is any dispute.

5.      Modify Reference cell range if you modify table in excel.

6.      Click “Ok”

7.      Click “Close”

Take an Example:

Let you have an Excel sheet name as MARK SHEET of the student in STUDENT DATA Workbook.

In the above excel sheet you can easily find that maximum number 98 obtain by Roll Number R202003923 in Mathematics. The Cell reference (C2:I11) Name as MARKSHET. To know how to create name in excel please click How-to-create-named-ranges-in-excel

To get Maximum number you use the formula =max(MARKSHET) and get 98 as shown in above picture.

After some time you add two students in the table along with their mark in mark sheet and you can see that now maximum number 99 obtain by R202003933 in Physics.

Now if you use the formula =max(MARKSHET) you will get 98 which is wrong. To get correct data you need to change NAME cell reference (C2:I13) (start cell:last cell) in your work sheet or workbook.

To Modify or edit Name open “Name Manager”

Select “MARKSHET” and Click to Edit or press alt+e.

Edit Name dialog Box open on your screen

Now you can edit Name from MARKSHET to MARKSHEET (correct name if required) and Refers to =Sheet3!$C$2:$I$11 to =Sheet3!$C$2:$I$13 and Click “OK”.

Name changes successfully. Now you use the formula =max(MARKSHEET) you will get 99, the correct answer.