Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel xp training - Naming ranges

excel xp training - Naming ranges

ResolvedVersion Standard

Tue 20 Mar 2007, 12:28 Delegate Erica said...

Erica has attended:
Excel Advanced course

Naming ranges

I am having difficulty replacing formulas with names. I have defined the name and they show in the box but when i go to apply the named range it says it can't find a reference. can you help?

Thu 22 Mar 2007, 13:43 Trainer Richard said...

RE: Naming ranges

I suggest creating a new formula, from scratch, using the actual range, and then using the apply command to see if you can get it to work.

Another step could be to check that the original formula contains exactly the same range as the named range.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

No Zeros

Want all the zeros in your worksheet to appear blank? Choose Tools/Options, Click on the View Tab, Deselect the Zero Values Option, Click OK.
Easy wasn't it? But be aware that these cells are not actually blank, they still contain the value zero. This is important because certain functions (ie AVERAGE) make a distinction between blank cells and those with a zero value.

View all Excel hints and tips

excel xp training - Naming ranges

Naming ranges

RE: Naming ranges

Excel articles

Excel tip:

No Zeros