How would I fill blank cells with the data from a previous cell?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Need to fill blank cells in a column with the data from the previous
non-blank cell in Excel 2000. Used to do this in Lotus. Can't seem to get it
in Excel
 
One way, assuming you mean you have

data
blank
data
blank

or something like that and you want the cell with data to fill in the blanks
below them?

Select the whole range, press F5, select special and blanks,
type equal sign, click on the first cell with data in the selected range,
press ctrl + enter
This will put a formula in the blanks cell refering to the cells above them,
if you want to remove the formula just copy and paste special as values in
place

Regards,

Peo Sjoblom
 
You must log in or register to reply here.

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

How To Have A Cell Be Blank If... 2
Need Array Formula for Counting Blank & Non Blank Cells (Multiple Criteria) 1
Question about conditional formatting of zeros in Excel 0
problem filling in blank cells with data above - 1
How do I fill a Cell with a symbol 1
Auto Filter - how to collapse "non-blank" cells in a column? 2
find blank cell and replace with " ' " 2
Need macro to move to first blank cell in column 6

Back
Top