naming fields

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Naming fields?

Naming fields?

resolvedResolved · Low Priority · Version Standard

Nirav has attended:
Excel Advanced course

Naming fields?

how do you change the name of an incorrectly named field?

RE: naming fields?

Go to Insert>>Name>>Define and then select from the list the name/range you want to change. Click the delete button. The name/range will be removed and you can then rename the field normally.


 

Excel tip:

Deleting a range of cells using the autofill handle

Firstly, select the range of cells for which you would like to clear the contents. Then drag the autofill handle to the the top left corner of the selection whilst holding down the shift key. Your selected contents should then be deleted.

View all Excel hints and tips


Server loaded in 0.08 secs.