Ask Your Question

Is there a way to quickly change the row number when doing = B1, = B2, etc. for thousands of rows? [closed]

asked 2016-02-17 17:47:29 +0100

Verd12 gravatar image

updated 2020-08-30 11:02:42 +0100

Alex Kemp gravatar image

This is what I am needing to put into Column A

= B1 & " " & C1 & " " & D1 & " " & E1 & " " & F1 & " " & G1 & " " & H1 & " " & I1

wherein the numbers will correspond to the current row that it is pasted in. Is there a faster way than simply pasting it in and manually changing the 1's to 2's, or to 3's or to 37892's?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-08-30 11:01:41.024651

1 Answer

Sort by » oldest newest most voted

answered 2016-02-19 06:50:44 +0100

LKeithJordan gravatar image

updated 2016-02-19 20:58:52 +0100

If I understand your question, there is nothing you have to do, given the formula as configured, except copy the cell and paste it in the target range (or drag the fill handle to paint the entire range). Here is why:

There are two types of cell adderss referencing: 1) absolute and 2) relative. Absolute cell address references precede column and/or row coordinates with a dollar sign ("$") to indicate to the spreadsheet app that the reference is locked in place. In other words, $A$1 won't change as you copy or move it.

Relative cell addresses, on the other hand, do change as you copy or move them. A reference to cell A1 will change to A3 if moved or copied two cells down from its current location.

I hope this helps.

If you believe my response best answers your question, please click the checkmark next to my response.

edit flag offensive delete link more

Question Tools



Asked: 2016-02-17 17:47:29 +0100

Seen: 215 times

Last updated: Aug 30