Microsoft Office Development and Consultancy
 Home|

Excel

|VBA|C#|Finance|Tools|Newsletter|Feedback|Contact 
 Excel > Formulas< Previous | Next > 

 

Basic

 
Expand

 -

Getting Started

Step By Step

 -

Cell References

Step By Step

 -

Cell References - Types

Step By Step

 -

Cell References - Inserting

Step By Step

 -

A1 or R1C1 Notation

Step By Step

 -

Calculation

Step By Step

 -

Formula Errors

Step By Step

 -

Tracing Formula Errors

Step By Step

 -

Evaluating Formulas

Step By Step

 -

Conditional Formulas

Step By Step

 -

Useful Formulas

Step By Step

 -

Mega Formulas


 

Advanced

 
More Details

 -

Cell References - Dynamic

More Details

 -

Automatic Cell Formatting

More Details

 -

Automatic Formula Expansion

More Details

 -

Formula Comments

More Details

 -

Arrays in Formulas

More Details

 -

3D Formulas

More Details

 -

Hiding your Formulas

More Details

 -

Advanced Techniques

More Details

 -

Version Changes

More Details

 -

Office Online

More Details

 -

Knowledge Base

More Details

 -

Knowledge Base - Numerical

More Details

 -

VBA Code


 

Shortcut Keys

 
 

(Ctrl + [) - Selects all the cells that are directly referred to by the formula in the active cell (precedents).

 
 

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

 
 

(Ctrl + ' ) - Enters the formula from the cell directly above into the active cell.

 
 

(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.

 

 

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 Sections

 
GoTo

 -

Array Formulas

GoTo

 -

Auditing


 © Better Solutions Limited 10-May-2013Top