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
Nov 07, 2020Platinum Contributor
gty1992 This could be done as follows:
1) Select the range B2:B5000 (or whatever your exact range may be)
2) Press F5 (Go to, Special, Blanks)
3) This should select all blank cells in the range with the active cell in B3
4) Now, in =B2 and press Ctrl-Enter
Edit: 4) Now, enter =B2 and press Ctrl-Enter
5) All blank cells will now contain a formula pointing to the cell directly above it.
6) Copy column B and paste as values on top of itself if you don't want to keep the formulae.
Alternatively, use "Get & Transform Data" (a.k.a. Power Query "PQ") if this is recurring process on a data set that might be a bit more complex than what you described above. PQ has a standard function for "Fill Down"
mostafarez062
Sep 07, 2021Copper Contributor
It is work thanks pro