If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Fill last row down for large selection?
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. |
#2
|
|||
|
|||
Fill last row down for large selection?
Select Column down to last value
Ctrl-G Special Blanks, OK = Up Ctrl+Enter "msnyc07" wrote in message ... 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. |
Thread Tools | |
Display Modes | |
|
|