Auto Fill Blank Cells

  • Thread starter Thread starter Kathy
  • Start date Start date
K

Kathy

I have read many of the posts, but in Excel 2003, all I had to do was double
click on a cell and it automatically repeated the contents filling in the
blank cells. In 2007, this feature is not working. Any idea what I'm
missing?
 
Hi Kathy,

This feature still works in 2007 the same was as in earlier versions.

Remember there are two restrictions on this command:
1. It only works in the down direction
2. It needs an adjactent column of solid data to tell it how far down to go.
(There is one exception to this but its obscure). This second one is
probably what's causing you a problem.
 

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

Excel 2007 auto fill help 1
Filling in blank cells with information from cells above it 1
How To Have A Cell Be Blank If... 2
How to auto fill cells in column 1
Question about conditional formatting of zeros in Excel 0
problem filling in blank cells with data above - 1
Need macro to move to first blank cell in column 6
Fill blanks down column with cell above 2

Back
Top