Here you will find Excel Shortcuts Formulas (vlookup, hlookup) and Basic function Keys self made shortcuts.
Basic Excel Features | |
Ctrl+s | Save the active file with its current file name, location, and file format. |
Ctrl+p | Print File (Opens print menu). |
Ctrl+o | Open File. |
F12 | Display the Save As dialog box. |
f10 (or alt) | Turnkey tips on or off. |
F1 | Display the Excel Help task pane. |
F7 | Display the Spelling dialog box. |
Alt+F11 | Open the Visual Basic Editor to create Macros. |
Shift+F7 | Display the Thesaurus dialog box. |
Alt+F8 | Display the Macro dialog box. |
Inside Worksheets | |
Ctrl+g or F5 | Display the ‘Go To’ dialog box. |
Shift+F4 | Repeat last find. |
Tab/Shift+Tab | Move one cell to the right / to the left in a worksheet. |
Alt+Page Down/Alt+Page Up | Move one screen to the right / to the left in a worksheet. |
Edit Cells | |
Shift+Enter | Move UP |
F2 | Edit the active cell with cursor at end of the line. |
Ctrl+; | Insert current date. |
Ctrl+Shift+: | Insert current time. |
Copy Data From above and right side row Making Chart | |
Alt+F1 | Create and insert chart |
Shift+F2 | Insert / Edit a cell comment. |
Ctrl+Shift++ | Insert Cell/Row/Column Menu |
Ctrl+k | Insert a hyperlink. |
F11 | Create and insert chart in a separate Chart sheet. |
Ctrl+l | Display Create Table dialog box |
Ctrl+- | Delete Cell/Row/Column Menu |
Ctrl+” | Copy above cell values |
Ctrl+r | Copy cell from the left |
Ctrl+’ | Copy above cell formulas |
Ctrl+d | Copy above cell |
Hide and Show Elements | |
Alt+Shift+Arrow Right | Group rows or columns. |
Ctrl+Shift+0 | Unhide any hidden columns within the selection. |
Ctrl+Shift+9 | Unhide any hidden rows within the selection. |
Ctrl+9 | Hide the selected rows. |
Ctrl+0 | Hide the selected columns. |
Format Data | |
Ctrl+u or ctrl+4 | or remove an underline. |
Ctrl+5 | or remove strikethrough formatting. (example) |
Ctrl+Shift+f | Font adjustment |
Ctrl+I or ctrl+3 | or remove italic formatting. |
Ctrl+b or ctrl+2 | or remove bold formatting. |
Ctrl+1 | Format cells dialog. |
Ctrl+Shift+% | Percentage format with no decimal places. |
Ctrl+Shift+! | Number format with two decimal places, thousands separator. |
Ctrl+Shift+~ | General number format. |
Ctrl+Shift+@ | Time format with the hour and minute, and indicate A.M. or P.M. |
Ctrl+Shift+$ | Currency format. Ex. $1,231.00 |
Ctrl+Shift+# | Date format with the day, month, and year. Ex. 10-october-2014 |
Self Shortcut | |
Paste special | Alt+h then type v (P – past, F- Formula,O- formula and Number formatting, K- Keep Source Formatting) |
Alt+ N | Insert Menu |
Alt+ P | Page Layout Menu |
Alt+ M | Formulas Menu |
Alt+ A | Data Menu |
Alt+ R | Review Menu |
Alt+ V | View Menu |
Setting Names
Ctrl+F3 | Define a name or dialog. |
Ctrl+Shift+F3 | Create names from row and column labels. |
F3 | Paste a defined name into a formula. |
Formulas | |
| = | It will Start a formula (basic) |
Ctrl+a | Select All |
Shift+F3 | Display the Insert Function dialog box. |
Alt+= | Insert the AutoSum formula.Ex = sum(). |
F4 ( while applying Vlookup ) | It will freeze cell reference (e.g. =B69) makes reference absolute (=$B$70) |
Shift+F3 | Insert a function into a formula . |
F9 | Calculate all worksheets in all open workbooks. |
Shift+F9 | Calculate the active worksheet. |
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+Shift+u | Toggle expand or collapse formula bar. |
Put(=) VLOOKUP(lookup_value,table_array,col_index_num,range_lookup) | vlookup |
Ctrl+Alt+F9 | Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation. |
Excel Shortcuts Formulas and Basic function Keys
