Filling in blank cells with cell above
 

I have a column and I would like to fill the cells below it with the same
data as above. Sometimes there are more than one blank row below the Policy
number.

Column A
Policy
line 1 20BSBEX3110
line 2
line 3 20BSBEX9371
line 4
line 5 BINDER8083096
line 6
line 7
line 8
line 9 BINDER8083096
Line 10
Line 11

Thanks
Donna

Filling in blank cells with cell above
 

Select the whole range of cells making up your data (A1:A11 in your example).
Press F5, then click Special Blanks OK. Now all the blank cells within
your
data are selected. Press the equal sign (=), then the up arrow. Hold down
the Ctrl key and press Enter. This puts a formula in every blank cell,
pulling the value from the cell above it. Finally, copy & paste the whole
selected range in place as values.

Hope this helps,

Hutch

"Donna" wrote:

I have a column and I would like to fill the cells below it with the same
data as above. Sometimes there are more than one blank row below the Policy
number.

Column A
Policy
line 1 20BSBEX3110
line 2
line 3 20BSBEX9371
line 4
line 5 BINDER8083096
line 6
line 7
line 8
line 9 BINDER8083096
Line 10
Line 11

Thanks
Donna

Filling in blank cells with cell above
 

Tom,
Thank you so much! It worked perfectly!
Donna

"Tom Hutchins" wrote:

Select the whole range of cells making up your data (A1:A11 in your example).
Press F5, then click Special Blanks OK. Now all the blank cells within
your
data are selected. Press the equal sign (=), then the up arrow. Hold down
the Ctrl key and press Enter. This puts a formula in every blank cell,
pulling the value from the cell above it. Finally, copy & paste the whole
selected range in place as values.

Hope this helps,

Hutch

"Donna" wrote:

I have a column and I would like to fill the cells below it with the same
data as above. Sometimes there are more than one blank row below the Policy
number.

Column A
Policy
line 1 20BSBEX3110
line 2
line 3 20BSBEX9371
line 4
line 5 BINDER8083096
line 6
line 7
line 8
line 9 BINDER8083096
Line 10
Line 11

Thanks
Donna