Microsoft excel

Resolved · Low Priority · Version 2003

Fri 9 May 2008, 16:47 Delegate Francis said...

Francis has attended:
Excel Advanced course
Excel VBA Intro Intermediate course

Microsoft excel

Any good keyboard shortcuts?

Fri 9 May 2008, 23:55 Trainer Pete said...

RE: Microsoft excel

Hi Francis, welcome to the forum, thank you for your post, in answer to your question, there are literally hundreds of them, if you press the Alt key and the underlined character on the Menu it will open, then pressing the next underlined character will action that command for example ALT+T,O will open the Options dialog box from the Tools menu - if you are serious about keyboard commands try this website http://office.microsoft.com/en-gb/excel/HP052037811033.aspx

regards Pete

Excel tip:

Create your own custom list on Excel 2010!

If you know how to use the auto-fill option on Excel then why not create your own customs lists?

The auto fill feature saves you time by allowing you to enter one of the list entries into a cell and then use your mouse to automatically drag the rest of the list into the cells below, above or to either side of the initial cell. When using your mouse to perform this task you will see a thin black cross appear at the bottom right hand side of the cell. Click, hold and drag to make the list appear.

Default lists include weekdays and months. To create your own list in Excel 2010 do the following;

>File
>Options
>Advanced
>Scroll right to the bottom of the page and you will see a buttom "edit custom lists", click this button
>enter your list in the list entries
>click add

Now try it out. Good luck.
>

View all Excel hints and tips

Microsoft excel

Microsoft excel

RE: Microsoft excel

Excel articles

Excel tip:

Create your own custom list on Excel 2010!