Can anyone explain the point of labels in excel.
I fully understand the point of naming ranges and constants etc but fail to understand why you would want to label a range of cells when Excel already provides labels automatically via the placement of row and column headings.
To explain my point I've put together a simple example
A B C D
1 Jan Feb Mar Apr
2 10 56 2 15
3 45 47 12 8
4 78 45 56 79
5 =SUM(Jan)
In the above example, Cell A5 will correctly calculate 10+45+78. This is because the system reads column A as being called 'Jan'. B is called 'Feb', C is Called 'Mar' and so on.
Therefore, my question is: what is the point of the "Insert/Name/Label" command in Excel 97?
Thankyou
Bri
I fully understand the point of naming ranges and constants etc but fail to understand why you would want to label a range of cells when Excel already provides labels automatically via the placement of row and column headings.
To explain my point I've put together a simple example
A B C D
1 Jan Feb Mar Apr
2 10 56 2 15
3 45 47 12 8
4 78 45 56 79
5 =SUM(Jan)
In the above example, Cell A5 will correctly calculate 10+45+78. This is because the system reads column A as being called 'Jan'. B is called 'Feb', C is Called 'Mar' and so on.
Therefore, my question is: what is the point of the "Insert/Name/Label" command in Excel 97?
Thankyou
Bri