Using Fill command in Editing Group

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
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word Template where user inputs <TITLE> and then that can be displayed in footers or headers [MAC] 0
Creating a Search using a combo box and then creating a report. 4
Resctricting editing rights, but allowing those who cant edit, to still copy the slides 0
Accessibilty - how to open doc with keyboard? 0
Template with fields and premade texts.. 0
Function for summing or counting cells based on a specified fill color 3
Auto Fill function in Excel 2007 not working properly 4
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1

Top