Fill last row down for large selection?
in [Functions]
|
Prev: Excel - Convert int value secs past midnight into time 53100=2:45
Next: I type in a number in a cell but it wont convert to currency help
From: msnyc07 on 27 May 2010 17:30 A few months ago someone posted a great solution for the following problem which doesn't seem to be working all of a sudden; I have a column with values which has blank rows between values (anywhere from 1 to 10 blank rows) and I need to fill those with the values of the last cell with a value i.e. from AAA BBB CCC DDDD to A few months ago someone posted a great solution for the following problem which doesn't seem to be working all of a sudden; I have a column with values which has blank rows between values (anywhere from 1 to 10 blank rows) and I need to fill those with the values of the last cell with a value i.e. from AAA AAA BBB BBB BBB CCC CCC CCC CCC DDDD I thought the process had been: Select Column down to last value Ctrl-G Special Blanks Shift-Ctrl Up Fill Down But that only fills all the blanks with the first value encountered. I know I am missing on obvious step here but I cannot recall, any insight appreciated.
From: Steve Dunn on 28 May 2010 10:33
Select Column down to last value Ctrl-G Special Blanks, OK = Up Ctrl+Enter "msnyc07" <msnyc07(a)discussions.microsoft.com> wrote in message news:94FF3A93-7214-4BF7-BC47-F3CAB0FD3E59(a)microsoft.com... >A few months ago someone posted a great solution for the following problem > which doesn't seem to be working all of a sudden; > > I have a column with values which has blank rows between values (anywhere > from 1 to 10 blank rows) and I need to fill those with the values of the > last > cell with a value i.e. from > > AAA > > BBB > > > CCC > > > > DDDD > > to > > A few months ago someone posted a great solution for the following problem > which doesn't seem to be working all of a sudden; > > I have a column with values which has blank rows between values (anywhere > from 1 to 10 blank rows) and I need to fill those with the values of the > last > cell with a value i.e. from > > AAA > AAA > BBB > BBB > BBB > CCC > CCC > CCC > CCC > DDDD > > I thought the process had been: > > Select Column down to last value > Ctrl-G > Special > Blanks > Shift-Ctrl Up > Fill Down > > But that only fills all the blanks with the first value encountered. I > know > I am missing on obvious step here but I cannot recall, any insight > appreciated. |