Forum Discussion
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...
Hi,
You can try to double-click the bottom-right corner of the cell where X1 is. That will automatically fill down until X2. However, by default, it will try to fill series. That is, fill like: X1, X2, X3 and so on. What you want to do is:
1) Double-click on the bottom-right corner of the selected cell:
2) Once filled, go to the fill options and select "Copy Cells" instead of "Fill Series":
Do the same procedure for all X's.
If by any chance you cannot click on the bottom-right corner of the cell go to File > Options > Advanced > Make sure the option "Enable fill handle and cell drag-and-drop" is selected.
