Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fill in Blanks with immediately above cell value
Hi Everyone,
I want to fill blank cell using the value from above cell. It is like ACC 232 86 251 32 CIS 333 15 241 9 ESE 122 16 222 11 now I want to fill the blank cells in the first column using the value from above cell. The result will be ACC 232 86 ACC 251 32 CIS 333 15 CIS 241 9 ESE 122 16 ESE 222 11 Any instruction, ideas, suggestions are very welcome and appreciated. Thanks. Charles |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fill in Blanks with immediately above cell value
Select the range from ACC down to the last cell in that column.
(Assumption ACC is in A1 so that A2 is the first blank cell) Press F5 Click on SPECIAL Choose Blanks Click OK (this will select all blank cells) type =A1 Press CTRL-ENTER "Charles" wrote: Hi Everyone, I want to fill blank cell using the value from above cell. It is like ACC 232 86 251 32 CIS 333 15 241 9 ESE 122 16 222 11 now I want to fill the blank cells in the first column using the value from above cell. The result will be ACC 232 86 ACC 251 32 CIS 333 15 CIS 241 9 ESE 122 16 ESE 222 11 Any instruction, ideas, suggestions are very welcome and appreciated. Thanks. Charles |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fill in Blanks with immediately above cell value
Highlight your range hit F5 Special Blanks OK type = press up arrow
press ctrl+enter "Charles" wrote: Hi Everyone, I want to fill blank cell using the value from above cell. It is like ACC 232 86 251 32 CIS 333 15 241 9 ESE 122 16 222 11 now I want to fill the blank cells in the first column using the value from above cell. The result will be ACC 232 86 ACC 251 32 CIS 333 15 CIS 241 9 ESE 122 16 ESE 222 11 Any instruction, ideas, suggestions are very welcome and appreciated. Thanks. Charles |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fill in Blanks with immediately above cell value
couple of options.
Assuming ACC is in cell A2, go to cell A3 and enter =A2. Copy A3, highlight column A, Then Edit/Go To/Special/Blanks and paste or.. instead of the edit, etc. add a filter and select blanks and paste. "Charles" wrote: Hi Everyone, I want to fill blank cell using the value from above cell. It is like ACC 232 86 251 32 CIS 333 15 241 9 ESE 122 16 222 11 now I want to fill the blank cells in the first column using the value from above cell. The result will be ACC 232 86 ACC 251 32 CIS 333 15 CIS 241 9 ESE 122 16 ESE 222 11 Any instruction, ideas, suggestions are very welcome and appreciated. Thanks. Charles |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fill in Blanks with immediately above cell value
Hi guys, thank you so much for your prompt response. This is very very
helpful. Thank you all again and have a good weekend. Charles "Sean Timmons" wrote: couple of options. Assuming ACC is in cell A2, go to cell A3 and enter =A2. Copy A3, highlight column A, Then Edit/Go To/Special/Blanks and paste or.. instead of the edit, etc. add a filter and select blanks and paste. "Charles" wrote: Hi Everyone, I want to fill blank cell using the value from above cell. It is like ACC 232 86 251 32 CIS 333 15 241 9 ESE 122 16 222 11 now I want to fill the blank cells in the first column using the value from above cell. The result will be ACC 232 86 ACC 251 32 CIS 333 15 CIS 241 9 ESE 122 16 ESE 222 11 Any instruction, ideas, suggestions are very welcome and appreciated. Thanks. Charles |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Fill blanks down column with cell above | Excel Discussion (Misc queries) | |||
Fill column blanks from last non-blank cell | Excel Discussion (Misc queries) | |||
How do I auto fill long col. filling blanks with last filled cell | Excel Discussion (Misc queries) | |||
Immediately jump to next cell? | Excel Discussion (Misc queries) | |||
How do I auto fill blanks cells immediately below with the same i. | Excel Discussion (Misc queries) |