Hi all,
Wondering if anyone could help, in an excel spread sheet I need an option to auto-fill certain columns, similar to when you double click the bottom right corner of the cell, only issue is, there’s lots of different values in the column. So I have a certain value in row 2, then blank down to row 16, then in row 17 it’s a different value which I then need to auto-fill all blank cells under until the next value and so on. Is there a way to achieve this? Thanks in advance.
Wondering if anyone could help, in an excel spread sheet I need an option to auto-fill certain columns, similar to when you double click the bottom right corner of the cell, only issue is, there’s lots of different values in the column. So I have a certain value in row 2, then blank down to row 16, then in row 17 it’s a different value which I then need to auto-fill all blank cells under until the next value and so on. Is there a way to achieve this? Thanks in advance.