ADVANCED EXCEL SHORTCUT KEYS
| SHIFT+F2 | TO ADD A COMMENT TO A CELL |
| SHIFT +F10 +D | TO DELETE A COMMENT FROM A CELL |
| CTRL+H | TO FIND AND REPLACE A WORD OR PHRASE |
| CTRL+ SHIFT + ALT +ARROW DOWN KEY | TO ACTIVATE THE FILTER |
| CTRL+; | TO INSERT THE CURRENT DATE |
| CTRL+ SHIFT +: | TO INSERT THE CURRENT DATE |
| CTRL+K | TO INSERT A HYPERLINK |
| CTRL+ SHIFT +$ | TO APPLY THE CURRENCY FORMAT |
| CTRL+SHIFT +% | TO APPLY THE PERCENT FORMAT |
| ALT +Q | T OACCESS THE “TELL ME WHAT YOU WANT TO DO”BOX |
| CTRL+ SHIFT+0 | TO HIDE THE SELECTED COLUMNS |
| ALT +SHIFT +RIGHT ARROW | TO GROUP ROWS OR COLUMNS |
EXCEL CELL FORMATTING SHORTCUT KEYS
| F2 | TO EDIT A CELL |
| CTRL+C,CTRL+V | TO COPY AND PASTE SELECTED CELLS |
| CTRL+ SHIFT + _ | TO REMOVE THE OUTLINE BORDER OF THE CELL |
| ALT +H,A,C | TO CENTER ALIGN CELL CONTENT |
| ALT +H+H | TO FILL COLORS |
| ALT + H+B | TO ADD A BORDER |
| SHIFT + TAB | TO MOVE TO THE PREVIOUS CELL |
| CTRL+SHIFT +& | TO ADD AN OUTLINE TO THE SELECT CELL |
| CTRL+SHIFT + Up ARROW | TO SELECT THE CELLS ABOVE THE SELECTED CELL |
| CTRL+I,CTRL+B | TO ITALICIZE AND BOLD THE FONT |
| CTRL+SHIFT +DOWN ARROW | TO SELECT THE COLUMN FROM THE END OF THE TABLE |
| TAB | TO MOVE TO THE NEXT CELL |
EXCEL INSERT & LAYOUT SHORTCUTS
| ALT NV | INSERT PIVOT TABLE | ALT +M R | RECENTLY USED FUCTIONS |
| ALT NT | INSERT TABLE | ALT M1 | FINANCIAL FUCTIONS |
| ALT NP | INSERT PICTURE | ALT M L | LOGICAL FUCTIONS |
| ALT NSH | INSERT SHAPE | ALT M T | TEXT FUCTIONS |
| ALT NSC | INSERT CHART | ALT M E | DATE & TIME FUCTIONS |
| ALT +N I | INSERT HYPERLINK | ALT M O | LOOKUP FUCTIONS |
| ALT NX | INSERT TEXT BOX | ALT M G | MATH &TRIG FUCTIONS |
| ALT NJ | INSERT OBJECT | ALT M Q | MORE FUCTIONS |
| ALT NU | INSERT SYMBOL | ALT += | AUTOSUM |
| ALT NH | INSERT HEADER /FOOTER | ALT M N | NAME MANAGER |
| ALT W V F | HIDE /UNHIDE FORMULA BAR | ALT D F F | ADD FILTERS |
| ALT W V H | HIDE / UNHIDE HEADING | ALT A V V | INSERT DATA VALIDATION |
| ALT W V G | HIDE /UNHIDE GRIDLINES | ALT A M | REMOVE DUPLICATES |
| ALT W Q C | CHANGE ZOOM | ALT A R A | REFRESH ALL |
| ALT W F F | FREEZE PANE | ALT A E | TEXT TO COLUMN |
| ALT W F 1 | PAGE BREAK VIEW | ALT A G | GROUP ROWS & COLUMNS |
| ALT W F C | CUSTOM VIEW | ALT A B | ADD SUB TOTAL |
| ALT W F P | PAGE LAYOUT VIEW | ALT A S S | SORT |
| ALT W A | ARRANGE WINDOWS | ||
| SHIFT +F3 | INSERT FUCTION |
Leave a Reply