Excel shortcut tricks

MUKESH CHOUDHARY
By -
0
CTRL SHORTCUTSFunction 
CTRL+ASELECT ALL
CTRL+B BOLD
CTRL+C COPY
CTRL+ALT+V PASTE SPECIAL
CTRL+D FILL DOWN
CTRL+F FIND
CTRL+G GO TO 
CTRL+H REPLACE
CTRL+I ITALIC
CTRL+K INSERT HYPERLINK
CTRL+N NEW WORKBOOK
CTRL+O OPEN FILE
CTRL+P PRINT
CTRL+R FILL RIGHT
CTRL+S SAVE WORKBOOK 
CTRL+T CREATE TABLE
CTRL+U UNDERLINE
CTRL+V PASTE
CTRL +W CLOSE WINDOW 
CTRL+X CUT
CTRL+Y REPEAT
CTRL+Z UNDO
CTRL+1 FORMAT BOX
CTRL+5 STRIKE-THROUGH
CTRL+9 HIDE ROW
SHIFT+CTRL+9 UNHIDE ROW
CTRL+0 HIDE COLUMN
SHIFT+CTRL+0 UNHIDE COLUMN
CTRL+~ SHOW FORMULAS/VALUES
CTRL+' COPY ABOVE FORMULA
CTRL +[ PRECEDENTS
CTRL+] DEPENDENTS
CTRL+; DISPLAY DATE
SHIFT+CTRL+: DISPLAY TIME
CTRL+SPACE SELECT COLUMN 
CTRL+ENTER FILL SELECTION 
CTRL +F2 PRINT PREVIEW
CTRL+DOWN ARROW  SHOW LAST COLUMN 
CTRL +UP ARROW  FIRST ARROW 
CTRL+RIGHT ARROW  SHOW LAST ROW
CTRL+LEFT ARROW FIRST ROW

एक टिप्पणी भेजें

0टिप्पणियाँ

एक टिप्पणी भेजें (0)