|
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-2013 | Top |