Forum Discussion

Copper Contributor

May 13, 2024

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...

excel

Riny_van_Eekelen

Platinum Contributor

May 13, 2024

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.

Chris525

Copper Contributor

May 13, 2024

Hi,

Thank you for the quick reply.

Sorry I couldn't understand the step 2 and 3.

Thanks