Filling only cells for rows with content

C

Colin Hayes

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Fill last row down for large selection? 1
Macro for Selecting Cells within a Range 1
Excel Cannot delete empty cells/rows 4
Totaling columns 4
Moving cells 5
Filling speadsheet with INDIRECT functions? 2
Series fill only copying and fill series greyed out 1
retrieving multiple corresponding values with variable rows/column 4

Top