I have a cell in row1 that reference another sheet i.e. =Sheet1.G12
I wish to copy this cell to another 65429 rows in this column and have them all increment i.e. Sheet1.Gxxxxxx
Is there a way to do this without trying to select 65429 rows?
Got this comment
“What do you want to increment - the value to be added or the row number of the reference?. And what is your problem with selecting 65429 cells in a column? Just add A2:A65430 into the name field box leftmost of the formula bar and ENTER and you have selected 65429 cells below A1”
I want row2 to contain =Sheet1,G13
row3 to contain = Sheet1.G14 etc
All the way upto Sheet1.G65442
If I select the cell in row1, then click on copy, I don’t then see how to enter the range to 65429
Sorry - I deleted my comment, after having read you question a third time and all of a sudden it was clear to me. Please see my answer.
Hello,
do the following (assuming A1 is the first cell referencing =Sheet1.G12
- Click into the name box leftmost of the formula bar --or –
CTRL+SHIFT+F5 - Enter the range where you want your formula (including the one which already has defined it; here
A1):A1:A65429 - Press
ENTERandCTRL+D(or useSheet -> Fill Cells -> Fill DownafterENTER)
Screenshot Select Range via Name Box
Hope that helps.
If the answer helped you to solve your problem, please click the check mark (
) next to the answer.