![]() |
Leading the way in Microsoft Office Development |
| Home | | | Excel | | | Word | | | PowerPoint | | | Consultancy | | | Feedback | | | Contact |
| Microsoft 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 | - | Conditional Formulas |
| Step By Step | - | Useful Formulas |
| Step By Step | - | Mega Formulas |
Advanced |
| More Details | - | Error Checking Smart Tag |
| 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 | - | Office Online |
| More Details | - | 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 |
| GoTo | - | Array Formulas |
| GoTo | - | Auditing |
| Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved. | Top |