naming formula ranges

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 Formula ranges

Naming Formula ranges

resolvedResolved · Low Priority · Version 2003

Ryan has attended:
Excel Advanced course

Naming Formula ranges

How do you add give a formula range a name rather than the cell reference value?

RE: Naming Formula ranges

Hi Ryan

how are you doing today, thanks for your question

There are two ways you can name a range of cells, one is quicker than the other

Here goes 1. Go to the insert menu choose name, then click define, type the name and click add.
2. Click in the name box on the formula bar type the name for the range and press enter

NB: both the above ways essume cell are selected before you name ranges, and 2. make sure the names you call cells have no spaces as Excel won't except them...
Hope this helps


If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn


 

Excel tip:

Change Excel's default font

You can change the default font and font size for all spreadsheets created in Excel by:

1. Going to Tools on the menu bar.
2. Select Options, then General.
3. Next to Standard Font you can change the font and font size.
4. Click OK.

Each new file you start from this point onward should use the font and font size you have selected.

View all Excel hints and tips


Server loaded in 0.09 secs.