View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
ShaneDevenshire ShaneDevenshire is offline
external usenet poster
 
Posts: 2,344
Default Auto Fill Blank Cells

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.

--
Thanks,
Shane Devenshire


"Kathy" wrote:

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?