Excel 2007 Column Row Headings in formulas

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tanya - 29 Jun 2007 19:47 GMT

In earlier versions of Excel, even if they weren't explicitly named I
could use column or row headings to create a formula. For example, if
Mon, Tue, Wed appeared in B1:D1 and various expenses appeared in A2:A5
(ex: wages, mortgage, etc.) I could type Mon Wages in a cell and Excel
would return the value at the intersection of the 2. That's not
working in 2007. I have turned Use label names in formulas from Excel
options on. Not sure why this isn't working. Any suggestions
appreciated. Thanks,

Tanya

Reply to this Message

Roger Govier - 29 Jun 2007 22:40 GMT

Hi Tanya

this is one of the features that ahs been deprecated in XL2007.
You can click on a cell within your table and choose Insert tab>Table.
There are features within a Table (somewhat more verbose) that will
allow you to achieve the same sort of functionality.

Lookup help on
Using structured references with Excel tables

Signature

Regards

Roger Govier

> In earlier versions of Excel, even if they weren't explicitly named I
> could use column or row headings to create a formula. For example, if
[quoted text clipped - 6 lines]
>
> Tanya

Reply to this Message

Rate this thread: