Excel Help

[leftcurl]

Been trying to find how i create a series on excel - i've not used this feature for years and now i need it i can't for the life of me remember where to look. Wood for the trees job i think, plus the fact the layout has changed from the drop down menus to icons in newer versions.

Just to clarify.. if you enter for example 'MON' in A1, then copy down it will autofill with 'TUES, WED, THUR, FRI etc..' and likewise with 'JAN, FEB, MAR, APR'... now there is somewhere that i can create my own autofill series and i can't remember where.

I'd appreciate any help

 

[f1charlie]

Here's how to do it in Excel 2010:

http://www.dummies.com/how-to/content/how-to-use-custom-lists-with-excel-2010s-autofill-.html

and Excel 2007:

http://www.dummies.com/how-to/content/how-to-use-custom-lists-with-excel-2007s-autofill-.html

 

[leftcurl]

flippin nora... excel options!! I never even saw it hiding away at the bottom there :bonk:

cheers Charlie

 

[f1charlie]

No problem, I've learnt something myself (if I ever need to use it!).

 

[david357]

I think it is even easier, if you are using days or dates or years that are evenly spaced to just type some in cells below each other and drag them down.

Try typing Mon in the top left cell, then Tues in the cell below, then Wed in the cell below, etc.

Then select all three cells, and drag downwards from the corner of the bottom (Wed) cell, and the cells below should auto-populate for you.

hth.

ps I know it works as that's the way I create a basic holiday form here!

 

[leftcurl]

yes, thats what i've used it for before, but this time i wanted to create a list of products that i will regularly use.. so i just type the first one in and then it populates with the rest without having to type out every time