Friday, 26 September 2014

Working With Formulas In Excel

Excel spreadsheets are often used to crunch numbers. To do this, one must understand the basics of formulas. Whether calculating sums or averages, these shortcuts will help users be more efficient in formula creation and use.
Start a formula
Alt + =
Insert the AutoSum formula
Shift + F3
Display the Insert Function dialog box
Ctrl + a
Display Formula Window after typing formula name
Ctrl + Shift + a
Insert Arguments in formula after typing formula name
Shift + F3
Insert a function into a formula
Ctrl + Shift + Enter
Enter a formula as an array formula
After typing cell reference (e.g. =E3) makes reference absolute (=$E$4)
Calculate all worksheets in all open workbooks
Shift + F9
Calculate the active worksheet
Ctrl + Alt + F9
Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation
Ctrl + Alt + Shift + F9
Recheck dependent formulas, and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated
Ctrl + Shift + u
Toggle expand or collapse formula bar
Ctrl + `
Toggle Show formula in cell instead of values
Ctrl + F3
Define a name or dialog
Ctrl + Shift + F3
Create names from row and column labels
Paste a defined name into a formula

No comments:

Post a Comment