Leading the way in Microsoft Office Development

Basic

 -

Getting Started

 -

Cell References

 -

Cell References - Types

 -

Cell References - Inserting

 -

A1 or R1C1 Notation

 -

Calculation

 -

Formula Errors

 -

Tracing Formula Errors

 -

Conditional Formulas

 -

Useful Formulas

 -

Mega Formulas

Advanced

 -

Error Checking Smart Tag

 -

Automatic Cell Formatting

 -

Automatic Formula Expansion

 -

Formula Comments

 -

Arrays in Formulas

 -

3D Formulas

 -

Hiding your Formulas

 -

Advanced Techniques

 -

Office Online

 -

Knowledge Base

Shortcut Keys

(F2) - Allows you to edit the cell directly without using the Formula Bar.

(F4) - Lets you toggle between relative, absolute and mixed cell references when in the formula bar.

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

(Ctrl + Shift + A) - Inserts argument names given a function in the formula bar.

(Ctrl + ' ) - Toggles between displaying cell values and formulas (single left quotation mark).

Tools > Options

(Calculation tab, Calculation) - Lets you change the if a workbook is calculated automatically when a workbook is opened or saved or whether it is done manually using F9. If you have a large worksheet containing complex functions then it may be worth changing your calculation mode to Manual.

(Edit tab, Extend data range formats and formulas) - Formulas that contain references to ranges will be automatically expanded when new cells are inserted to the right or below the existing range. This only works when cells are inserted immediately below or to the right of a referenced range.

(General tab, R1C1 Reference Style) - Displays your columns as numbers and not as letters.

(View tab. Formulas) - Displays all the formulas on the active worksheet. All the columns will double in width.

Related Topics

 -

Array Formulas

 -

Auditing