View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SJ SJ is offline
external usenet poster
 
Posts: 22
Default I can't autofill cells in a column if blank cells in between

When I type in something in a cell, it will not autofill the cells below in
the column if there is a blank cell in between. For example, if I type in
"Done" and go down 2 cells and type in "D" it will not autofill to "Done"
unless I have text in between the 2 cells. How does this happen and how can I
fix it?

Thanks.