Ask Your Question
0

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

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

Verd12 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 close merge delete

1 Answer

Sort by » oldest newest most voted
1

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
Login/Signup to Answer

Question Tools

2 followers

Stats

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

Seen: 116 times

Last updated: Feb 19 '16