Leading the way in Microsoft Office Development

Excel

Basic

 -

Getting Started

 -

Task Panes

 -

Displaying Workbooks

 -

Saving Workbooks

 -

Hiding Workbooks

 -

Workbook Properties

 -

File > Open Dialog Box

 -

File > Save As Dialog Box

 -

Status Bar

Advanced

 -

File Search

 -

Workspaces

 -

Comparing Workbooks

 -

Consolidating Workbooks

 -

Corrupted Workbooks

 -

Document Recovery Task Pane

 -

Reducing the File Size

 -

Startup Switches

 -

Advanced Techniques

 -

Office Online

 -

Knowledge Base

Excel 2002

 -

Task Panes 2002

 -

Saving Workbooks 2002

Shortcut Keys

(F9) - Calculates all the worksheets in all the open workbooks.

(Ctrl + Tab) - Moves to the next open workbook or window.

(Ctrl + F6) - Moves to the next open workbook or window.

(Ctrl + F9) - Minimise the size of the active workbook.

(Ctrl + F10) - Maximise the size of the active workbook.

(Ctrl + Shift + F6) - Moves to the previous open workbook or window.

Tools > Options

(General tab, Default file location) - Lets you change the directory that the (File > Open) and (File > Save As) dialog boxes default to.

(General tab, Recently used files list) - Lets you change the number of workbooks displayed at the bottom of the File menu.

(General tab, Sheets in new workbook) - Lets you change the default number of worksheets in a new workbook.

(General tab, User Name) - Lets you enter your username. This will automatically appear in the (File > Properties)(Summary tab) when you create a new workbook. It enables you to keep track of who creates the workbooks.

(Transition tab, Save Excel files as) - Lets you change the type of file that the (File > Save As) dialog box defaults to.

(View tab, Windows in task bar - Displays all your workbooks and windows as separate items on the task bar.

Related Topics

 -

Printing

 -

Worksheets