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

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

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

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

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