Forum Discussion
gty1992
Nov 07, 2020Copper Contributor
How to autofill a column with multiple values
Hi, I have a spreadsheet with 5000 rows. Each group with a value and I need to fill down each cell with the name of the same family group. How can I do that? Thanks
Riny_van_Eekelen
Platinum Contributor
Marra93 I think it contains a typo. It should have read:
"4) Now, enter =B2 and press Ctrl-Enter"
What I meant to write is that when you have selected all the blank cells (step 3) and the active cell is B3, enter the formula =B2 and then Ctrl-Enter.
Sorry about that.
Marra93
Mar 10, 2021Copper Contributor
Riny_van_Eekelen You wonderful man...I could just kiss you right now! XOXOXO