excel advanced applying

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel Advanced - Applying Names

Excel Advanced - Applying Names

resolvedResolved · Low Priority · Version 2003

Excel Advanced - Applying Names

Hi,
I am reading the reference manual and page 5 talks about applying names.
I do not understand this section, how it is useful or what I am supposed to do.

Can someone please help me?

Thank you

Stefania

Edited on Mon 15 Dec 2008, 10:03

RE: Excel Advanced - Applying Names

Hi Stefania,
Thank you for your question;
In answer: We use names to give unique properties to our cells or ranges of cells. When you name a cell or range that name becomes unique throughout the workbook and can be used in a formula or function. (Or to put it another way) If you consider an absolute cell reference which is fixed in a worksheet formula, a named cell would be fixed through the workbook....I hope that helps..

RE: Excel Advanced - Applying Names

Hi Pete,
thank you for your reply.
I will practice this evening about it.

Kind regards

Stefania


 

Excel tip:

Charts

Select the data and press the function key F11 and the chart will be created on a separate worksheet.

View all Excel hints and tips


Server loaded in 0.08 secs.