BASIC EXCEL FORMULAS AND SHORTCUT KEYS
|
BASIC EXCEL FORMULAS |
||
|
1 |
SUM |
=SUM(A1:A5) |
|
2 |
SUM |
=(A1+A2+A3+A4+A5) |
|
3 |
SUM |
=(45+2+43+48) |
|
4 |
PRODUCT |
=PRODUCT(F1:F2) |
|
5 |
PRODUCT |
=(34*65) |
|
6 |
SUBTRACT
/MIN IS |
=(E3-E4) |
|
7 |
DIVIDE |
=(F3/F4) |
|
8 |
PERCENTAGE |
=(G3/G4*100) |
|
9 |
MAXIMUM |
=MAX(H3:M3) |
|
10 |
MINIMUM |
=MIN(H3:M3) |
|
11 |
POWER |
=POWER(2,4)[24=16] |
|
12 |
AVERAGE |
=
AVERAGE(C3:C14) |
|
13 |
SQURE
ROOT |
=SQRT
(25) |
|
14 |
COUNT |
=COUNT
(C4:P4) |
|
15 |
COUNT
BLANK |
=COUNTBLANK(C3:C16) |
|
16 |
COUNT IF |
=COUNTIF(D4:Z4,”P”) |
|
17 |
CURRENT
DATE AND TIME |
=NOW() |
|
18 |
TODAYS
DATE |
=TODAY() |
|
19 |
DAY#OF
CURRENT MONTH |
=DAY(NOW()) |
|
20 |
CURRENT
MONTH |
=MONTH
(NOW()) |
|
21 |
CURRENT
YEAR |
=YEAR(NOW()) |
|
22 |
INSERT
CURRENT MONTH |
=MONTH(NOW()) |
|
23 |
CURRENT
YEAR |
=YEAR (NOW()) |
|
24 |
INSERT
CURRENT TIME |
PRESS
CTRL + SHIFT +; |
|
25 |
INSERT
CUEERNT DATE & TIME |
PRESS : CTRL +;PRESS SPACE PRESS: CTRL +
SHIFT+; |
|
26 |
PASS OR
FAIL |
=IF(H4>=400
,”PASS”,”FAIL ”) |
|
WORLD
SHORTCUT KEYS |
EXCEL
SHORTCUT KEYS |
||
|
CTRL
+A |
SELECT
ALL CONTENTS OF THE PAGE |
F2
|
EDIT
THE SELECTED CELL |
|
CTRL
+ B |
BOLD HIGHLIGHTED SELECTION |
F5 |
GOT TO A SPECIFIC CELL |
|
CTRL
+ X |
CUT SELECT TEXT |
F7 |
SPELL CHECK SELECTE TEXT AND/ OR DOCUMENT |
|
CTRL
+ N |
OPEN
NEW/BLANK DOCUMENT |
F11
|
CREATE
CHART |
|
CTRL
+ O |
OPEN
OPTIONS |
CTRL
+ SHIFT +; |
ENTER
THE CURRENT TIME |
|
CTRL
+ P |
OPEN
THE PRINT WINDOW |
CTRL
+; |
ENTER
THE CURRENT DATE |
|
CTRL
+ F |
OPEN
FIND BOX |
ALT
+ SHIFT +F1 |
INSERT
NEW WORKSHEET |
|
CTRL
+I |
ITALIC
HIGHLIGHTED SELECTION |
SHIFT
+ F3 |
OPEN
THE EXCEL FORMULA WINDOW |
|
CTRL
+ K |
INSERT
LINK |
SHIFT
+ F5 |
BRING UP SEARCH BOX |
|
CTRL
+U |
UNDERLINE HIGHLIGHTED SELECTION |
CTRL
+ A |
SELECT
ALL CONTENTS OF WORKSHEET |
|
CTRL
+ V |
PASTE |
CTRL
+ B |
BOLD
HIGHLIGHTED SELECTION |
|
CTRL
+ Y |
REDO THE LAST ACTION |
CTRL
+ I |
ITALIC HIGHLIGHTED SELECTION |
|
CTRL
+ Z |
UNDO
LAST ACTION |
CTRL
+ C |
COPY
SELECT TEXT |
|
CTRL
+ G |
FIND AND REPLACE OPTIONS |
CTRL
+ V |
PASTE
|
|
CTRL
+ H |
FIND
AND REPLACE OPTION |
CTRL
+ D |
FILL |
|
CTRL
+ J |
JUSTIFY
PARAGRAPH ALIGNMENT |
CTRL
+ K |
INSERT
LINK |
|
CTRL
+L |
ALIGN SELECTED TEXT OR LINE TO THE LEFT |
CTRL
+F |
OPEN
FIND AND REPLACE OPTIONS |
|
CTRL
+ Q |
ALIGN
SELECTED PARAGRAPH TO THE LEFT |
CTRL
+ G |
OPEN
GO TO OPTIONS |
|
CTRL
+ E |
ALIGN
SELECTED TEXT OR LINE TO THE CENTER |
CTRL
+ H |
OPEN
FIND AND REPLACE OPTIONS |
|
CTRL
+ R |
ALIGN
SELECTED TEXT OR LINE TO THE RIGHT |
CTRL
+ U |
UNDERLINE
HIGHLIGHTED SELECTION |
|
CTRL
+ M |
INDENT
THE PARAGRAPH |
CTRL
+ Y |
UNDERLINE
SELECTED TEXT |
|
CTRL
+ T |
HANGING INDENT |
CTRL
+5 |
STRIKETHROUGH
HIGHLIGHTED SELECTION |
|
CTRL
+ D |
FONT OPTIONS |
CTRL
+ O |
OPEN OPTIONS |
|
CTRL
+ SHIFT +F |
CHANGE THE FONT |
CTRL
+ N |
OPEN NEW DOCUMENT |
|
CTRL
+ SHIFT + > |
INCREASE
SELECTED FONT +1 |
CTRL + P |
OPEN PRINT DIALOG BOX |
|
CTRL
+] |
INCREASE
SELECTED FONT +1 |
CTRL
+S |
SAVE |
|
CTRL
+ SHIFT +< |
DECREASE
SELECTED FONT -1 |
CTRL
+ Z |
UNDO
LAST ACTION |
|
CTRL
+ SHIFT +[ |
DECRESE
SELECTED FONT-1 |
CTRL
+ F9 |
MINIMIZE CURRENTLY SELECTED WINDOW |
|
CTRL
+ SHIFT +’ |
VIEW
OR HIDE NON PRINTING CHARACTERS |
CTRL
+ F10 |
MAXIMIZE
CURRENTLY SELECTED WINDOW |
|
CTRL
+ DEL |
DELETE
WORD TO RIGHT OF CURSOR |
CTRL
+ F6 |
SWITCH BETWEEN OPEN WORKBOOKS /WINDOWS |
|
CTRL
+ BACKSPACE |
DELETE
WORD TO LEFT OF CURSOR |
CTRL
+ PAEG P
& PAGE DOWN |
MOVE
BETWEEN EXCEL WORKSHEETS IN THE SAME DOCUMENT |
|
CTRL
+ END |
MOVE
CURSORS TO END OF DOCUMENT |
CTRL
+ TAB |
MOVE BETWEEN TWO OR MORE OPEN EXCEL FILES |
|
CTRL
+ HOME |
MOVE
CURSOR TO VEGINING OF DOCUMENT |
ALT
+ = |
CREATE
FORMULA TO SUM ALL OF ABOVE CELLS |
|
CTRL
+ SPACE |
RESET IGHLIGHTED TEXT TO DEFAULT FONT |
CTRL
+ ‘ |
INSERT
VALUE OF ABOVE CELL INTO CURRENT CELL |
|
CTRL
+ 1 |
SINGLE
–SPACE LINES |
CTRL
+ SHIFT +! |
FORMAT
NUMBER IN COMMA FORMAT |
|
CTRL
+2 |
DOUBLE
–SPACE LINES |
CTRL
+ SHIFT +$ |
FORMAT NUMBER IN CURRENCY FORMAT |
|
CTRK
+ 5 |
1.5
LINE SPACING |
CTRL
+ SHIFT + # |
FORMAT NUMBER IN DATE FORMAT |
|
CTRL
+ ALT + 1 |
CHANGE
TEXT TO HEADING 1 |
CTRL
+ SHIFT + % |
FORMAT NUMBER IN PERCENTAGE FORMAT |
|
CTRL
+ ALT + 2 |
CHANGE
TEXT TO HEADING 2 |
CTRL
+ SHIFT + ^ |
FORMAT
NUMBER IN SCIENTIFIC FORMAT |
|
CTRL
+ ALT+ 3 |
CHANGE
TEXT TO HEADING 3 |
CTRL
+ SHIFT +@ |
FORMAT
NUMBER IN TIME FORMAT |
|
F1 |
OPEN
HELP |
CTRL
+ ARROW I RIGHT KEY |
MOVE TO NEXT SELECTION OF TEXT |
|
SHIFT
+ F3 |
CHANGE
CASE OF SELECTED TEXT |
CTRL
+ SPACE |
SELECT ENTIRE COLUMN |
|
SHIFT
+ INSERT |
PASTE |
SHIFT
+ SPACE |
SELECT
ENTIRE ROW |
|
F4 |
REPEAT
LAST ACTION PERFORMED (WORLD 2000+) |
CTRL
+ W |
CLOSE DOCUMENT |
|
F7 |
SPELL CHECK SELECTED TEXT AND /OR DOCUMENT |
OUTLOOK SHORTCUT KEYS |
|
|
SHIFT
+ F7 |
ACTIVATE
THE THESAURS |
ALT
+S |
SEND
THE EMAIL |
|
F12 |
SAVE
AS |
CTRL
+ C |
COPY SELECTED TEXT |
|
CTRL
+ S |
SAVE
|
CTRL
+X |
CUT SELECTED TEXT |
|
SHIFT
+ F12 |
SAVE |
CTRL
+ P |
OPEN PRINT DIALOG BOX |
|
ALT
+ SHIFT + D |
INSERT
THE CURRENT DATE |
CTRL
+K |
COMPLETE NAME /EMAIL TYPED IN ADDRESS BAR |
|
ALT
+ SHIFT +T |
INSERT THE CURRENT TIME |
CTRL+B
|
BOLD HIGHLIGHTED SELECTION |
|
CTRL
+ W |
CLOSE
DOCUMENT |
CTRL
+ U |
UNDERLINE HIGHLIGHTED SELECTION |
|
|
|
CTRL + R |
REPLY TO AN EMAIL |
|
|
|
CTRL
+ F |
FORWARD AN EMAIL |
|
|
|
CTRL + N |
CREATE A NEW EMAIL |
MICROSOFT
EXCEL FORMULA
Basic math
|
Function |
Formula |
Example |
|
To add up
the total |
=SUM(cell
range ) |
=SUM(B2:B9) |
|
To add
individual items |
= Value +
Value 2 |
=B2+C2 |
|
Subtract |
= Value
–Value 2 |
=B2-B2 |
|
Multiply |
= Value
*Value 2 |
=B2*C2 |
|
Divide |
= Value
/Value 2 |
=B2/C2 |
|
Exponents
|
= Value
^Value 2 |
=B2^C2 |
|
Average |
= AVREAGE (cell range) |
=AVRAGE
(B2:B9 ) |
|
Median |
= MEDIAN
(cell range) |
=MEDIAN(B2:B9
) |
|
Max |
=
MAX(cell range ) |
=MAX(B2:B9) |
|
Min |
=MIN (cell
range ) |
=MIN(B2:B9) |
SIMPLE FORMATTING TRICKS
|
function |
Formula |
Example |
|
To change
a cell to proper case |
=PROPER(cell) |
=PROPER
(A2) |
|
To change
a cell to upper case |
=UPER(cell) |
=UPPER
(A2) |
|
To change
a cell to lower case |
=LOWER (cell) |
=LOWER(A2) |
CONDITIONAL STATEMENT
|
Function |
Formula |
Example |
|
If
statement |
=if
(logical test, “result if the test answer is true”, “result if the test
answer is false “) |
=IF
(B2>69,”pass”,”fail” |
|
Exact |
=EXACT(value1,
value2,) |
=EXACT(B2,C2) |
|
DAILY USE SHORTCUT KEYS |
|||
|
Shortcut |
Action |
Menu equivalent |
Excel Version |
|
CTRL +S |
SAVE |
FILE+ SAVE |
ALL |
|
CTRL + T |
CREATE TABLE |
INSERT TAB + TABLES GROUP+TABLE |
ALL |
|
CTRL + U |
UNDERLINE |
HOME TAB+FONT GROUP +UNDERLINE |
ALL |
|
CTRL + V |
PASTE |
HOME TAB+ CLIPBOARD GROUP +PASTE |
ALL |
|
CTRL + W |
CLOSE |
FILE TAB + CLOSE |
ALL |
|
CTRL + X |
CUT |
HOME TAB+CLIPBOARD GROUP +PASTE |
ALL |
|
CTRL + Y |
REDO |
QUICK ACCESS TOOLBAR+REDO |
ALL |
|
CTRL + Z |
UNDO |
QUICK ACCESS TOOLBAR+ UNDO |
ALL |
|
SHORTCUT
WITH ALT KEYS |
FUNCTION
KEY SHORTCUTS |
||
|
ALT +F1 |
INSERT
CHART |
F1 |
HELP |
|
ALT +F2 |
SAVE AS |
F2 |
EDIT |
|
ALT + F4 |
EXIT |
F3 |
PASTE NAME
|
|
ALT+F8 |
MACRO
DIALOG BOX |
F4 |
REPEAT
LAST ACTION |
|
ALT + F11 |
VISUAL
BASIC EDITOR |
F5 |
GO TO |
|
ALT + TAB |
CYCLE APPLICATIONS |
F6 |
NEXT PANE |
|
ALT += |
AUTOSUM |
F7 |
SPELL
CHECK |
|
ALT+` |
FORMAT
STYLE DIALOG BOX |
F8 |
EXTEND
MODE |
|
INSERT |
TOGGLE
INSERT MODE |
F9 |
RECALATE
ALL WORKBOOKS |
|
DELETE |
DELETE |
F10 |
ACTIVATE
MENU BAR |
|
HOME |
MOVE TO
END OF LINE |
F11 |
NEW CHART |
|
END |
MOVE TO END OF LINE |
F12 |
SAVE AS |
|
PAGEUP |
PAGE UP |
SHIFT +F1 |
WHAT’S
THIS? |
|
PAGE DOWN |
PAGE DOWN |
SHIFT +F2 |
EDIT CELL
COMMENT |
|
LEFT ARROW |
LEFT |
SHIFT +F3 |
PASTE
FUCTION INTO FORMULA |
|
RIGHT
ARROW |
RIGHT |
SHIFT +F4 |
FIND NEXT |
|
UP ARROW |
UP |
SHIFT +F5 |
FIND NEXT |
|
DOWN ARROW
|
DOWN |
SHIFT +F6 |
PREVIOUS
PANE |
|
TAB |
INDENT |
SHIFT +F8 |
ADD TO
SELECTION |
|
ENTER |
NEXT CELL |
SHIFT +F9 |
CALCULATE
ACTIVE WORKSHEET |
|
BACKSPACE |
DELETE
PREW CHAR |
SHIFT +F10 |
DISPLAY
SHORTCUT MENU |
|
SHORTCUT
WITH ALT & CTRL KEYS |
SHIFT +F11 |
NEW
WORKSHEET |
|
|
ALT +A |
GO TO THE
DATA TAB |
SHIFT +F12 |
SAVE AS |
|
ALT + F |
OPEN THE
FILE MENU |
SHIFT +TAB |
TO MOVE TO
THE PREVIOUS CELL |
|
ALT +H |
GO TO THE HOME TAB |
TAB |
TO MOVE
THE NEXT CELL |
|
ALT + M |
GO TO THE FORMULA TAB |
CTRL +` |
TO INSERT
THE CURRENT DATE |
|
ALT + N |
GO TO THE
INSERT TAB |
SHORTCUT
WITH CTRL KEYS |
|
|
ALT + P |
GO TO THE PAGE LAYOUT TAB |
CTRL + F3 |
NAME
MANAGER |
|
ALT + W |
GO TO THE VIEW TAB |
CTRL +
F4 |
CLOSE |
|
ALT +H,A,C |
CENTER
ALIGN CELL CONTENTS |
CTRL + F5 |
RESTORE DOWN |
|
ALT +H,D,C |
DELETE COLUMN |
CTRL + F9 |
MINIMIZE
WINDOW |
|
ALT + H,H |
CHOOSE A
FILE COLOR |
CTRL + F10
|
RESTORE
DOWN/MAXIMIZE WINDOW |
|
CTRL
+END |
GO TO THE END OF A DOCUMENT |
CTRL +11 |
INSERT 4,0
MACRO SHEET |
|
CTRL +
SHIFT +> |
INCREASE
SELECTED ITEM |
CTRL + F12 |
OPEN FILE |
|
SHIFT +
INS |
PASTE THE
SELECTED ITEM |
CTRL +
SPACE |
TO
SELECT THE ENTIRE COLUMN |
|
CTRL +
SHIFT + F |
CHANGE THE FONT |
|
|
|
CTRL + INS
|
COPY THE
SELECTED ITEM |
|
|
|
CTRL + DEL
|
|
|
|
MS WORLD IMPORTANT SHORTCUTS
MUST –USE EXCEL SHORTCUTS
|
Windows |
Mac |
|
|
Apply borders to cells |
Ctrl +shift +& |
Cmd+Shift +& |
|
Auto sum selected cells |
Alt + = |
Opt += |
|
Create a new workbook |
Ctrl +N |
Cmd +N |
|
Create a new worksheet |
Shift + f11 |
Shift + f11 |
|
Create a pivot table |
Ctrl + Shift +P |
Cmd+shift +P |
|
Duplicate data in the cell below |
Ctrl
+D |
Cmd +D |
|
Enter the current Date |
Ctrl +; |
Cmd +; |
|
Enter the same data in all cells |
Ctrl + Enter |
Cmd +Enter |
|
Find data |
Ctrl +F |
Cmd +F |
|
Force calculate all worksheets |
Ctrl +Alt+f9
|
Cmd +Opt +F9 |
|
Insert a note |
Shift + f2 |
Shift +f2 |
|
Insert hyperlink |
Ctrl +K |
Cmd+K |
|
Open a workbook |
Ctrl + O |
Cmd +O |
|
Open a format cells window |
Ctrl +1 |
Cmd +1 |
|
Save a workbook |
Ctrl +S |
Cmd +S |
|
Select all cells above |
Ctrl +Shift +Up arrow |
Cmd +shift + up arrow |
|
Select an entire column |
Ctrl + Space bar |
Cmd +space bar |
|
Select the rest of a column |
Ctrl + shift +Down-arrow |
Cmd +shift +down arrow |
|
EXCEL SHORTCUT KEYS |
|||||
|
ALT
KEY SHORTCUT |
A to
Z CTRL KEY SHORTCUT |
FUCTION
KEY SHORTCUT |
|||
|
ALT +F1 |
Insert chart |
CTRL+A
|
Select all cells |
F1 |
Help |
|
ALT +F2 |
Save as |
CTRL +B |
Bold |
F2 |
Edit Cells |
|
ALT+F4 |
Exit |
CTRL+C |
Copy |
F3 |
Paste Name |
|
ALT+F8 |
Macro dialog box |
CTRL+D |
Fill down |
F4 |
Repeat action |
|
ALT +F11 |
Visual Basic editor |
CTRL+E |
Flash fill |
F5 |
Cells |
|
ALT + TAB |
Switch programs |
CTRL+F |
Find |
F6 |
Go to Special |
|
ALT+` |
Format Style Dialog box |
CTRL+ G |
Go to Special |
F7 |
Next pane |
|
ALT + ENTER |
Add a line in cell |
CTRL+H |
Find and Replace |
F8 |
Spell Check |
|
ALT+E,S,T |
Copy Format |
CTRL+I |
Italics text |
F9 |
Extend Mode |
|
ALT+H,O,R |
Change Tab Name |
CTRL+J |
NIA |
F10 |
Recalculate Workbooks |
|
ALT +H,O,1 |
AutoFit Column width |
CTRL+K |
Insert Hyperlink |
F11 |
Activate Menu bar |
|
CTRL KEY SHORTCUT |
CTRL+L |
Create Table |
F12 |
New Chart |
|
|
CTRL+0 |
Hide Columns |
CTRL+M |
N/A |
Shift +F1 |
Save As |
|
CTRL +1 |
Format Cells Dialog Box |
CTRL+N |
New Workbook |
Shift +F2 |
What’s this |
|
CTRL +2 |
Bold text |
CTRL+O |
Open File |
Shift+F3 |
Insert Comment |
|
CTRL +3 |
Italics text |
CTRL+P |
Print |
Shift
+F4 |
Paste
Function into |
|
CTRL+4 |
Underline text |
CTRL +Q |
Data Analysis tool |
Shift +F5 |
Formula |
|
CTRL+5 |
Strikethrough |
CTRL+R |
Fill Right |
Shift +F6 |
Find next |
|
CTRL+6 |
Show /Hide Objects |
CTRL+S |
Save workbook |
Shift +F8 |
Find |
|
CTRL+7 |
Show/Hide Toolbar |
CTRL+T |
Create table |
Shift +F9 |
Previous Pane |
|
CTRL +8 |
Toggle Outline Symbols |
CTRL+U |
Underline text |
Shift +F10 |
Add to Selection |
|
CTRL +9 |
Hide Rows |
CTRL+V |
Paste |
Shift +F11 |
New Worksheet |
|
CTRL + - |
Delete Row/Column |
CTRL+W |
Close Workbook |
Shift +F12 |
Save |
|
CTRL ++ |
Insert Row/Column |
CTRL+X |
Cut |
Ctrl+F3 |
Name Manager |
|
CTRL |
Insert Current Date |
CTRL+Y |
Redo |
Ctrl + F4 |
Close |
|
CTRL+* |
Show Formulas |
CTRL+Z |
Undo |
Ctrl+F9 |
Minimize window |
|
CTRL+ HOME |
Go to
cell A1 |
CTRL+Arrows |
Go to end of range |
Ctrl+F10 |
Restore |
|
ADVANCED EXCEL SHORTCUTS |
|
|
ALT +O+C+A |
Adjust Column width |
|
ALT+E+A+A |
Clear all |
|
CTRL+ALT+V |
Open paste special |
|
CTRL+1 |
Open format dialogue box |
|
CTRL+0 |
Hide
column |
|
CTRL+9 |
Hide row |
|
CTRL+5 |
Strike through |
|
ALT+H+O+R |
Rename sheet name |
|
F7 |
Spell check |
|
ALT +V+U |
Full screen |
|
ALT+T+A |
Auto correct options |
|
CTRL+F1 |
Hide ribbon |
|
SHIFT +CTRL+; |
Current time |
|
Shift +; |
Today date |
|
Shift +F11 |
Insert new sheet |
|
CTRL+SHIFT +` |
Format to general |
|
EXCEL CHART SHEET |
|||||
|
WORKBOOK |
FORMAT |
ACTIONS |
|||
|
CTRL+N |
NEW |
CTRL+B |
BOLD |
CTRL+Z |
UNDO |
|
CTRL+O |
OPEN |
CTRL+I |
ITALIC |
CTRL+Y |
REDO |
|
CTRL+W |
CLOSE |
CTRL+5 |
STRICKTHROUGH |
CTRL+F |
FIND |
|
CTRL+ S |
SAVE |
DELETE |
DELETE CONTENT |
CTRL+ M |
FIND AND REPLACE |
|
F12 |
SAVE AS |
CELL NUMBER FORMAT |
F7 |
SPELL CHECK |
|
|
CTRL+P |
PRINT |
CTRL+ SHIFT + ~ |
GENERAL |
F2 |
EDIT FROM CONTANT |
|
ALT+SHIFT+F1 |
INSERT SHEET |
CTRL+SHIFT +@ |
TIME |
CTRL+ - |
TOGGLE FORMULAS |
|
F11+ALT+F1 |
INSERT CHART |
CTRL+SHIFT + # |
DATE |
F4 |
TOGGLE CELL REF |
|
ALT +E+L |
DELETE SHEET |
CTRL+SHIFT +$ |
CURRENCY |
SHIFT +F10 |
CONTEXT MENU
|
|
CTRL +X |
CUT |
CTRL+SHIFT +! |
NUMBER |
CTRL+Q |
QUICK ANALYSIS |
|
CLIPBOARD |
CTRL+SHIFT+% |
PERCENTAGE |
SELECTED |
||
|
CTRL+C |
COPY |
CTRL+SHIFT +^ |
SCIENTIFIC |
CTRL+SHIFT + |
INSERTROW/COL |
|
CTRL+V |
PASTE |
BORDERS |
CTRL+ - |
DELETE ROW/COL |
|
|
CTRL+ALT +V |
PASTE SPECIAL |
ALT+H,B |
ADD |
CTRL+ 9 |
HIDE ROWS |
|
NAVIGATION |
CTRL+SHIFT +7 |
ADD OUTSIDE |
CTRL+0 |
HIDE COLUMNS |
|
|
CTRL+PAGE +UP |
SHEET LEFT |
CTRL+SHIFT+_ |
REMOVE |
ALT +H,O,I |
AUTO FIT |
|
CTRL+ PAGE DOWN |
SHEET
RIGHT |
SELECTED CELLS |
DATA |
||
|
PAGE UP |
SCREEN UP |
ALT +H,H |
FILL COLOR |
CTRL+; |
CURRENT DATE |
|
PAGE DOWN |
SCREEN DOWN |
TEXT ALIGN |
CTRL+SHIFT +: |
CURRENT TIME |
|
|
CTRL+ ARROW KEY |
END OF DATA |
ALT +H,A,L |
LEFT |
CTRL+= |
SUM SELECTED |
|
|
ALT+H,A,R |
RIGHT |
SELECT |
||
|
ALT +H |
HOME |
ALT +H,A,C |
CENTER |
CTRL+A |
ALL |
|
ALT +N |
INSERT |
OPEN DIALOG |
SHIFT +SPACE |
ROW |
|
|
ALT +P |
PAGE LAYOUT |
CTRL+1 |
FORMAT |
CTRL+ SPACE |
COLUMN |
|
ALT +A |
DATA |
CTRL+
- |
DELETE |
SHIFT +ARROW KEY |
EXTEND ONE CELL |
|
ALT +V |
VIEW |
CTRL+SHIFT+ + |
INSERT |
CTRL+ SHIFT +END |
USED CELL |
|
ALT+M |
FORMULA |
|
|
|
|
|
ADVANCED 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 |
|
CELL FORMATTING
SHORT CUT KEY |
|
|
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 |
|
|
|
BASIC SHORT CUT KEY |
WORD SHORT CUT |
EXCEL SHORTCUT KEYS |
|||
|
ALT +F |
FILE MENU OPTION IN CURRENT PROGRAM |
CTRL+A |
SELECT ALL |
F2 |
EDIT THE SELECT CELL |
|
ALT +E |
EDIT
OPTIONS IN CURRENT PROGRAM |
CTRL +B |
BOLD |
F5 |
GO TO A SPECFIC CELL |
|
F1 |
UNIVERSAL HELP |
CTRL+ C |
COPY SELECT |
F7 |
SPELL
CHECK SELECT TEXT |
|
CTRL+A |
SELECT ALL TEXT |
CTRL+X |
CUT SELECTION |
F11 |
CREATE CHART |
|
CTRL+X |
CUT SELECTED ITEM |
CTRL+N |
OPEN NEW WORKBOOK |
CTRL+SHIFT+; |
ENTER THE CURRENT TIME |
|
SHIFT +DEL |
CUT SELECTED ITEM |
CTRL+O |
OPEN OPTION |
CTRL+; |
ENTER THE CURRENT DATE |
|
CTRL + C |
COPY SELECTED ITEM |
CRL+ P |
PRINT
|
AR +SHIFT + F1 |
INSERT NEW WORKSHEET |
|
CTRL+INS |
COPY SELECTED ITEM |
CTRL +F |
OPEN FIND BOX |
SHIFT +F3 |
OPEN THE EXCEL FORMULA WINDOW |
|
CTRL+V |
PASTE |
CTRL+I |
ITALICIZE HIGHLIGHT SELECTION |
SHIFT + F5 |
BRING UP SEARCH BOX |
|
SHIFT + INS |
PASTE |
CTRL+K |
INSERT LINK |
CTRL+A |
SELECT ALL CONTENTS |
|
HOME |
GO TO BEGINNING OF CURRENT LINE |
CTRL + U |
UNDERLINE |
CTRL +B |
BOLD
HIGHLIGHT |
|
CTRL+HOME |
GO TO BEGINNING OF DOCUMENT |
CTRL+V |
PASTE |
CTRL+C |
COPY |
|
END |
GO TO END OF CURRENT LINE |
CTRL +Y |
REDO
ACTION |
CTRL+I |
ITALICIZE |
|
CTRL+END |
GO TO END OF DOCUMENT |
CTRL+ Z |
UNDO LAST ACTION |
CTRL+V |
PASTE |
|
SHIFT +HOME |
HIGHLIGHT FROM CURRENT POSITIONTO BEGNING OF
LINE |
CTRL+G |
FIND AND REPLACE |
CTRL+ D |
FILL |
|
CTRL+ LEFT
ARROW |
MOVE ONE WORD TO THE LEFT AT A TIME |
CTRL+H |
FIND AND REPLACE |
CTRL+K |
INSERT LINK |
|
CTRL + RIGHT ARROW |
MOVE ONE WORD TO THE RIGHTAT A TIME |
CTRL+J |
JUSTIFY |
CTRL+F |
OPEN FIND AND REPLACE OPTIONS |
|
MICRO SOFT WINDOWS SHORTCUTS KEYS |
CTRL +L |
ALIGN SELECTED TEXT OR LINE TO THE LEFT |
CTRL+G |
OPEN
GO TO OPTIONS |
|
|
ALT +TAB |
SWITCH BETWEEN OPEN APPLICATIONS |
CTRL+O |
ALIGN SELECTED PARAGRAPH TO THE LEFT |
CTRL+ H |
OPEN FIND AND REPLACE OPTIONS |
|
ALT +SHIFT + TAB |
SWITCH BACKWARDS BETWEEN OPEN APPLICATION |
CTRL + E |
ALIGN
SELECTED TEXT OR LINE TO THE CENTER |
CTRL+ U |
UNDERLINE SELECTED TEXT |
|
ALT + PRINT SCREEN |
CREATE SCREENSHOT FOR CURRENT PROGRAM |
CTRL+R |
ALIGN
SELECTED TEXT OR LINE TO THE LEFT |
CTRL+Y |
UNDERLINE SELECT TEXT |
|
CTRL+ALT +DEL |
REBOOT WINDOWS TASK MANAGER |
CTRL+M |
INDENT THE PARAGRAPH |
CTRL+5 |
STRICKTHROUGH |
|
CTRL+ESC |
SWITCH BETWEEN APPLICATION ON TASKBAR |
CTRL +T |
HANGING INDENT |
CTRL+O |
OPEN OPTIONS |
|
F2 |
RENAME SELECTED ICON |
CTRL+D |
FONT OPTIONS |
CTRL+N |
OPEN NEW DOCUMENT |
|
F3 |
START
FIND FROM DESKTOP |
CTRL +SHIFT +F |
CHANGE THE FONT |
CTRL+P |
OPEN PRINT DIALOG BOX |
|
F4 |
OPEN THE DRIVE SELECTION WHEN BROWSING |
CTRL+SHIFT +> |
INCREASE FONT +1 |
CTRL+S |
SAVE |
|
F5 |
REFRESH CONTENTS |
CTRL+SHIFT +< |
DECREASE FONT +1 |
CTRL+Z |
UNDO LAST ACTION |
|
ALT + F4 |
CLOSE CURRENT OPEN PROGRAM |
CTRL+] |
INCREASE SELECTED FONT +1 |
CTRL+ F9 |
MINIMIZE CURRENT WINDOW |
|
CTRL + F4 |
CLOSE WINDOW IN PROGRAM |
CTRL+[ |
DECREASE FONT +1 |
CTRL+F10 |
MAXIMIZE CURRENTLY SELECTED WINDOW |
|
CTRL + |
AUTOMATICALLY ADJUST WIDTHS OF ALL COLUMN IN
WINDOW EXPLORER |
CTRL+SHIFT +` |
VIEW OR HIDE NON PRINTING CHARACTERS |
CTRL+F10 |
MAXIMIZE CURRENTLY SELECTED WINDOW |
|
ALT +ENTER |
OPEN PROPERTIES WINDOW WINDOW OF SELECTION
ICON OR PROGRAM |
CTRL + LEFT ARROW |
MOVE
ONE WORD TO THE LEFT |
CTRL+F6 |
SWITCH BETWEEN OPEN WORKBOOK |
|
SHIFT +F10 |
SIMULATE RIGHT CLICK ON SELECTED ITEM |
CTRL+ RIGHT ARROW |
MOVE ONE WORD OF THE RIGHT |
CTRL+PAGE UP &PAGE DOWN |
MOVE BETWEEN EXCEL WORKSHEET IN THE SAME
DOCUMENT |
|
SHIFT + DEL |
DELETE PROGRAMS FILES PERMANENTLY |
CTRL + UP ARROW |
MOVE TO BEGINNING OF THE LINE OR PARAGRAPH |
CTRL+TAB |
MOVE BETWEEN TWO OR MORE OPEN EXCEL FILES |
|
WINKEY SHORTCUTS |
CTRL+ DOWN ARROW |
MOVE TO THE END OF THE PARAGRAPH |
ALT + = |
CREATE FORMULA TO SUM ALL OF ABOVE CELL |
|
|
WINKEY +D |
BRING DESKTOP TO THE TOP OF OTHER WINDOWS |
CTRL+DEL |
DELETE WORLD TO RIGHT OF CURSOR |
CTRL+` |
INSERT VALUE OF ABOVE CELL INTO CURRENT CELL
|
|
WINKEY +M |
MINIMIZE ALL WINDOWS |
CTRL+ BACKSPACE |
DELETE
WORD TO LEFT OF CURSOR |
CTRL+SHIFT +! |
FORMAT NUMBER IS COMMA FORMAT |
|
WINKEY +SHIFT +M |
UNDO THE MINIMIZE DONE BY WINKEY+M AND
WINKEY +D |
CTRL + END |
MOVE CURSOR TO END OF DOCUMENT |
CTRL+SHIFT +$ |
FORMAT NUMBER IN CURRENCY FORMAT |
|
WINKEY +E |
OPEN MICROSOFT EXPLORER |
CTRL+HOME |
MOVE CURSOR TO BEGINNING OF DOCUMENT |
CTRL+SHIFT +# |
FORMAT NUMBER IN DATE FORMAT |
|
WINKEY +TAB |
CYCLE THROUGH OPE N PROGRAMS ON TASKBAR |
CTRL +SPACE |
RESET HIGHLIGHTED TEXT TO DEFAULT FONT |
CTRL+SHIFT +% |
FORMAT NUMBER IN PERCENTAEGE FORMAT |
|
WINKEY +F |
DISPLAY THE WINDOW SEARCH/FIND FEATURE |
CTRL + 1 |
SINGLE SPACE LINE |
CTRL+SHIFT +^ |
FORMAT NUMBER IN SCIENTIFIC FORMAT |
|
WINKEY +CTRL+F |
DISPLAY THE SEARCH FOR COMPUTERS WINDOW |
CTRL+2 |
DOUBLE SPACE LINES |
CTRL+SHIFT +@ |
FORMAT NUMBER IN TIME FORMAT |
|
WINKKEY +F1 |
DISPLAY THE MICROSOFT WINDOW HELP |
CTRL+5 |
1.5LINE SPACING |
CTRL +LEFT ARROW |
MOVE THE NEXT SECTION OF TEXT |
|
WINKEY +R |
OPEN
THE RUN WINDOW |
CTRL+ALT +1 |
CHANGE TEXT TO HEADING 1 |
CTRL+ SPACE |
SELECT ENTIRE COLUMN |
|
WINDOW + PAUSE/BREAK |
OPEN THE SYSTEM PROPERTIES WINDOW |
CTRL+ ALT +2 |
CHANGE TEXT TO HEADING 2 |
SHIFT +SPACE |
SELECT ENTIRE ROW |
|
WINKEY + U |
OPEN
UTILITY MANAGER |
CTRL+ALT +3 |
CHANGE TEXT TO HEADING 3 |
CTRL+W |
CLOSE DOCUMENT |
|
WINKEY +L |
LOCK
THE COMPUTER |
F1 |
OPEN HELP |
OUTLOOK SHORTCUT KEYS |
|
|
|
|
SHIFT +F3 |
CHANGE CASE OF SELECTED TEXT |
ALT +S |
SEND THE EMAIL |
|
|
|
SHIFT + INSERT |
PASTE
|
CTRL+C |
COPY SELECTED TEXT |
|
|
|
|
|
CTRL +X |
CUT SELECT TEXT |
|
TOP EXCEL SHORTCUT |
|||
|
CTRL +N |
OPEN NEW WORKBOOK |
CTRL+H |
FIND AND REPLACE |
|
CTRL+Z |
UNDO ACTION |
CTRL+SHIFT +F2 |
INSERT NEW |
|
CTRL+Y |
REDO ACTION |
CTRL+ALT + |
ZOOM IN |
|
F1 |
OPEN HELP WINDOW |
CTRL+ALT - |
ZOOM OUT |
|
CTRL+ F |
FIND |
ALT +DOWN ARROW |
DISPLAY AUTOCOMPLETE LIST |
|
CTRL+ENTER |
FILL CONTENTS IN SELECTED CELLS |
CTRL; |
ENTER CURRENT DATE |
|
CTRL+ D |
FILL CONTENTS ACROSS SELECTION |
CTRL +SHIFT ; |
ENTER CURRENT TIME |
|
CTRL+R |
FILL CONTENTS ACROSS SELECTION |
CTRL+SHIFT ARROW |
EXTEND SELECTION TO FURTHEST CELL |
|
CTRL+ARROW |
MOVE
TO FURTHEST CELL |
CTRL+G |
OPEN GO TO BOX |
|
CTRL+PGE DN |
MOVE TO NEXT WORKSHEET |
CTRL+X |
CUT SELECTION |
|
CTRL+PGE UP |
MOVE TO PREVIOUS WORKSHEET |
CTRL+V |
PASTE |
|
SHIFT SPACE |
SELECT ROW |
CTRL+ALT +V |
OPEN PASTE SPECIAL BOX |
|
CTRL + SPACE |
SELECT COLUMN |
CTRL- |
OPEN DELETE CELLS BOX |
|
CTRL+A |
SELECT ALL |
SHIFT +F11 |
INSERT NEW WORKSHEET |
|
SHIFT ARROW |
EXTEND SELECTION ONE CELL |
ALT +W +VG |
REMOVE GRIDLINES |
|
CTRL+9 |
HIDE SELECTED ROWS |
ALT + SHIFT RIGHT ARROW |
OPEN GROUP BOX |
|
CTRL+0 |
HIDE SELECT ROWS |
ALT +SHIFT +LEFT ARROW |
UNGROUP ALL |
|
UN |
AUTO FIT COLUMN |
CTRL+K |
INSERT HYPERLINK |
|
ALT +H,O,A |
AUTOFIT ROWS |
CTRL+SHIFT +$ |
CURRENCY FORMAT |
|
CTRL +SHIFT + |
OPEN INSERT CELLS BOX |
CTRL+SHIFT +% |
PERCENTAGE FORMAT |
|
CTRL+1 |
OPEN FORMAT CELLS BOX |
CTRL+SHIFT +# |
DATE FORMAT |
|
CTRL+SHIFT +& |
OUTSIDE BORDERS |
CTRL+SHIFT +@ |
TIME FORMAT |
|
CTRL+SHIFT + - |
REMOVE BORDERS |
CTRL+SHIFT +! |
NUMBER FORMAT |
|
CTRL+B |
BOLD
TEXT |
F4 |
TOGGLE ABSOULT REFRENCES |
|
CTRL+U |
UNDERLINE |
CTRL+[ |
FIND DIRECT CELL REFRENCES |
|
CTRL+I |
ITALICIZE TEXT |
F9 |
RECALCULATE WORKBOOK |
|
CTRL+5 |
STRICKTHROUGH |
CTRL+~ |
TOGGLE DISPLAYING FORMULAS / FORMULA RESULTS
|
|
ALT +F1 |
INSERT CHART |
|
|
|
CTRL+T |
INSERT TABLE |
|
|
|
ALT +F1 |
INSERT CHART |
|
|
|
ALT = |
AUTOSUM DATA |
|
|
|
|
|
|
|
|
CTRL+E |
FLASH FILL |
|
|
|
CTRL+SHIFT L |
TOGGLE FILTERS |
|
|
|
POWER POINT
KEYBOARD SHORTCUT |
||||
|
TO |
PRESS |
TO |
PRESS |
|
|
SAVE A PRESENTATION |
CTRL+S |
DRAW A PERFECT SHAPE |
HOLD SHIFT WHILE |
|
|
PRINT A PRESENTATION |
CTRL+P |
SHOW/HIDE RULER |
SHIFT +ALT +F9 |
|
|
OPEN A PRENSENTATION |
CTRL+O |
SHOW /HIDE GRIDLINES |
SHIFT +F9 |
|
|
CREATE A NEW PRESENTATION |
CTRL +N |
SHOW / HIDE GUIDES |
ALT + F9 |
|
|
NEW SLIDE |
CTRL +M |
SELECT ONE CHARACTER TO THE RIGHT |
SHIFT +→ |
|
|
DUPLICATE |
CTRL + D |
SELECT ONE CHARACTER TO THE LEFT |
SHIFT +← |
|
|
CUT |
CTRL+X |
SELECT TO THE END OF A WORD |
CTRL+SHIFT +→ |
|
|
COPY |
CTRL+C |
SELECT TO THE BEGINNING OF A WORD |
CTRL+SHIFT +← |
|
|
PASTE |
CTRL+V |
SELECT ONE LINE UP |
SHIFT +↑ |
|
|
UNDO (LAST ACTION ) |
CTRL+Z |
SELECT ONE LINE DOWN |
SHIFT +↓ |
|
|
REDO (LAST ACTION REPEAT |
CTRL+Y OR F4 |
SELECT MULTIPLAE OBJECTS |
HOLD SHIFT AND CLICK |
|
|
SELECT ALL |
CTRL+A |
SELECT AN OBJECT |
HOLD
SHIFT +TAB UNTIL THE OBJECT YOU WANT IS SELECTED |
|
|
CLOSE ACTIVE PRESENTATION |
CTRL +W OR CTRL+F4 |
SELECT ALL OBJECTS (SLIDE VIEW) |
CTRL+A |
|
|
CLOSE
POWEWRPOINT |
CTRL+Q OR ALT +F4 |
SELECT ALL SLIDES (SLIDE SORTER VIEW ) |
CTRL+A |
|
|
MOVING IN A PRESENTATION |
SELECT ALL TEXT (OUTLINE VIEW ) |
CTRL+A |
||
|
TO MOVE |
PRESS |
DELETING AND COPYING TEXT AND
OBJECT |
||
|
FIRST SLIDE |
CTRL+HOME |
COPY A SHAPE |
CTRL+D OR HOLD CTRL WHILE DRAGGING THE SHAPE
|
|
|
LAST SLIDE |
CTRL +END |
COPY A SHAPE AND ALIGN WITH ORIGNAL |
HOLD CTRL+SHIFT WHILE DRAGGING |
|
|
NEXT SLIDE (DEPENDING ON ZOOM ) |
PAGE DOWN |
DELETE ONE CHARACTER TO THE LEFT |
BACKSPACE |
|
|
PREVIOUS SLIDE (DEPENDING ON ZOOM |
PAGE UP |
DELETE ONE WORD TO THE LEFT |
CTRL+BACKSPACE |
|
|
MOVE FROM PANE |
F6 |
DELETE ONE CHARACTER TO THE RIGHT |
DELETE |
|
|
MOVING AROUND IN TEXT |
DELETE ONE WORD TO THE RIGHT |
CTRL+DELETE |
||
|
TO MOVE |
PRESS |
CUT SELECTED OBJECT |
CTRL+X |
|
|
ONE CHARACTER TO THE LEFT |
← |
COPY SELECTED OBJECT |
CTRL+C |
|
|
ONE CHARACTER TO THE LEFT |
→ |
PASTE CUT OR COPIED OBJECT |
CTRL+V |
|
|
ONE LINE UP |
↑ |
UNDO THE LAST ACTION |
CTRL+Z |
|
|
ONE LINE DOWN |
↓ |
WORKING IN AN OUTLINE |
||
|
ONE WORD TO THE LEFT |
CTRL +← |
TO |
PRESS |
|
|
ONE WORD TO THE RIGHT |
CTRL+→ |
SWITCH BETWEEN OUTLINE AND SLIDES PANE IN
NORMAL VIEW |
CTRL+SHIFT +TAB |
|
|
TO THE END OF LINE |
END |
PROMOTE A PARAGRAPH |
SHIFT +TAB |
|
|
TO THE BEGINNING OF LINE |
HOME |
DEMOTE A PARAGRAPH |
TAB |
|
|
UP ONE PARAGRAPH |
CTRL+↑ |
MOVE SELECTED PARAGRAPHS UP |
ALT +SHIFT +↑* |
|
|
DOWN ONE PARAGRAPH |
CTRL+↓ |
MOVE SELECTED PARAGRAPH DOWN |
ALT +SHIFT +↓* |
|
|
TO THE END OF A TEXT BOX |
CTRL +END |
SHOW HEADING LEVEL 1 |
ALT +SHIFT +1* |
|
|
TO THE BEGINNING OF A TEXT BOX |
CTRL+
HOME |
EXPAND TEXT BELOW A HEADING |
ALT +SHIFT +PLUS * |
|
|
TO THE NEXT TITLE OR BODY TEXT
PLACEHOLDER |
CTRL+ENTER |
COLLAPSE TEXT BELOW A HEADING |
ALT +SHIFT +MINUS* |
|
|
FIND |
CTRL+F OR F4 |
SHOW ALL TEXT OR HEADINGS |
ALT +SHIFT +A * |
|
|
TO REPEAT THE LAST FIND ACTION |
SHIFT +F4 |
|
|
|
|
FORMATTING IN A PRESENTION |
|
|
||
|
TO FORMAT |
PRESS |
|
|
|
|
ALIGN LEFT |
CTRL+L |
|
|
|
|
ALIGN RIGHT |
CTRL+R |
|
|
|
|
CENTER |
CTRL+E |
|
|
|
|
BOLD TEXT |
CTRL+B |
|
|
|
|
INSERT HYPERLINK |
CTRL+K |
|
|
|
|
PHOTOSHOP
SHORTCUT |
||||
|
1 |
CTRL +Z |
UNDO/REDO |
CTRL +A |
SELECT ALL |
|
2 |
CTRL+S |
SAVE |
CTRL+B |
TOGGLE BRUSH SETTING |
|
3 |
CTRL+T |
FREE TRANSFORM |
CTRL+C |
COPY |
|
4 |
CTRL+J |
DULICATE LAYER |
CTRL+D |
DESELECT |
|
5 |
CTRL +A |
SELECT ALL |
CTRL+E |
MERGE LAYERS |
|
6 |
CTRL+C |
COPY |
CTRL+F |
REPEAT LAST FILTER |
|
7 |
CTRL+V |
PASTE |
CTRL+G |
GROUP LAYERS |
|
PHOTOSHOP SHORTCUT |
||||
|
|
S |
CLONE STAMP TOOL |
CTRL +o |
OPEN FILE |
|
1 |
T |
TYPE TOOL |
CTRL+P |
PRINT |
|
2 |
U |
SHAPE TOOL |
CTRL+Q |
QUIT |
|
3 |
V |
MOVE TOOL |
CTRL+R |
SHOW /HIDE RULERS |
|
4 |
W |
MAGIC WAND TOOL |
CTRL+S |
SAVE |
|
5 |
X |
SWITCH FOREGROUND |
CTRL+U |
HUE/SATURATION |
|
6 |
Y |
ZOOM TOOL |
|
|
|
PHOTOSHOP SHORTCUT |
||||
|
1 |
J |
SPOT HEALING BRUSH TOOL |
A |
PATH SELECTION TOOL |
|
2 |
K |
SLICE TOOL |
B |
CRUSH TOOL |
|
3 |
M |
RECTANGULAR MARQUEE TOOL |
C |
CROP TOOL |
|
4 |
N |
NEW FILE LAYER |
D |
DEFAULT COLORS |
|
5 |
O |
OPEN FILE |
E |
ERASER TOOL |
|
6 |
P |
PEN TOOL |
F |
FULL SCREEN MODE |
|
7 |
Q |
QUICK MASK MODE |
G |
GRADIENT TOOL |
|
8 |
R |
RULER TOOL |
H |
HAND TOOL |
|
FORMAT ROW& COLUMN SHORTCUT KEYS |
|
|
SHIFT +SPACE |
TO SELECT THE WHOLE ROW |
|
CTRL+9 |
TO HIDE THE SELECTED ROW |
|
CTRL+SHIFT +9 |
TO UNHIDE THE SELECTED ROW |
|
SHIFT +SPACE ,CTRL+ - |
TO DELETE A ROW |
|
CTRL+SPACE |
TO SELECT THE WHOLE COLUMN |
|
ALT +H+D+C |
TO DELETE A COLUMN |
|
CTRL+O |
TO HIDE THE SELECTED COLUMN |
|
CTRL+SHIFT +O |
TO HIDE THE SELECTED COLUMN |
|
ALT +SHIFT +→ |
TO GROUP ROWS OR COLUMNS |
|
EXCEL KEYBOARD SHORTCUTS |
|||
|
CTRL+” |
COPY VALUE FROM CELL ABOVE |
CTRL+SHIFT +F |
FONT DROP DOWN LIST |
|
CTRL+’ |
COPY FORMULA FROM CELL ABOVE |
SHIFT+INSERT |
PASTES WHAT IS STORES ON THE
CLIPBOARD |
|
CTRL+SPACEBAR |
SELECTS THE ENTIRE COLUMN |
SHIFT +HOME |
HIGHLIGHTS ALL CELLS RIGHT TO THE
CURSOR |
|
SHIFT+SPACE BAR |
SELECT THE ENTIRE ROW |
SHIFT +END |
HIGHLIGHTS ALL RIGHT TO THE CURSOR |
|
CTRL++ |
ENTERS A NEW COLUMN/ROW |
SHIFT +UP ARROW |
EXTENDS THE HIGHLIGHTED AREA UP ONE
CELL |
|
CTRL+ - |
DELETE A NEW COLUMN /ROW |
SHIFT+ DOWN ARROW |
EXTENDS THE HIGHLIGHTED AREA DOWN
ONE CELL |
|
CTRL+SHIFT +~ |
GENERAL FORMAT |
SHIFT +LEFT ARROW |
EXTENDS HIGHLIGHTED AREA LEFT ONE
CELL |
|
CTRL+SHIFT +@ |
APPLIES TIME FORMATTING |
SHIFT +RIGHT ARROW |
EXTENDS THE HIGHLIGHTED AREA RIGHT
ONE CELL |
|
CTRL+SHIFT +! |
APPLIES COMMA FORMATTING |
SHIFT +F2 |
INSERTS COMMENT IN A CELL |
|
CTRL+SHIFT +$ |
APPLIES CURRENCY FORMATTING |
SHIFT +F3 |
PASTE FUCTION INTO FORMULA |
|
CTRL+SHIFT +^ |
APPLIES BORDERS AROUND SELECTED
CELLS |
SHIFT +F4 |
FIND NEXT |
|
CTRL+SHIFT +& |
APPLIES BORDERS AROUND SELECTED
CELLS |
SHIFT +F5 |
FIND |
|
CTRL+SHIFT +- |
REMOVES A BORDERS |
SHIFT +F8 |
ADD TO SELECTION |
|
CTRL+SHIFT +9 |
UNHIDE ROWS |
SHIFT +F10 |
DISPLAY SHORTCUT MENU |
|
CTRL+SHIFT +0 |
UNHIDE COLUMNS |
SHIFT +F11 |
NEW WOKSHEET |
|
CTRL+SHIFT +F3 |
OPEN CREATE FROM SELECTION BOX |
SHIFT +F12 |
SAVE WORKSHEET |
|
CTRL+HOME |
MOVE TO LAST CELL ON WORKSHEET |
ALT +TAB |
CYCLES THROUGH OPEN APPLICATIONS |
|
CTRL+SHIFT +O |
SELECT ALL CELLS THAT CONTAIN
COMMENTS |
ALT +SPACE BAR |
OPENS THE
SYSTEM MENU |
|
|
|
ALT +ENTER |
WHILE TYPING IN A CELL MOVE TO THE
NEXT LINE |
|
BASIC SHORTCUTS |
|||
|
New Document |
CTRL+N |
CREATE TABLE |
ALT +N,THEN T |
|
Open Document |
CTRL+O |
INSERT PAGE NUMBER |
ALT +SHIFT +P |
|
Save document |
CTRL+S |
INSERT DATE |
ALT +SHIFT +D |
|
Print Document |
CTRL+P |
OPEN THESAURUS |
SHIFT +F7 |
|
Undo
|
CTRL+Z |
UPDATE FIELDS |
CTRL+A,THEN F9 |
|
Redo |
CTRL+Y |
CREATE TABLE OF CONTENTS |
ALT+S ,THEN T |
|
Copy |
CTRL+C |
MISCELLANEOUS
SHORTCUTS |
|
|
Cut |
CTRL+X |
SHOW/HIDE FORMATTING MARKS |
CTRL+SHIFT +8 |
|
Paste |
CTRL+V |
ZOOM IN/OUT |
ALT +V THEN Z |
|
Select All |
CTRL+A |
SWITCH BETWEEN OPENDOCUMENTS |
CTRL+F6 |
|
Find |
CTRL+F |
OPEN THE BACKSTAGE VIEW |
ALT +F |
|
Replace |
CTRL+H |
ADVANCED SHORTCUTS |
|
|
Bold |
CTRL+B |
Insert Hyperlink |
CTRL+K |
|
Italic |
CTRL+I |
Insert Footnote |
Alt +CTRL+F |
|
Underline |
CTRL+U |
Open Navigation Pane |
CTRL+F |
|
Strikethrough |
CTRL+D |
Toggle Hidden Text |
CTRL+SHIFT +* |
|
Increase Font Size |
CTRL+SHIFT +> |
|
|
|
Decrease Font Size |
CTRL+SHIFT +< |
|
|
|
Change Case |
SHIFT +F3 |
|
|
|
PARAGRAPH
FORMATTING |
|||
|
Align Left |
CTRL+L |
|
|
|
Align Center |
CTRL+E |
|
|
|
Align Right |
CTRL+R |
|
|
|
Justify |
CTRL+J |
|
|
|
Increase Indent |
CTRL+M |
|
|
|
Decrease Indent |
CTRL+SHIFT +M |
|
|
|
Add Bullet List |
CTRL +SHIFT +L |
|
|
|
Increase /Decrease Space Before
Paragraph |
|
|
|
|
Increase |
CTRL+O |
|
|
|
Decrease |
CTRL+SHIFT +0 |
|
|
0 Comments