Advanced Excel Keyboard Shortcuts for PC and Mac Free Download
Advanced Excel Keyboard Shortcuts 2016 Free Download
Today, I would like to share Advanced Excel Keyboard Shortcuts for the Microsoft Excel users. These Micorsoft Excel short keys will make their easier and fast. It improve productivity and workflow. These shortcuts are collecting from reliable sources and professionals. Advanced Excel Keyboard Shortcuts Free Download are 100% working for all Excel files and spreadsheets. They don’t need to do any task with manual functions and settings. They just use short keys and change settings in less time. Advanced Excel Keyboard Shortcuts Download are useful for all users like Home users, professionals, Office users and also Students. We share all short keys in the form of MS Word File in our download links. You just download this file in your PC and extract in any device. Some of these shortcuts are as under:
Creating Formulas:
MAC Users:
Delete | Edit the active cell and then clear it, or delete the preceding character in the active cell as you edit the cell contents |
Return | Complete a cell entry |
Ctrl + a | Display the Formula Builder after you type a valid function name in a formula |
Ctrl + Shift + Return | Enter a formula as an array formula |
Esc | Cancel an entry in the cell or formula bar |
Shift + F3 | Open the Formula Builder |
⌘ + k | Insert a hyperlink |
Ctrl + u | Edit the active cell and position the insertion point at the end of the line |
= | Start a formula |
⌘ + = | Calculate all sheets in all open workbooks |
⌘ + Shift + = | Calculate the active sheet |
Ctrl + ; (semicolon) | Enter the date |
⌘ + t | Toggle the formula reference style between absolute, relative, and mixed |
⌘ + Shift + t | Insert the AutoSum formula |
Ctrl + ` (grave accent) | Alternate between displaying cell values and displaying cell formulas |
⌘ + ; (semicolon) | Enter the time |
Ctrl + Shift + ” (quotation marks) | Copy the value from the cell above the active cell into the cell or the formula bar |
Ctrl + l | Define a name |
Ctrl + Option + Arrow Down | Display the AutoComplete list |
Ctrl + ‘ (apostrophe) | Copy a formula from the cell above the active cell into the cell or the formula bar |
WINDOWS Users:
= | Start a formula |
Alt + = | Insert the AutoSum formula |
Ctrl + Shift + a | Insert Arguments in formula after typing formula name |
Ctrl + a | Display Formula Window after typing formula name |
Shift + F3 | Display the Insert Function dialog box |
Ctrl + Shift + Enter | Enter a formula as an array formula |
Shift + F3 | Insert a function into a formula |
Shift + F9 | Calculate the active worksheet |
F4 | After typing cell reference (e.g. =E3) makes reference absolute (=$E$4) |
F9 | Calculate all worksheets in all open workbooks |
Ctrl + Shift + u | Toggle expand or collapse formula bar |
Ctrl + ` | Toggle Show formula in cell instead of values |
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 + Alt + F9 | Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation |
Names
Ctrl + Shift + F3 | Create names from row and column labels |
Ctrl + F3 | Define a name or dialog |
F3 | Paste a defined name into a formula |
You can easily know about more shortcuts from Advanced Excel Keyboard Shortcuts word file that I share in download links.
Full Tutorial:
Free Download Advanced Excel Keyboard Shortcuts PDF for PC and Mac From Links Given Below.