Forum Discussion
Chris525
May 13, 2024Copper Contributor
Repeating the cell values
HI, I tried to fill the Column A by dragging the cells. However, I have more than 7000 rows. Please advice how can I repeat the Column A values without dragging the cells down Column A Co...
Riny_van_Eekelen
May 13, 2024Platinum Contributor
Chris525 Let's assume that "X1" is in cell A1.
1) Select A1 to A7000
2) F5, Special..., Blanks
then it looks like this:
3) With A2 as the Active cell, enter =A1 and conform with Ctrl-Enter
This fills the empty cells with formulas referencing the 'cell above'. Copy A1:A7000 and past back as values to get rid of the formulas.
- Chris525May 13, 2024Copper ContributorHI Riny,
I understood the steps now. Its working for me. Thank you so much.
Another question: Lets say my cell A2 has values (Is not blank). How can I modify the step 2?
Column A
X1
1
2
3
5
6
7
8
13
15
16
17
X2
1
2
3
5
6
7
Thanks - Chris525May 13, 2024Copper ContributorHi,
Thank you for the quick reply.
Sorry I couldn't understand the step 2 and 3.
Thanks