Forum home » Delegate support and help forum » Microsoft Excel Training and help » Autofill

Autofill

ResolvedVersion 2003

Wed 25 Feb 2009, 16:40 Delegate Hannah said...

Hannah has attended:
Excel Intermediate course

Autofill

Some formatting seems to affect autofill - what type of formatting makes autofill effectively patterned as opposed to 'predictive' filling e.g instead of dragging the number 10 down, it changes the next row to 11

Sat 28 Feb 2009, 19:01 Trainer Cress said...

RE: Autofill

Hello Hannah
Thank you for your question

Formatting the column as number means the autofil with numbers will not increase with each row. Formatting the column as text means the autofill will add one to the number with each row.

If this resolves your question, please mark it as resolved. If not, please reply with more information.

Kind regards
Cress

Mon 9 Mar 2009: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Showing all menu items

If you go into a pull down menu you usally find that you get a selection of items(this is the default) or sometimes everything. If you only get a selectiopn you have to go to the double arrows at the bottom of the menu and click it to get all of the hidden items.
To turn this off so that you always get everything, go to Tools / Customize / Options Tab / "Always show full menus". Make sure there is a tick in the box and you will always have every item.

View all Excel hints and tips

Autofill

Autofill

RE: Autofill

Excel articles

Excel tip:

Showing all menu items