Filling only cells for rows with content
 

Hi

I have a small problem , which I hope someone can help with.

I have a sheet with a variable amount of rows. In column P:P I want to
replace blanks cells with the word NULL.

I highlight P:P and press F5 to bring up the Go To dialog. I press
Special and Blanks. This highlights all the blank cells in P:P.

The I type the word NULL in the formula bar and use ctrl and return to
fill the blanks.

The problem is that it fills way down to the bottom of the sheet and not
just against the rows which have content. I only need it fill in to
exactly the amount of rows in the sheet and not right down to the
bottom.

Can someone help? I've tried deleting all the rows beneath the ones with
content , but excel still wants to fill to the bottom...



Best Wishes


Colin

Filling only cells for rows with content
 

select the area before hit F5


"Colin Hayes" skrev:

Hi

I have a small problem , which I hope someone can help with.

I have a sheet with a variable amount of rows. In column P:P I want to
replace blanks cells with the word NULL.

I highlight P:P and press F5 to bring up the Go To dialog. I press
Special and Blanks. This highlights all the blank cells in P:P.

The I type the word NULL in the formula bar and use ctrl and return to
fill the blanks.

The problem is that it fills way down to the bottom of the sheet and not
just against the rows which have content. I only need it fill in to
exactly the amount of rows in the sheet and not right down to the
bottom.

Can someone help? I've tried deleting all the rows beneath the ones with
content , but excel still wants to fill to the bottom...



Best Wishes


Colin