Thread: Autofill Format
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Autofill Format

If you rightclick and drag that autofill button, you'll see a bunch of options.
Maybe one of them will be what you want.



Fozzie Bear wrote:

Is there a way to use the fill handle to autofill, but do so without changing
the formatting of the cells--adding data only?

I'm trying to avoid having the fill colors, width of gridlines, and
everything else change when I autofill?

Thanks.


--

Dave Peterson