Using Fill command in Editing Group

  • Thread starter Thread starter Caz
  • Start date Start date
C

Caz

Hi,

I am trying to find more info on how to use the functions on the Fill
Command in the Editing group especially regarding dates as I cannot seem to
get this to work.

I know how to fill using the drag handle but would also like to use the fill
command.

If anyone can guide me to a site which discusses this command that would be
good.

Thanks
 
Enter a date in A1

Select A1:A20 and Edit>Fill>Series

Choose from options.

Do you want an increment of one day, weekday, one week, step of 2 or
wharever?

Play with it and see the various fills.


Gord Dibben MS Excel MVP
 
Back
Top