THERE ARE 40 SHORTCUT KEYS IN EXCEL
- F2 : EDIT SELECTED
- F4 : REPEAT LAST EDIT
- F11 : NEW CHART
- ALT : ACCESS THE RIBBION FOR FORMULAS
- ALT+ : AUTOMATICALLY SUM ( ) SELECTED
- ALT+ENTER : START A NEW LINE IN THE SAME CELL
- ALT+H,O,I : AUTO SIZE COLUMN
- CTRL+PG+DOWN : GO TO NEXT WORKSHEET
- CTRL+PG+UP : GO TO PREVIOUS WORKSHEET
- CTRL+` : DISPLAYS FORMULAS
- CTRL+BACKSPACE : SHOW ACTIVE CELL
- CTRL +SHIFT+# : CHANGE DATE FORMAT ,YEAR, MONTH
- CTRL+K : TO INSERT HYPERLINK
- CTRL+SHIFT+$ : APPLIES THE CURRENCY FORMAT TO THE SLEETED CELL
- CTRL+SHIFT+& : APPLIES BORDER TO CELL
- CTRL+B : BOLD
- CTRL+U : UNDERLINE
- CTRL+I : ITALICS
- CTRL+SHIFT+~ : GENERAL STYLE UMBER
- CTRL+SHIFT+% : PERCENTAGE STYLE NUMBER
- CTRL+SHIFT^ : SCIENTIFIC NOTATION STYLE
- CTRL+SHIFT+@ : TIME STYLE
- CTRL+SHIFT+! : NUMBER STYLE
- CTRL+F12 : OPEN DOCUMENT
- CTRL+SPACEBAR : SELECT THE ENTIRE COLUMN
- CTRL+[+SHIFT : SELECT ALL CELLS DIRECTLY REFRENCED BY FORMULAS
- CTRL+;+SHIFT : INSERT ACTUAL DATE IN ACTIVE CELL
- CTRL+ +SHIFT : INSERT ACTUAL TIME IN ACTIVE CELL
- CTRL+A : SELECT ALL
- ALT+H+I : FORMAT AS TABE
- CTRL+D : COPY EDUCATION DOWN
- CTRL+F : FIND
- CTRL+H : FIND & REPLACE
- CTRL+RIGHT ARROW : FIND & REPLACE
- CTRL+LEFT ARROW : MOVE RIGHT
- CTRL+UP ARROW : MOVE LEFT
- CTRL +DOWN ARROW : MOVE DOWN
- CTRL+ENTER : SAME DATA IN MULTIPLE CELL
- CTRL+SPACEBAR : SELECT THE ENTIRE
- SHIFT + F3 : FIND PREVIOUS
No comments:
Post a Comment