View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ed9213 ed9213 is offline
external usenet poster
 
Posts: 7
Default Auto Fill Defaults

Office Excel 2003 allows copying of cell contents with Cell Drag and Drop.
This works flawlessly for me with text, but with numbers, it automatically
creates a series, incrementing by one. I have to manually choose the Copy
Cells button from the Auto Fill Options box that comes up after the Drag and
Drop.

I seldom have to create series increments, but have to copy cells many
times, like general ledger account numbers, that cannot be incremented.

Can the default for the Auto Fill Options box be changed to Copy Cell
instead of Fill Series?

Thanks.
--
ed