PC Review

Thread Tools Rate Thread

Re: How can I refer to a row

Posts: n/a
      5th Jul 2011
On Jul 5, 5:57*pm, Mark F <(E-Mail Removed)> wrote:
> I want to refer to a fixed row in the spreadsheet, but to the column
> that matches the column that the reference is in, but I want to
> use a name for the fixed row.
> for example, Row 2 has the multipliers that I need in the formula, so
> I now have in cell F10
> * * +F$2*{etc}
> For clarity, and perhaps for moving things around, instead of using $2
> as part of the cell reference, I'd like to be able to use a
> "Row label".
> and have something similar to:
> * * +F${Row label}{etc}
> in cell F10
> Does this concept exist?
> I tried Insert > Name > Label
> but it seemed like I could only name a part of a row or a column, not
> define something to be a row number.
> I thought about:
> 1. insert a column,
> 2. label the cell in that column and that row as
> * * *MultiplierRowNumber,
> 3. put +ROW() in the cell MultiplierRowNumber.
> I then might be able to get the value that I am interested in by using
> the ADDRESS function, MultiplierRowNumber, and the number of the
> current cell, but that seemed like it was too complicated to be the
> right way to do things.

EXCEL 2007
Click, for example, the number 2 in row 2 so that the entire row is

Formulas tab / Defined Names group / click on Name Manager.

The Name Manager should open.


New . . .

- in top left hand corner.

Enter, say:-


- in the:-


- field

Click OK then Close.

You can now refer to row 2 as:-


Hope the above helps.

Reply With Quote

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
refer to cell using the value in Row 1 and column A =?Utf-8?B?Q2hpcA==?= Microsoft Excel Programming 3 22nd Jun 2005 04:45 PM
How do I refer to a non-empty row range in Excel =?Utf-8?B?SGVucnkgU2FuIERpZWdv?= Microsoft Excel Misc 1 2nd Jun 2005 09:06 PM
how to write a macro, to refer to a last row in a file, in which . =?Utf-8?B?cmFqaQ==?= Microsoft Excel Misc 12 1st Oct 2004 05:39 PM
Inserting a row in sheet A should Insert a row in sheet B, removing a row in Sheet A should remove the corresponding row in sheet B Hannes Heckner Microsoft Excel Programming 1 5th Mar 2004 10:10 AM
How to refer to latest row added? Doug Mc Microsoft Excel New Users 2 2nd Feb 2004 02:16 AM




All times are GMT +1. The time now is 07:23 AM.