Paul Wherly

How to use The Name a Box in Microsoft Excel 2010

Quick Tip for Microsoft Excel 2010

Here are some steps to follow when you want to use The Name a Box in Microsoft Excel 2010.

The Name Box


The name box (1) sits beside the Formula bar and tells you the cell you are currently in.

Naming the cell


It can sometimes make more sense to give a cell or cells a name.

To name a cell:

  1. Select the cell(s) to name (1)
  2. Click into the Name box on the formula bar
  3. Type the name for the cell(s) (2)
  4. Press Enter
[callout]To learn more about The Name Box and to see how we can help your organisation improve their performance with Microsoft Excel give us a call 020 8203 1774[/callout]

Shelley Fishel

Contact us

Would you like to talk through your IT Training needs?
Just send through your details and we'll get back to you.