shortcuts (computer commannds)

CCCOOOMMMPPPUUUTTTEEERRR

CCCOOOMMMMMMAAANNNDDDSSS

Nadeem Xaman Wattoo

1

Muhammad Nadeem Zaman wattoo MA, M.ED, LLB, ACCUF, O.T.A, MOUS

FOR LEARNERS / USERS OF COMPUTER

COMPUTER COMMANDS

2

KEY BOARD SHORT CUTS (WINDOWS) GENERAL WINDOW KEYS

HELP F1

QUITE A PROGRAMME ALT +F4

VIEW THE SHORT CUT MENUE FOR THE SELECT ITEM SHIFT+F10

DISPLAY THE START MENUE CRTL+ESC

SWITCH TO THE WINDOW YOU LAST USED. OR SWITCH TO NEXT

WINDOW ALT+TAB

CUT CTRL+X

COPY CTRL+C

PAST CTRL+V

DELETE DEL

UNDO Ctrl+Z

FOR THE DESKTOP, MY COMPUTER AND WINDOW EXPLORER WHEN AN ITEM IS SELECTED, YOU CAN

USE THE FOLOWING SHORTCUTS KEYS

RENAME AN ITEM F2

FIND A FOLDER OR FILE F3

DELETE WITHOUT PLACING THE ITEM IN THE RECYCLE BIN SHIFT+DELETE

VIEW ITEM PROPERTIES ALT+ENTER

COPY A FILE WHILE DRAGGING CTRL KEY

CREATE A SHORTCUT (WHILE DRAGGING) CTRL+SHIFT

FOR MY COMPUTER AND WINDOW EXPLORER

SELECT ALL CTRL+A

REFERSH A WINDOW F5

VIEW THE FOLDER ONE LEVEL UP BACKSPACE

SWITCH BETWEEN LEFT AND RIGHT PANES F6

FOR WINDOW EXPLORER ONLY

GO TO CTRL+G

EXPAND ALL SUBFLDERS UNDER THE SELECTED FOLDER NUMLOCK+*

EXPAND THE SELECTED FOLDER NUMLOCK+

COLLAPSE THE SELECTED FOLDER NUMLOCK+

FOR PROPERTIES DIALOG BOXES

MOVE FORWARD THROUGH OPTIONS TAB

MOVE BACKWARD THROUGH OPTIONS SHIFT+TAB

MOVE FORWARD THROUGH TABS CTRL+TAB

3

MOVE BACKWARD THROUGH TABS CTRL+SHIFT+TAB

FOR OPEN AND SAVE AS DIALOG BOXES

OPEN AND SAVE IN OR LOOK IN LIST F4

REFRESH F5

OPEN THE FOLDER ONE LEVEL UP (SELECTED FOLDER) BACKSPACE

CHANGING FONT AND FONT SIZE

CHANGE THE FOUNT CTRL+SHIFT+F

CHANGE THE FONT SIZE CTRL+SHIFT+P

INCREASE THE FONT SIZE TO NEXT AVAL SIZE CTRL+SHIFT+ >

DECREASE THE FONT SIZE TO THE PREVIOUS AVAL SIZE CTRL+SHIFT+ <

INCREASE THE FONT SIZE BY 1 POINT CTRL+ ]

DECREASE THE FONT SIZE BY 1 POINT CTRL+ [

CHANGING TEXT FORMATTING

CHANGE THE CASE OF LETTERS SHIFT+F3

CREATE ALL CAPITAL LETTERS CTRL+SHIFT+A

MAKE TEXT BOLD CTRL+B

UNDERLINE THE TEXT CTRL+U

UNDERLINE SINGLE WORDS CTRL+SHIFT+W

DOUBLE UNDERLINE SINGLE WORDS CTRL+SHIFT+D

APPLY HIDDEN TEXT FORMAT CTRL+SHIFT+H

ITALICIZE TEXT CTRL+I

CREATE SMALL CAPITAL LETTERS CTRL+SHIFT+K

APPLY SUBCRIPTS (AUTO SPACING) CTRL+ =

APPLY SUPERSCRIPT (AUTO SPACINT) CTRL+SHIFT+ =

REMOVING FORMATTING APPLIED BY USNING SHORTCUT KEYS CTRL+SHIFT+Z

MENU COMMANDS (PLAIN TEXT)

CREATE SYMBOL FONT CTRL+SHIFT+Q

DISPLAY NON PRINTING CHARACTERS CTRL+SHIFT+8 OR *

SETTING LINE SPACING

SINGLE SPACE LINES CTRL+1

DOUBLE SPACE LINES CTRL+2

(1 ½)ONE AND A HALF SPACED LINES CTRL+5

ADD ONE LINE OF SPACE OF PRECEDING TEXT CTRL+0

4

SETTING PARAGRAPH ALIGNMENTS AND IDENTS

CENTRE A PARAGRAPH CTRL+E

JUSTIFY A PARAGRAPH CTRL+J

LEFT ALIGN A PARAGRAPH CTRL+L

RIGHT ALIGH A PARAGRAPH CTRL+R

INDENT A PARAGRAPH LEFT CTRL+M

REMOVE A PARAGRAPH INDENT FROM THE LEFT CTRL+SHIFT+M

CREATE A HANGING INDENT CTRL+T

REDUCE A HANGING INDENT CTRL+SHIFT+T

REMOVE PARAGRAPH FORMATTING APPLIED BY USING

SHORTCUT KEYS CTRL+Q

DELETE TEXT AND GRAPHICS

DELETE ONE CHARACTER TO THE LEFT OF THE INSERTION

POINT BACKSPACE

DELETE ONE WORD CTRL+BACKSPACE

DELETE ONE CHARACTER TO THE RIGHT OF THE INSERTION

POINT DELETE

DELETE ONE WORD CTRL+DELETE

CUT SELECTED TEXT CTRL+X

UNDO THE LAST ACTION CTRL+Z

COPYING/ PASTING

COPY TEXT OR GRAPHIC CTRL+C

COPY FORMATS CTRL+SHIFT+C

MOVE TEXT OR GRAPHICS F-2

PASTE TEXT OR GRAPHICS CTRL+V

PASTE FORMATS CTRL+SHIFT+V

INSERTING

A FIELD CTRL+F9

AN AUTO TEXT ENTRY AUTO TEXTENTRY NAME F3 or ALT+ CTRL+V

A LINE BREAK SHIFT+ENTER

A PAGE BREAK CTRL+ENTER

TO SELECT TEXT AND GRAPHICS

SELECT THE NEAREST CHARACTER F8+CHARACTER

EXTEND A SELECTION F8

REDUCE THE SIZE OF SELECTION SHIFT+F8

ONE CHARACTER TO THE RIGHT SHIFT+RIGHT ARROW ( )

5

ONE CHARACTER TO THE LEFT SHIFT+LEFT ARROW ( )

TO THE BEGINNIG OF A WORD CTRL+SHIFT+ LEFT ARROW ( )

TO THE END OF A WORD CTRL+SHIFT+ RIGHT ARROW( )

TO THE END OF LINE SHIFT+END

TO THE BEGINNING OF A LINE SHIFT+HOME

ONE LINE DOWN SHIFT+

ONE LINE UP SHIFT+

TO THE END OF PARAGRAPH CTRL+SHIFT+

TO THE BEGINNING OF A PARAGRAPH CTRL+SHIFT+

ONE SCREEN DOWN SHIFT+PAGEDOWN

ONE SCREEN UP SHIFT+PAGEUP

TO THE END OF DOCUMENT CTRL+SHIFT+END

TO THE BEGINNING OF A DOCUMENT CTRL+SHIFT+HOME

TO SELECTION THE ENTIRE DOCUMENT CTRL+A

TO A VERTICCAL BLOCK OF TEXT ARROW KEYS CTRL+SHIFT+F8

MOVING IN A TABLE

NEXT CELL IN ROW TAB

PREVIOUS CELL IN ROW SHIFT+TAB

FIRST CELL IN ROW ALT+HOME

TOP CELL IN A COLUMN ALT+PAGE UP

LAST CELL IN A ROW ALT+END

LAST CELL IN A COLUMN ALT+PAGE DOWN

PREVIOUS ROW UP ARROW ( )

NEXT ROW DOWN ARROW ( )

INSERT NEW PARAGRAPH INTO A CELL ENTER

INSERT TAB CHARACTER INTO A CELL CTRL+TAB

MOVING TO A CHARACTER, WORD, PARAGRAPH, COLUMN OR OBJECT

ONE CHARACTER TO THE LEFT LEFT ARROW ( )

ONE CHARACTER TO THE RIGHT RIGHT ARROW ( )

ONE WORD TO THE LEFT CTRL+

ONE WORD TO THE RIGHT CTRL+

ONE PARAGRAPH UP CTRL+

ONE PARAGRAPH DOWN CTRL+

6

MOVING TO THE LINE, PAGE, SCREEN, THE BEGINNING OR END OF A DOCUMENT

UP ONE LINE

DOWN ONE LINE

TO THE END OF A LINE END

TO THE BEGINNING OF A LINE HOME

UP ONE PAGE ALT+CTRL+PAGE UP

DOWN ONE PAGE ALT+CTRL+PAGE DOWN

UP ONE SCREEN PAGE UP

DOWN ONE SCREEN PAGE DOWN

TO THE BOTTOM OF A SCREEN CTRL+PAGE DOWN

TO THE TOP OF A SCREEN CTRL+PAGE UP

TO THE END OF A DOCUMENT CTRL+END

TO THE BEGINNING OF A DOCUMENT CTRL+HOME

TO A PREVIOUS REVISION SHIFT+F5

FILE MENU COMMANDS

NEW CTRL+N

OPEN CTRL+O

CLOSE CTRL+W

SAVE CTRL+S

SAVE AS F12

PRINT PREVIEW CTRL+F2

PRINT CTRL+P

EXIT ALT+F4

EDIT MENU COMMANDS

UNDO CTRL+Z

REPEAT CTRL+Y

CLEAR DELETE

CUT CTRL+X

COPY CTRL+C

PASTE CTRL+V

SELECT ALL CTRL+A

FIND CTRL+F

REPLACE CTRL+H

7

GO TO CTRL+G OR (F5)

BOOK MARK CTRL+SHIFT+F5

UPDATE LINK CTRL+SHIFT+F7

VIEW COMMANDS

NORMAL ALT+CTRL+N

OUTLINE ALT+CTRL+O

PAGE LAYOUT ALT+CTRL+P

INSERT COMMANDS

PAGE NUMBER ALT+SHIFT+P

ANNOTATION ALT+CTRL+A

DATE AND TIME ALT+SHIFT+D

FOOTNOTE ALT+CTRL+F

END NOTE ALT+CTRL+E

MARK INDEX ENTRY ALT+CTRL+X

MARK CITATION ENTRY ALT+SHIFT+I

MARK TOC ENTRY ALT+SHIFT+O

FORMAT MENU COMMANDS

FONT CTRL+D

CHANGE CASE SHIFT+F3

INSERT HYPERLINK CTRL+K

STYLE CTRL+SHIFT+S

TOOLS MENU COMMANDS

SPELLING F7

THEASAURUS (GLOSSARY) SHIFT+F7

TABLE MENU COMMANDS

SELECT TABLE ALT+5

AUTO FORMAT UPDATE LOOK ALT+CTRL+U

WINDOW MENU COMMANDS

SPLIT ALT+CTRL+S

REMOVE SPLIT ALT+CTRL+S

HELP MENU COMMANDS

CONTENTS F1

CONTEXT SENSITIVE HELP SHIFT+F1

8

CIRCULATION IN ALL OPEN PROGRAMME ALT+TAB

REPEAT LAST ACTION F4

SUBSCRIPT CTRL+

SUPERSCRIPT SHIFT+CTRL+

DELETE ONE WORD TO THE LEFT CTRL+BACKSPACE

DELETE ONE WORD TO THE RIGHT CTRL+DELETE

CUT SELECTED OBJECT CTRL+X

COPY SELECTED OBJECT CTRL+C

PASTE CUT OR COPIED OBJECT CTRL+V

KEYS FOR WORKING IN AN OUTLINE

PROMOTE A PARAGRAPH ALT+SHIFT+LEFT ARROW ( )

DEMOTE A PARAGRAPH ALT+SHIFT+RIGHT ARROW ( )

MOVE SELECTED PARAGRAPH UP ALT+SHIFT+UP ARROW ( )

MOVE SELECTED PARAGRAPH DOWN ALT+SHIFT+ DOWN ARROW ( )

SHOW HEADING LEVEL 1 ALT+SHIFT+1

EXPAND TEXT BELOW A HEADING ALT+SHIFT+ PLUS (+)

COLLAPSE TEXT BELOW A HEADING ALT+SHIFT+MIUS (-)

SHOW ALL TEXT OR HEADINGS ALT+SHIFT+A

TURN CHARACTER FORMATTING ON OR OFF SLASH (/) ON THE NUMERIC KEYPAD

TIP YOU CAN USE THE SAME KEYS IN SLIDE VIEW AS YOU DO IN OUTLINE VIEW TO PROMOTE AND

DEMOTE PARAGRAPHS AND TO MOVE SELECTED PARAGRAPHS UP AND DOWN

KEYS FOR WORKING IN WINDOWS AND DIALOG BOXES IN WINDOW

SWITCH TO THE NEXT PROGRAM ALT+TAB

SWITCH TO THE PREVIOUS PROGRAM ALT+SHIFT+TAB

SHOW THE WINDOW START MENUE CTRL+ESC

CLOSE THE ACTIVE PRESENTATION WINDOW CTRL+W

RESTORE THE ACTIVE PRESENTATION WINDOW CTRL+F5

SWITCH TO THE NEXT PRESENTATION WINDOW CTRL+F6

SWITCH TO THE PREVIOUS PRESENTATION WINDOW CTRL+SHIFT+F6

CARRY OUT THE MOVE COMMAND(PRESENTATION ICON MENU, MENU BAR) CTRL+F7

CARRY OUT THE SIZE COMMAND (PRESENTATION ICON MENU, MENU BAR) CTRL+F8

MINIMIZE THE PRESENTATION WINDOW CTRL+F9

MAXIMIZE THE PRESENTATION WINDOW CTRL+F10

9

IN A DIALOG BOX

SWITCH TO THE NEXT TAB IN A DIALOG BOX CTRL+TAB OR CTRL+PAGE DOWN

SWITCH TO THE PREVIOUS TAB IN ADIALOG BOX CTRL+SHIFT+TAB OR CTRL+PAGE

UP

MOVE TO THE NEXT OPTION OR OPTION GROUP TAB KEY

MOVE TO THE PREVIOUS TAB OR OPTION GROUP SHIFT+TAB

OPEN A SELECTED DROP DOWN LIST BOX ALT+DOWN ARROW

CLOSE A SELECTED DROP DOWN LIST BOX ESC

PERFORM THE ACTION ASSIGNED TO A DEFAULT BUTTON ENTER

CANCEL A COMMAND AND CLOSE A DIALOG BOX ESC

IN A TEXT BOX

MOVE TO THE BEGINNING OF THE ENTRY HOME

MOVE TO THE END OF THE ENTRY END

MOVE ONE CHARACTER TO THE LEFT OR RIGHT LEFT ARROW KEY OR RIGHT ARROW KEY ( ),( )

MOVE ONE CHARACTER TO THE LEFT OR RIGHT CTRL+ (LEFT ARROW / RIGHT ARROW) ( ) ( )

SELECT FROM THE INSERTION POINT TO THE BEGINNING OF THE

ENTRY SHIFT+HOME

SELECT FROM THE INSERTION POINT TO THE END OF THE ENTRY SHIFT+END

SELECT OR UNSELECT ONE CHARACTER TO THE LEFT SHIFT+LEFT ARROW ( )

SELECT OR UNSELECT ONE CHARACTER TO THE RIGHT SHIFT+RIGHT ARROW ( )

SELECT OR UNSELECT ONE WORD TO THE LEFT CTRL+SHIFT+LEFT ARROW ( )

SELECT OR UNSELECT ONE WORD TO THE RIGHT CTRL+SHIFT+RIGHT ARROW ( )

KEYS FOR WORKING WITH MENUS DISPLAY A SHORTCUT MENU THAT SHOWS A LIST OF

COMMANDS RELEVANT TO THE SELECTED OBJECT SHIFT+F10

DISPLAY THE PROGRAM CONTROL MENU ALT+SPACEBAR

SELECT THE NEXT OR PREVIOUS MENU COMMAND DOWN ARRO OR UP ARROW or

SWITCH BETWEEN A SUBMENU AND ITS MAIN MENU LEFT ARROW OR RIGHT ARROW or

KEYS FOR WORKING WITH TOOLBARS

MAKE THE MENU BAR ACTIVEF F10

SELECT THE NEXT OR PREVIOUS TOOLBAR ON THE ACTIVE TOOLBAR CTRL+TAB OR

CTRL+SHIFT+TAB

OPEN THE SELECTED MENU ENTER

PERFORM THE ACTION ASSIGNED TO THE SELECTED BUTTON ENTER

SELECT AN OPTION IN A DROP-DOWN LIST BOX OR IN A DROP-DOWN MENU ON A

BUTTON TO MOVE THROUGH THE OPTIONS, THEN ENTER TO SELECT THE OPTION

THE ARROW KEYS

SLIDE SHOW CONTROLS

ADVANCE TO THE NEXT SLIDE N, ENTER, OR THE SPACEBAR OR CLICK THE MOUSE

RETURN TO THE PREVIOUS SLIDE P OR BACKSPACE

GO TO SLIDE <NUMBER> <NUMBER>+ENTER

DISPLAY A BLACK SCREEN, OR RETURN TO THE SLIDE SHOW FROM A BLACK SCREEN B

10

DISPLAY A WHITE SCREEN, OR RETURN TO THE SLIDE SHOW FROM A WHITE SCREEN W

STOP OR RESTART AN AUTOMATIC SLIDE SHOW S

END A SLIDE SHOW ESC

ERASE ON SCREEN ANNOTATIONS E

GO TO NEXT HIDDEN SLIDE H

SET NEW TIMINGS WHILE REHEARSING T

USE ORIGINAL TIMINGS WHILE REHEARSING O

USE MOUSE CLICK TO ADVANCE WHILE REHEARSING M

RETURN TO THE FIRST SLIDE BOTH MOUSE BUTTON FOR 2 SECONDS

CHANGE THE POINTER TO A PEN CTRL+P

CHANGE THE PEN TO A POINTER CTRL+A

HIDE THE POINTER AND BUTTON TEMPORARILY CTRL+H

HIDE THE POINTER AND BUTTON ALWAYS CTRL+L

DISPLAY THE SHORTCUT MENU SHIFT+F10 OR RIGHT

CLICK

MICROSOFT EXCEL FORMULAS

SUM

=SUM(B5:D5) ENTER (B IS COULMN AND 5 IS ROW

NUMBER)

=(B3+B4+B9) ENTER

=SUM(B3:B5)-(B6:B8) ENTER

MIN

=(J20-L20) ENTER

=SUM(A3:A5)-(D6:D8) ENTER

PERCENTAGE

= (E5/300)*100 ENTER

= (55/100*A2) ENTER

= (A2*55%) ENTER

=SUM (.55*A2) ENTER

AVERAGE = (E5/3) ENTER

GRADING =IF (F5>75,”A”, IF (F5>66,”B+”, IF (F5>50,”B”, IF

(F5>45,”. . . B-“,”FAIL”)))

POSITION

=IF(LARGE(F$5:F$15,1)=F6,”FIRST”,IF(LARGE(F$5:F$15,2)=F6,”SECOND”,

IF(LARGE(F$5:F$15,3)=F6,”THIRD”))) (TO KNOE THE 1ST, 2ND, 3RD, POSN IN THE RESULT SHEET)

FORMULA TO GET COPY OF PREVIOUS NOMINAL ROLL

ETC

=NOMINAL ROLL !A5

(NAME OF SHEET) (COLUMN / ROW REF)

SINGN USED + ADDITION

- SUBTRACTION

/ DIVISION

* MULTIPLICATION

^ EXPONENTS

! SIGN OF EXCLAMATION

OPERATION ORDER OF EXCEL ARGUMENTS a. ADDITION

b. EXPONENTS

c. MULTIPLICATION/DIVISION

d. SUBTRACTION/ADDITION

SHORT COMMANDS

BOLD SCRIPT CTRL+B

ITALIC CTRL+I

UNDERLINE CTRL+U

FILE MENU COMMAND

TO OPEN A NEW WORK BOOK CTRL+N

TO OPEN AN EXISTING WORK BOOK CTRL+O

SAVE CTRL+S

SAVE AS F12

11

PRINT CTRL+P

CLOSE MS EXCEL ALT+F4

EDIT MENU COMMAND

UNDO CTRL+Z


FILL DOWN CTRL+D

FILL REIGHT CTRL+R

CLEAR THE SELECTED ITEM IN A CHART/CLEAR CONTENTS IN WORK SHEET DEL

DELETE THE SELECTED ROW OR COLUMN CTRL+MINS SIGN ( )

INSERT THE NEW COLUMN OR ROW CTRL+PLUS SIGN (+)

DISPLAY THE FIND DIALOG BOX CTRL+F

DISPLAY REPLACEDIALOG BOX CTRL+H

FIND NEXT SHIFT+F4

FIND PREVIOUS CTRL+SHIFT+F4

GO TO F5

INSERT MENU COMMAND

DISPLAY INSERT DIALOG BOX CTRL+SHIFT+PLUS SIGN (+)

INSERT NEW WORK SHEET SHIFT+F11

INSERT NEW CHART SHEET F11

DISPLAY DEFIND NAME DIALOG BOX CTRL+F3

DISPLAY THE PASTE NAME DIALOG BOX F3

DISPLAY CREATE NAME DIALOG BOX CTRL+SHIFT+F3

FORMAT MENU COMMAND

FORMAT CELL TABBED DIALOG BOX CTRL+1

HIDE ROW CTRL+9

UN HIDE ROW CTRL+SHIFT+(

HIDE COLUMN CTRL+ZERO (0)

UNHIDE COLUMN CTRL+SHIFT+)

DISPLAY THE STYLE DIALOG BOX ALT+ APOSTROPHE (‘)

DATA MENU COMMAND

GROUP A ROW OR A COLUMN ALT+SHIFT+RIGHT ARROW ( )

UNGROUP A ROW OR A COLUMN ALT+SHIFT+LEFT ARROW ( )

WINDOW MENU COMMAND

NEXT WINDOW CTRL+F6 OR CTRL+TAB

PREVIOUS WINDOW CTRL+SHIFT+F6

NEXT PANE F6

PREVIOUS PANE SHIFT+F6

KEYS FOR ENTERNING DATA

ACTIVATE THE CELL AND FORMULA BAR F2

CARRIES OUT AN ACTION ENTER

CANCEL AN ACTION ESC

REPEATS THE LAST ACTION F4


INSERT BLANK CELLS CTRL+SHIFT+PLUS SIGN (+)

DELETES THE SELECTION CTRL+MINUS SIGN ( )

CLEARS THE SELECTION OF FORMULAS AND DATA DEL

ACTIVATES AND CLEARS THE FORMULA BAR WHEN A CELL IS SELECTED, OR

DELETES THE PRECEDING CHARACTER IN THE CELL OR FORMULA BAR.

BACKSPACE

EDITS A CELL NOTE SHIFT+F2

PASTES A NAME INTO A FORMULA F3

12

DISPLAYS THE FUNCTION WIZARD SHIFT+F3

AFTER TYPING A VALID FUNCTION NAME IN A FORMULA,

INSETS THE ARGUMENT NAMES AND PARENTHESES FOR

THE FUNCTION.

CTRL+SHIFT+A

DEFINES A NAME CTRL+F3

CREATES NAMES FROM CELL TEXT CTRL+SHIFT+F3

CALCULATES ALL SHEETS IN ALL OPEN WORKBOOKS CTRL+ IS EQUAL (=) OR CTRL+F9

CALCULATES THE ACTIVE SHEET SHIFT+F9

INSERT THE AUTO SUM SHEET ALT+ IS EQUAL (=)

ENTERS THE DATA CTRL+SEMI COLON (;)

ENTERS THE TIME CTRL+SHIFT+COLON (: )

FILLS DOWN CTRL+D

FILLS RIGHT CTRL+R

MOVES DOWN THROUGH A SELECTION ENTER

MOVES UP THROUGH A SELECTION SHIFT+ENTER

MOVES RIGHT THROUGH A SELECTION TAB

MOVES LEFT THROUGH A SELECTION SHIFT+TAB

FUNCTION KEYS IN MICROSOFT EXCEL

KEY FUNCTION SHIFT CTRL ALT CTRL+SHIFT ALT+SHIFT

F1 HELP WHAT’S THIS? INSERT A

CHART

SHEET

INSERT A

WORK SHEET

F2 EDIT THE ACTIVE

CELL

EDIT A CELL

COMMENT

SAVE AS

COMMAND

SAVE

COMMAND

F3 PASTE A NAME

INTO A FORMULA

PASTE A FUNCTION

INTO A FORMULA

DEFINE A NAME CREAT NAMES BY

UNING ROW AND

COLUMN TABLES

F4 REPEAT THE LAST

ACTION

REPEAT THE LAST

FIND

CLOSE THE WINDOW EXIT

F5 GO TO DISPLAY THE FIND

DIALOG BOX

RESTORE THE

WINDOW SIZE

F6 MOVE TO THE

NEXT PANE

MOVE TO THE

PREVIOUS PANE

MOVE TO THE NEXT

WORKBOOK WINDOW

MOVE TO THE

PREVIOUS

WORKBOOK

WINDOW

F7 SPELLING

COMMAND

MOVE THE WINDOW

F8 EXTEND A

SELECTION

ADD TO THE

SELECTION

RESIZE THE WINDOW DISPLAY THE

MACRO

DIALOG BOX

F9 CALCULATE ALL

SHEETS IN ALL

OPEN WORKBOOK

CALCULATE THE

ACTIVE WORK

SHEET

MINIMIZE THE

WORKBOOK

F10 MAKE THE MENU

BAR ACTIVE

DISPLAY A

SHORTCUT MENU

MAXIMIZE OR

RESTORE THE

WORKBOOK WINDOW

F11 CREATE A CHART INSERT A NEW

WORKSHEET

INSERT A MICROSOFT

A EXCEL 4.0 MACRO

SHEET

DISPLAY

VISUAL

BASIC

EDITOR

F12 SAVE AS

COMMAND

SAVE COMMAND OPEN COMMAND PRINT COMMAND

DELETE TEXT TO THE END OF THE LINE CTRL+DEL

CANCELS AN ENTRY IN THE CELL OR FORMULA BAR ESC

COMPLETES THE CELL ONLY ENTER

INSERTS A CARRIAGE RETURN ALT+ENTER

COMPLETES THE CELL ENTRY AND MOVES TO THE NEXT CELL TAB

COMPLETES THE CELL ENTRY AND MOVES TO THE PREVIOUS CELL SHIFT+TAB

INSERT A TAB CTRL+TAB+ALT

13

MOVES ONE CHARACTER UP, DOWN, LEFT OR RIGHT ARROWS KEYS ( , , ,

)

MOVES TO THE START OF THE LINE HOME

INSERT THE DATE CTRL+SEMI COLON (;)

INSERT THE TIME CTRL+SHIFT+COLON (: )

COPIES THE VALUE FROM THE CELL ABOVE THE ACTIVE CELL INTO THE

CELL OR FORMULA BAR

CTRL+SHIFT+INVERTED

COMMAS(”)

ALTERNATES BETWEEN DISPLAY VALUES OR FORMULAS IN CELLS CTRL+ ‘ (SINGLE LEFT)

COPIES THE FORMULA FROM THE CELL ABOVE THE ACTIVE CELL INTO

THE CELL OR FORMULA BAR

CTRL+’ (APOSTROPHE)

ENTERS THE FORMULA AS AN ARRY FORMULA CTRL+SHIFT+ENTER

FILLS A SELECTION OF CELLS WITH THE CURRENT ENTRY CTRL+ENTER

CONVERTS SELECTED REFERENCES FROM RELATIVE TO ABSOLUTE. F4

AFTER TYPING A VALID FUNCTION NAME INA FORMULA, DISPLAYS STEP 2

OF THE FUNCTION WIZARD

CTRL+A

AFTER TYPING A VALID FUNCTION NAME IN A FORMULA, INSERTS THE

ARGUMENT NAMES AND PARENTHESES FOR THE FUNCTON.

CTRL+SHIFT+A

FUNCTION KEYS IN MICROSOFT EXCEL SHORT COMMANDS

EXPORT CTRL+E

PASTE INTO INS

DUPLICATE CTRL+D

EDIT SHIFT+ENTER

SELECT ALL CTRL+A

VIEW

FIT IN WINDOW CTRL+W

ZOOM 100% CTRL+1

ZOOM IN CTRL+GREY(+)

ZOOM OUT CTRL+GREY( )

ZOOM ON SELECTION CTRL+U

HIDE SELECTION CTRL+H

SHOW ALL CTRL+V

SNAP TO GRID CTRL+Y

REDRAW NOW CTRL+R

INSERT

TEXT CTRL+T

GRAPHIC CTRL+G

BACKGROUND GRAPHIC CTRL+B

FILL CTRL+F

OBJECT

MOVE UP ALT+GREY(+)(NUMERIC

KEY PAD)

MOVE BACK ALT+GREY ( ) (NUMERIC

KEY PAD)

MAXIMIZE CTRL+M

LOCK CTRL+L

UNLOCK CTRL+K

WINDOW KEY BOARD SHORTCUTS

HELP ON THE SELECTED DIALOG ITEM F1

14

QUITE A PROGRAM ALT+F4

VIEW THE SHORTCUT MENU FOR THE SELECTED ITEM SHIFT+F10

DISPLAY THE START MENU CTRL+ESE

FOR THE DESKTOP, MY COMPUTER AND WINDOWS EXPLORER.

WHEN AN ITEM IS SELECTED YOU CAN USED THE FOLLOWING SHORTCUTS KEYS

RENAME AN ITEM F2

FIND A FOLDER OR FILE F3

DELET WITHOUT PLACING THE ITEM IN THE RECYCLE BIN SHIFT+DEL

VIEW ITEM PROPERTIES ALT+ENTER

COPY A FILE (WHILE DRAGGING) CTRL KEY (DRAGGING)

CREAT A SHORTCUT (WHILE DRAGGING) CTRL+SHIFT (DRAGGING)

FOR MY COMPUTER AND WINDOWS EXPLORER

SELECT ALL CTRL+A

REFRESH A WINDOW F5

VIEW THE FOLDER ONE LEVEL UP BACKSPACE

CLOSE THE SELEDTED FOLDER AND ALL ITS PARENT FOLDER SHIFT+CLOSE BUTTON


FOR WINDOW EXPLORER ONLY

GO TO CTRL+G


EXPAND ALL SUBFOLDERS UNDER THE SELECCTED FOLDER NUMLOC+ *

EXPAND THE SELECTED FOLDER NUMLOC+ (+)

COLLAPSE THE SELECTED FOLDER NUMLOC+ ( )

15

MS WORD

SINGLE SPACING CTRL+1

ONE AND HALF SPACING CTRL+5

DOUBLE SPACING CTRL+2

EXTRA SPACING BETWEEN PARAGRAPHS CTRL+0

REMOVE EXTRA SPACING CTRL+0

TO THE NEXT CELL TAB

TO THE PRECEDING CELL SHIFT+TAB

FORWARD ONE CHARACTER RIGHT ARROW

BACKWORD ONE CHARACTER LEFT ARROW

TO THE PRECEDING OR NEXT ROW UP ARROW OR DOWN ARROW

TO THE FIRST CELL OF THE ROW ALT+HOME or ALT+7

TO THE LAST CELL OF THE ROW ALT+END or ALT+1

TO THE FIRST CELL OF THE COLUMN ALT+PAGEUP or ALT+9

TO THE LAST CELL OF THE COLUMN ALT+PAGEDOWN or ALT+3

(TYPING) START A NEW PARAGRAPH ENTER

DELET TEXT DELETE

CHANGING FONT AND FONT SIZE

CHANGE THE FONT CTRL+SHIFT+F

CHANGE THE FONT SIZE CTRL+SHIFT+P

INCREASE THE FONT SIZE TO NEXT AVAL SIZE CTRL+SHIFT+ >

DECREASE THE FONT SIZE TO PREVIOUS AVAL SIZE CTRL+SHIFT+<

INCREASE THE FONT SIZE BY 1 POINT CTRL+ }

DECREASE THE FONT SIZE BY 1 POINT CTRL+ {

CHANGING TEXT FORMATTING

CHANGE THE CASE OF LETTERS SHIFT+F3

CREATE ALL CAPITAL LETTERS CTRL+SHIFT+A

MAKE TEXT BOLD CTRL+B

UNDERLINE THE TEXT CTRL+U

UNDERLINE SINGLE WORDS CTRL+SHIFT+W

DOUBLE UNDERLINE WORDS CTRL+SHIFT+D

APPLY HIDDEN TEXT FORMAT CTRL+SHIFT+H

16

ITALICIZE TEXT CTRL+I

CREATE SMALL CAPITAL LETTERS CTRL+SHIFT+K

APPLY SUBSCRIPTS (AUTO SPACING) CTRL+ IS EQUAL (=)

APPLY SUPERSCRIPT (AUTO SPACING) CTRL+SHIFT+ IS EQUAL (=)

REMOVING FORMATTING APPLIED BY USING SHORTCUTS KEYS CTRL+SHIFT+Z

CREATE SYMBOL FONT CTRL+SHIFT+Q

DISPLAY NON PRINTING CHARACTERS CTRL+SHIFT+ *

PARAGRAPH ALIGNMENTS AND IDENTS

CENTRE A PARAGRAPH CTRL+E

JUSTIFY A PARAGRAPH CTRL+J

LEFT - ALIGN A PARAGRAPH CTRL+L

RIGHT – ALIGN A PARAGRAPH CTRL+R

INDENT A PARAGRAPH FROM LEFT CTRL+M

REMOVE A PARAGRAPH INDENT FROM LEFT CTRL+SHIFT+M

CREATE A HANGING INDENT CTRL+T

REDUCE A HANGING INDENT CTRL+SHIFT+T

REMOVE PARAGRAPH FORMATTING APPLIED BY USING SHORTCUT KEYS CTRL+Q

DELETE TEXT AND GRAPHICS

DELETE ONE CHARACTER TO THE LEFT OF THE INSERTING POINT BACKSPACE

DELETE ONE WORD TO THE LEFT OF THE INSERTING POINT CTRL+BACKSPACE

DELETE ONE CHARACTER TO THE RIGHT OF THE INSERTING POINT DELETE

DELETE ONE WORD TO THE RIGHT OF THE INSERTING POINT CTRL+DELETE

CUT (SELECTED TEXT) CTRL+X


COPYING/PASTING

COPY TEXT OR GRAPHIC CTRL+C

COPY FORMATS CTRL+SHIFT+C

MOVE TEXT OR GRAPHICS F2

PASTE TEXT OR GRAPHICS CTRL+V

PASTE FORMATS CTRL+SHIFT+V

INSERTING

A FIELD CTRL+F9

17

AN AUTO TEXT ENTRY AUTO TEXT ENTRY NAME F3 OR CTRL+ALT+V

A LINE BREAK SHIFT+ENTER

A PAGE BREAK CTRL+ENTER

TO SELECT TEXT AND GRAPHICS

SELECT THE NEARST CHARACTER F8+CHARACTER

EXTEND A SELECTION F8

REDUCE THE SIZE OF SELECTION SHIFT+F8

ONE CHARACTER TO THE RIGHT SHIFT+ OR CLICK WITH

MOUSE

ONE CHARACTER TO THE LEFT SHIFT+ OR CLICK WITH

MOUSE

TO THE END OF A WORD CTRL+SHIFT+

TO THE BEGINNING OF A WORD CTRL+SHIFT+

TO THE END OF A LINE SHIFT+END

TO THE BEGINNING OF A LINE SHIFT+HOME

ONE LINE UP SHIFT+

ONE LINE DOWN SHIFT+

TO THE BEGINNING OF A PARAGRAPH CTRL+SHIFT+

TO THE END OF PARAGRAPH CTRL+SHIFT+

ONE SCREEN DOWN SHIFT+PAGEDOWN

ONE SCREEN UP SHIFT+PAGE UP

TO THE END OF DOCUMENT CTRL+SHIFT+END

TO THE BEGINNING OF DOCUMENT CTRL+SHIFT+HOME

TO SELECT THE ENTIRE DOCUMENT CTRL+A

MOVING IN A TABLE

NEXT CELL IN A ROW TAB

PREVIOUS CELL IN A ROW SHIFT+TAB

FIRST CELL IN A ROW ALT+HOME

LAST CELL IN ROW ALT+END

TOP CELL IN A COLUMN ALT+PAGEUP

LAST CELL IN COLUMN ALT+PAGEDOWN

PREVIOUS ROW UP ARROW

NEXT ROW DOWN ARROW

INSERT NEW PARAGRAPH INTO A CELL ENTER

INSERT A TAB CHARACTER INTO A CELL CTRL+TAB

18

MOVING TO A CHARACTER, WORD, PARAGRAPH, COLUMN OR OBJECT

UP ONE LINE UP ARROW

DOWN ONE LINE DOWN ARROW

TO THE END OF A LINE END

TO THE BEGINNING OF A LINE HOME

UP ONE PAGE ALT+CTRL+PAGE UP

DOWN ONE PAGE ALT+CTRL+PAGE DOWN

UP ONE SCREEN PAGE UP

DOWN ONE SCREEN PAGE DOWN

TO THE BOTTOM OF A SCREEN CTRL+PAGE DOWN

TO THE TOP OF A SCREEN CTRL+PAGE UP

TO THE END OF A DOCUMENT CTRL+END

TO THE BEGINNING OF A DOCUMENT CTRL+HOME

TO A PREVIOUS REVISION SHIFT+F5

EDIT MENU COMMANDS

BOOK MARK CTRL+SHIFT+F5

UPDATE LINK CTRL+SHIFT+F7

VIEW COMMANDS

NORMAL ALT+CTRL+N

OUTLINE ALT+CTRL+O

PAGE LAYOUT ALT+CTRL+P

INSERT COMMANDS

PAGE NUMBER ALT+SHIFT+P

ANNOTATION ALT+CTRL+A

DATE AND TIME ALT+SHIFT+D

FOOTNOTE ALT+CTRL+F

ENDNOTE ALT+CTRL+E

MARK INDEX ENTRY ALT+SHIFT+X

MARK TOC ENTRY ALT+SHIFT+O

MARK CITATION ENTRY ALT+SHIFT+I


FONT CTRL+D

CHANGE CASE SHIFT+F3

19

AUTO FORMAT CTRL+K

STYLE CTRL+SHIFT+S

TOOLS MENU COMMANDS

SPELLING F7

THESAURUS SHIFT+F7

TABLE MENU COMMADS

SELECT TABLE ALT+F5

AUTO FORMAT UPDATE LOOK ALT+CTRL+U


SPILT/REMOVE SPILT ALT+CTRL+S

HELP MENU COMMANDS

CONTENTS F1

CONTEXT SENSITIVE HELP SHIFT+F1

CIRCULATION IN ALL OPEN PROGRAMME ALT+TAB

FOR PARAGRAPH =RAND( )

=LOREM( )


SUBSCRIPT CTRL+

SUPERSCRIPT

SHIFT+CTRL+

MS EXCEL

MICROSOFT EXCEL FORMULAS

SUM

=SUM(B5:D5) ENTER (B IS COULMN AND 5 IS ROW NUMBER)

=(B3+B4+B9) ENTER

=SUM(B3:B5)-(B6:B8) ENTER

MIN

=(J20-L20) ENTER

=SUM(A3:A5)-(D6:D8) ENTER

PERCENTAGE

= (E5/300)*100 ENTER

= (55/100*A2) ENTER

= (A2*55%) ENTER

=SUM (.55*A2) ENTER

AVERAGE

= (E5/3) ENTER

GRADING

=IF (F5>75,”A”, IF (F5>66,”B+”, IF (F5>50,”B”, IF (F5>45,”. . . B-“,”FAIL”))) ENTER

20

=IF(K4>=76,”A”,IF(K4>=66,”B+”,IF(K4>=61,”BH”, IF(K4>=56,”BA”, IF(K4>=51,”BL”,

IF(K4>=61,”BH”,IF(K4>=45,”B-”, IF(K4>=40,”C”, IF(K4>=39,”FAIL”)))))))) ENTER

POSITION

=IF(LARGE(F$5:F$15,4)=F6,”FORTH”, IF(LARGE(F$5:F$15,3)=F6,”THIRD”,

IF(LARGE(F$5:F$15,2)=F6,”SECOND”, IF(LARGE(F$5:F$15,1)=F6,”FIRST”,)))) (TO KNOE THE 1ST, 2ND, 3RD, 4TH

POSN IN THE RESULT SHEET)

= IF(LARGE(F$5:F$15,3)=F6,”THIRD”,””))) (TO KNOE THE 1ST, 2ND, 3RD, 4TH POSN IN THE RESULT SHEET)

FORMULA TO ENTER 5% MARKS OF ACQUIRING WHOSE ACQUIRED ABOVE 60 AND 10% OF ACQUIRING

WHOSE ACQUIRED LESS THAN 60 (ANY SUBJECT)

=IF(B1>60,(B1*5/100), IF(B1<=60,(B1*10/100))) ENTER

FORMULA TO GET COPY OF PREVIOUS OF DOCUMENT, NOMINAL ROLL ETC

=’NOMINAL ROLL’!A5

(NAME OF SHEET) (COLUMN/ROW REFERANCE)

SINGN USED + ADDITION

- SUBTRACTION

/ DIVISION

* MULTIPLICATION

^ EXPONENTS

! SIGN OF EXCLAMATION

OPERATION ORDER OF EXCEL ARGUMENTS a. ADDITION

b. EXPONENTS

c. MULTIPLICATION/DIVISION

d. SUBTRACTION/ADDITION

SHORT COMMANDS

BOLD SCRIPT CTRL+B

ITALIC CTRL+I

UNDERLINE CTRL+U

FILE MENU COMMAND

TO OPEN A NEW WORK BOOK CTRL+N


SAVE CTRL+S

SAVE AS F12

PRINT CTRL+P


EDIT MENU COMMAND

UNDO CTRL+Z


EDIT MENU COMMAND

FILL DOWN CTRL+D

FILL REIGHT CTRL+R






FIND NEXT SHIFT+F4


GO TO F5

INSERT MENU COMMAND





21



FORMAT MENU COMMAND


HIDE ROW CTRL+9

UNHIDE ROW CTRL+SHIFT+(




DATA MENU COMMAND

GROUP A ROW OR A COLUMN ALT+SHIFT+RIGHT ARROW ( )

UNGROUP A ROW OR A COLUMN ALT+SHIFT+LEFT ARROW ( )

WINDOW MENU COMMAND

NEXT WINDOW CTRL+F6 OR CTRL+TAB


NEXT PANE F6


KEYS FOR ENTERNING DATA






INSERT BLANK CELLS CTRL+SHIFT+PLUS SIGN (+)





BACKSPACE




AFTER TYPING A VALID FUNCTION NAME IN A FORMULA,

INSETS THE ARGUMENT NAMES AND PARENTHESES FOR

THE FUNCTION.

CTRL+SHIFT+A



CALCULATES ALL SHEETS IN ALL OPEN WORKBOOKS CTRL+ IS EQUAL (=) OR CTRL+F9





FILLS DOWN CTRL+D

FILLS RIGHT CTRL+R





KEYS FOR WORKING IN CELLS OR THE FORMULA BAR


START A FORMULA =

22

DELETE THE CHARACTER TO LEFT OF THE INSERTION POINT DEL

DELETE THE CHARACTER TO RIGHT OF THE INSERTION

POINT

BACKSPACE


CANCEL AN ENTRY IN THE CELL OR FORMULA BAR ESC

COMPLETES THE CELL ENTRY ENTER

INSERT A TAB CTRL+ALT+TAB


COMPLETES THE CELL ENTRY AND MOVES TO THE NEXT

CELL

TAB

COMPLETES THE CELL ENTRY AND MOVES TO THE PREVIOUS

CELL

SHIFT+TAB


MOVES ONE CHARACTER UP, DOWN, LEFT OR RIGHT ARROWS KEYS ( , , , )




COPIES THE VALUE FROM THE CELL ABOVE THE ACTIVE

CELL INTO THE CELL OR FORMULA BAR

CTRL+SHIFT+INVERTED COMMAS(”)

ALTERNATES BETWEEN DISPLAY VALUES OR FORMULAS IN

CELLS

CTRL+ ‘ (SINGLE LEFT)

COPIES THE FORMULA FROM THE CELL ABOVE THE ACTIVE

CELL INTO THE CELL OR FORMULA BAR




CONVERTS SELECTED REFERENCES FROM RELATIVE TO

ABSOLUTE.

F4

AFTER TYPING A VALID FUNCTION NAME INA FORMULA, DISPLAYS STEP 2 OF THE FUNCTION

WIZARD

CTRL+A

AFTER TYPING A VALID FUNCTION NAME IN A FORMULA, INSERTS THE ARGUMENT

NAMES AND PARENTHESES FOR THE FUNCTON.

CTRL+SHIFT+A

EXAMINING THE ERROR VALUES

THE FORMULA IS ATTEMPTING TO DIVIDE BYZERO. CHECK THE CELL REFERENCES

FOR BLANKS OR ZEROS THAT MAY HAVE RESULTED IF YOU DELETED A CELL

REFERENCED BY THE FORMULA

#DIV/0

THE FORMULA REFERS TO A CELL WITH A #N/A ENTRY OR A CELL THAT CONTAINS NO

VALUE. THIS ERROR VALUE WARMS YOU THAT NOT ALL THE DATA REFERENCED BY A

FORMULA IS AVAILABLE.

#N/A

EXCEL DOESN’T RECOGNIZE A NAME YOU ENTERED IN A FORMULA. VERIFY THAT ALL

NAMES USED IN THE FORMULA EXIST, AND DEFINE ANY MISSING NAMES. IF

APPLICABLE, VERIFY THAT YOU USED THE CORRECT FUNCTION NAME.

#NAME?

THE FORMULA SPECIFIES TWO AREAS THAT DON’T INTERSECT. CHECK TO SEE IF YOU

ENTERED THE CELL OR RANGE REFERENCE INCORREXCTLY. REMEMBER TO USE

COMMAS (NOT SPACE) BETWEEN FUNCTION ARGUMENTS

#NULL!

THERE IS A PROBLEM WITH A NUMBER USED IN THE FORMULA. CHECK FOR THE

CORRECT USE OR FUNCTION ARGUMENTS.

#NUM!

A CELL REFERENCE IN THE FORMULA IS INCORRECT. CHECK FOR CHANGES TO CELL

REFERENCE CAUSED BY DELETING CELLS, ROWS, OR COLUMNS REFERENCED BY THE

FORMULA.

#REF!

THE FORMULA CONTAINS THE WRONG TYPE OF ARGUMENT OR OPERATOR. CHECK FOR

THE CORRECT SYNTAX OF THE FORMULA.

#VALUE!

STEPS

1. TO DISPLAY THE AUDITING TOOLBAR, CHOOSE TOOLS, AUDTING, AND SHOW AUDITING

TOOLBAR

2. CLICK THE CELL CONTAINING THE ERROR.

23

3. CLICK THE TRACE ERROR BUTTON ON THE AUDITING TOOLBAR. AN ARROOW OR ARROWS SHOW

THE SOURCE OF THE ERROR. CORRECT THE ERRER

4. TO REMOVE THE ARROWS, CLICK THE REMOVE ALL ARROWS BUTTON ON THE AUDITING

TOOLBAR.

SHORT COMMANDS MS EXCEL

FORMATTING

BOLD

ITALIC

UNDERLINE

CTRL+B

CTRL+I

CTRL+U

ALL THESE

COMMANDS

FUNCTION WHEN

CELL IS ACTIVE OR

SELECTED.

FILE MENU COMMANDS

TO OPEN A NEW WORK BOOK. CTRL+N


SAVE CTRL+S

SAVE AS F12

PRINT CTRL+P


EDIT MENU COMMANDS

UNDO CTRL+Z


FILL DOWN CTRL+D

FILL REIGHT CTRL+R






FIND NEXT SHIFT+F4


GO TO F5

INSERT MENU COMMANDS









HIDE ROW CTRL+9

UN HIDE ROW CTRL+SHIFT+(




DATA MENU COMMANDS




NEXT WINDOW CTRL+F6 OR CTRL TAB

24


NEXT PANE F6


KEYS FOR ENTERING DATA






INSERT BLANK CELLS CTRL+SHIFT+PLUS SIGN

(+)





BACKSPACE




AFTER TYPING A VALID FUNCTION NAME IN A FORMULA, INSETS THE

ARGUMENT NAMES AND PARENTHESES FOR THE FUNCTION.

CTRL+SHIFT+A



CALCULATES ALL SHEETS IN ALL OPEN WORKBOOKS CTRL+ IS EQUAL (=) OR

CTRL+F9





FILLS DOWN CTRL+D

FILLS RIGHT CTRL+R





KEYS FOR WORKING IN CELLS OR THE FORMULA BAR


START A FORMULA =

DELETE THE CHARACTER TO LEFT OF THE INSERTION POINT DEL

DELETE THE CHARACTER TO RIGHT OF THE INSERTION POINT BACKSPACE


CANCEL AN ENTRY IN THE CELL OR FORMULA BAR ESC

COMPLETES THE CELL ENTRY ENTER

INSERT A TAB CTRL+ALT+TAB


COMPLETES THE CELL ENTRY AND MOVES TO THE NEXT CELL TAB

COMPLETES THE CELL ENTRY AND MOVES TO THE PREVIOUS CELL SHIFT+TAB


MOVES ONE CHARACTER UP, DOWN, LEFT OR RIGHT ARROWS KEYS ( , , ,

)



25


COPIES THE VALUE FROM THE CELL ABOVE THE ACTIVE CELL INTO THE

CELL OR FORMULA BAR

CTRL+SHIFT+INVERTED

COMMAS(”)

ALTERNATES BETWEEN DISPLAY VALUES OR FORMULAS IN CELLS CTRL+ ‘ (SINGLE LEFT)

COPIES THE FORMULA FROM THE CELL ABOVE THE ACTIVE CELL INTO

THE CELL OR FORMULA BAR




CONVERTS SELECTED REFERENCES FROM RELATIVE TO ABSOLUTE. F4

AFTER TYPING A VALID FUNCTION NAME INA FORMULA, DISPLAYS STEP

2 OF THE FUNCTION WIZARD

CTRL+A

AFTER TYPING A VALID FUNCTION NAME IN A FORMULA, INSERTS THE

ARGUMENT NAMES AND PARENTHESES FOR THE FUNCTON.

CTRL+SHIFT+A

FUNCTION KEYS IN MICROSOFT EXCEL

KEY FUNCTION SHIFT CTRL ALT CTRL+SHIFT ALT+SHIF

T

F1 HELP WHAT’S THIS? INSERT A CHART

SHEET

INSERT A

WORK

SHEET

F2 EDIT THE

ACTIVE CELL

EDIT A CELL

COMMENT

SAVE AS COMMAND SAVE

COMMAND

F3 PASTE A NAME

INTO A

FORMULA

PASTE A

FUNCTION INTO A

FORMULA

DEFINE A NAME CREAT NAMES BY

UNING ROW AND

COLUMN TABLES

F4 REPEAT THE

LAST ACTION

REPEAT THE LAST

FIND

CLOSE THE

WINDOW

EXIT

F5 GO TO DISPLAY THE

FIND DIALOG BOX

RESTORE THE

WINDOW SIZE

F6 MOVE TO THE

NEXT PANE

MOVE TO THE

PREVIOUS PANE

MOVE TO THE

NEXT WORKBOOK

WINDOW

MOVE TO THE

PREVIOUS

WORKBOOK

WINDOW

F7 SPELLING

COMMAND

MOVE THE

WINDOW

F8 EXTEND A

SELECTION

ADD TO THE

SELECTION

RESIZE THE

WINDOW

DISPLAY THE MACRO

DIALOG BOX

F9 CALCULATE

ALL SHEETS IN

ALL OPEN

WORKBOOK

CALCULATE THE

ACTIVE WORK

SHEET

MINIMIZE THE

WORKBOOK

F10 MAKE THE

MENU BAR

ACTIVE

DISPLAY A

SHORTCUT MENU

MAXIMIZE OR

RESTORE THE

WORKBOOK

WINDOW

F11 CREATE A

CHART

INSERT A NEW

WORKSHEET

INSERT A

MICROSOFT A

EXCEL 4.0 MACRO

SHEET

DISPLAY VISUAL

BASIC EDITOR

F12 SAVE AS

COMMAND

SAVE COMMAND OPEN COMMAND PRINT COMMAND

KEYS FOR DELETING AND COPYING TEXT AND OBJECTS MS POWER POINT

DELETE ONE CHARACTER TO THE LEFT OF THE INSERTION POINT BACKSPACE

DELETE ONE WORD CTRL+BACKSPACE

DELETE ONE CHARACTER TO THE RIGHT OF THE INSERTION POINT DELETE

DELETE ONE WORD CTRL+DELETE

CUT SELECTED OBJECT CTRL+X

COPY SELECTED OBJECT CTRL+V

PASTE CUT OR COPIED OBJECT CTRL+V


26

KEYS FOR MOVING AROUND IN TEXT

MOVE ONE CHARACTER TO THE LEFT OR RIGHT LEFT ARROW KEY OR RIGHT ARROW KEY ( ),(

)

MOVE ONE WORD TO THE LEFT OR RIGHT CTRL+ (LEFT ARROW / RIGHT ARROW) ( ) (

)

ONE LINE UP UP ARROW

ONE LINE DOWN DOWN ARROW



UP ONE PARAGRAPH CTRL+UP ARROW

DOWN ONE PARAGRAPH CTRL+DOWN ARROW

TO THE BEGINNING OF A TEXT BOX CTRL+HOME

TO THE END OF A TEXT BOX CTRL+END

TO THE NEXT TITLE OF BODY TEXT PLACEHOLDER CTRL+ENTER

TO REPEAT THE LAST FIND ACTION SHIFT+F4

KEYS FOR WORKING IN AN OUT LINE



MOVE SELECTED PARAGRAPH UP ALT+SHIFT+UP ARROW ( )

MOVE SELECTED PARAGRAPH DOWN ALT+SHIFT+ DOWN ARROW ( )

SHOW HEADING LEVEL 1 ALT+SHIFT+1

EXPAND TEXT BELOW A HEADING ALT+SHIFT+ PLUS (+)

COLLAPSE TEXT BELOW A HEADING ALT+SHIFT+MIUS (-)

SHOW ALL TEXT OR HEADINGS ALT+SHIFT+A

TURN CHARACTER FORMATTING ON OR OFF SLASH (/) ON THE NUMERIC KEYPAD

TIP YOU CAN USE THE SAME KEYS IN SLIDE VIEW AS YOU DO IN OUTLINE VIEW TO PROMOTE AND

DEMOTE PARAGRAPHS AND TO MOVE SELECTED PARAGRAPHS UP AND DOWN

KEYS FOR SELECTION TEXT AND OBJECTS

ONE CHARACTER TO THE LEFT OR RIGHT SHIFT+LEFT ARROW KEY OR SHIFT+ RIGHT ARROW

KEY ,

TO THE BEGINNING OF A WORD CTRL+SHIFT+LEFT ARROW

TO THE END OF A WORD CTRL+SHIFT+RIGHT ARROW

ONE LINE UP SHIFT+UP ARROW

ONE LINE DOWN SHIFT+DOWN ARROW

AN OBJECT TAB OR SHIFT+TAB UNTIL THE OBJECT YOU WANT

IS SELECTED

ALL OBJECTS (SLIDE VIEW) CTRL+A

ALL SLIDES (SLIDE SORTER VIEW) CTRL+A

ALL TEXT (OUT LINE VIEW) CTRL+A

KEYS FOR WORKING IN WINDOWS AND DIALOG BOXES IN A WINDOW

SWITCH TO THE NEXT PROGRAM ALT+TAB

SWITCH TO THE PREVIOUS PROGRAM ALT+SHIFT+TAB

SHOW THE WINDOW START MENUE CTRL+ESC

CLOSE THE ACTIVE PRESENTATION WINDOW CTRL+W

RESTORE THE ACTIVE PRESENTATION WINDOW CTRL+F5

SWITCH TO THE NEXT PRESENTATION WINDOW CTRL+F6

SWITCH TO THE PREVIOUS PRESENTATION WINDOW CTRL+SHIFT+F6

CARRY OUT THE MOVE COMMAND(PRESENTATION ICON MENU, MENU

BAR) CTRL+F7

CARRY OUT THE SIZE COMMAND (PRESENTATION ICON MENU, MENU

BAR) CTRL+F8

27

MINIMIZE THE PRESENTATION WINDOW CTRL+F9

MAXIMIZE THE PRESENTATION WINDOW CTRL+F10

IN A DIALOG BOX

SWITCH TO THE NEXT TAB IN A DIALOG BOX CTRL+TAB OR CTRL+PAGE

DOWN

SWITCH TO THE PREVIOUS TAB IN ADIALOG BOX CTRL+SHIFT+TAB OR

CTRL+PAGE UP

MOVE TO THE NEXT OPTION OR OPTION GROUP TAB KEY

MOVE TO THE PREVIOUS TAB OR OPTION GROUP SHIFT+TAB

OPEN A SELECTED DROP DOWN LIST BOX ALT+DOWN ARROW

CLOSE A SELECTED DROP DOWN LIST BOX ESC

PERFORM THE ACTION ASSIGNED TO A DEFAULT BUTTON ENTER

CANCEL A COMMAND AND CLOSE A DIALOG BOX ESC

IN A TEXT BOX



MOVE ONE CHARACTER TO THE LEFT OR RIGHT LEFT ARROW KEY OR RIGHT ARROW

KEY ( ),( )

MOVE ONE CHARACTER TO THE LEFT OR RIGHT CTRL+ (LEFT ARROW / RIGHT ARROW) (

) ( )

SELECT FROM THE INSERTION POINT TO THE BEGINNING OF THE ENTRY SHIFT+HOME

SELECT FROM THE INSERTION POINT TO THE END OF THE ENTRY SHIFT+END

SELECT OR UNSELECT ONE CHARACTER TO THE LEFT SHIFT+LEFT ARROW ( )

SELECT OR UNSELECT ONE CHARACTER TO THE RIGHT SHIFT+RIGHT ARROW ( )

SELECT OR UNSELECT ONE WORD TO THE LEFT CTRL+SHIFT+LEFT ARROW (

)

SELECT OR UNSELECT ONE WORD TO THE RIGHT CTRL+SHIFT+RIGHT ARROW

( )

KEYS FOR WORKING WITH MENUS

DISPLAY A SHORTCUT MENU THAT SHOWS A LIST OF COMMANDS

RELEVANT TO THE SELECTED OBJECT SHIFT+F10

DISPLAY THE PROGRAM CONTROL MENU ALT+SPACEBAR

SELECT THE NEXT OR PREVIOUS MENU COMMAND DOWN ARRO OR UP ARROW

or

SWITCH BETWEEN A SUBMENU AND ITS MAIN MENU LEFT ARROW OR RIGHT

ARROW or

KEYS FOR WORKING WITH TOOLBARS

MAKE THE MENU BAR ACTIVEF F10

SELECT THE NEXT OR PREVIOUS TOOLBAR ON THE ACTIVE TOOLBAR CTRL+TAB OR

CTRL+SHIFT+TAB

OPEN THE SELECTED MENU ENTER

PERFORM THE ACTION ASSIGNED TO THE SELECTED BUTTON ENTER

SELECT AN OPTION IN A DROP-DOWN LIST BOX OR IN A DROP-DOWN MENU ON A

BUTTON TO MOVE THROUGH THE OPTIONS, THEN ENTER TO SELECT THE OPTION

THE ARROW KEYS

SLIDE SHOW CONTROLS

ADVANCE TO THE NEXT SLIDE N, ENTER, OR THE SPACEBAR OR CLICK

THE MOUSE

RETURN TO THE PREVIOUS SLIDE P OR BACKSPACE

GO TO SLIDE <NUMBER> <NUMBER>+ENTER

DISPLAY A BLACK SCREEN, OR RETURN TO THE SLIDE SHOW FROM A BLACK SCREEN B

DISPLAY A WHITE SCREEN, OR RETURN TO THE SLIDE SHOW FROM A WHITE SCREEN W

STOP OR RESTART AN AUTOMATIC SLIDE SHOW S

END A SLIDE SHOW ESC

28

ERASE ON SCREEN ANNOTATIONS E

GO TO NEXT HIDDEN SLIDE H

SET NEW TIMINGS WHILE REHEARSING T

USE ORIGINAL TIMINGS WHILE REHEARSING O

USE MOUSE CLICK TO ADVANCE WHILE REHEARSING M

RETURN TO THE FIRST SLIDE BOTH MOUSE BUTTON FOR 2

SECONDS

CHANGE THE POINTER TO A PEN CTRL+P

CHANGE THE PEN TO A POINTER CTRL+A

HIDE THE POINTER AND BUTTON TEMPORARILY CTRL+H

HIDE THE POINTER AND BUTTON ALWAYS CTRL+L

DISPLAY THE SHORTCUT MENU SHIFT+F10 OR RIGHT

CLICK

TIP. YOU CAN PRESS F1 DURING A SLIDE SHOW TO SEE A LIST OF CONTROLS.

IN PAGE – KEY BOARD SHORTCUTS

CREATE MOVEMENT AND TEXT SELECTION

PREVIOUS CHARACTER LEFT ARROW

NEXT CHARACTER RIGHT ARROW

PREVIOUS WORD CTRL+LEFT ARROW

NEXT WORD CTRL+RIGHT ARROW

PREVIOUS LINE UP ARROW

NEXT LINE DOWN ARROW

TOP OF PREVIOUS TEXTBOX ALT+UP ARROW

TOP OF NEXT TEXTBOX ALT+DOWN ARROW

TOP OF PARAGRAPH CTRL+UP ARROW

TOP OF NEXT PARAGRAPH CTRL+DOWN ARROW

BEGINNING OF LINE HOME

END OF LINE END

BEGINNING OF STORY CTRL+HOME

END OF STORY CTRL+END

SELECT WORD DOUBLE CLICK

SELECT PARAGRAPH TRIPLE CLICK

SHIFT PRESSED WITH ABOVE KEYS SELECTS THE TEXT TILL CARET POSITION

TEXT EDITING

TOGGLE ENGLISH AND URDU CTRL+SPACE

DELETE PREVIOUS CHARACTER BACKSPACE

DELETE PREVIOUS WORD CTRL+BACKSPACE

DELETE NEXT CHARACTER DEL

DELETE NEXT WORD CTRL+D

CUT CTRL+X OR SHIFT+DEL

COPY CTRL+C, OR CTRL+INSET

PASTE CTRL+V, OR SHIFT+INSERT

UNDO PREVIOUS OPERATION ALT+BACKSPACE, CTRL+Z

SELECT ALL CTRL+A

FIND TEXT CTRL+F

REPLACE TEXT CRTL+R

TEXT FORMATTING

29

BOLD CTRL+B

ITALICS CTRL+I

LEFT ALIGNMENT CTRL+ALT+L

RIGHT ALIGNMENT CTRL+ALT+R

CENTER ALIGNMENT CTRL+ALT+C

JUSTIFIED CTRL+ALT+J

FULL JUSTIFIED CTRL+ALT+F

TOGGLE TEXT AND TAB MODES CTRL+ALT+T

DEFINE STYLE SHEETS CTRL+T

CHARACTER FORMAT CTRL+H

PARAGRAPH FORMAT CTRL+G

INCREASE CHARACTER SPACING CTRL+F5

DECREASE CHARACTER SPACING CTRL+F6

BASELINE SHIFT UP CTRL+F7

BASELINE SHIFT DOWN CTRL+F8

DECREASE FONT SIZE CTRL+F9

INCREASE FONT SIZE CTRL+F10

PAGE MOVEMENT

SCROLL PAGE UP PAGE UP

SCROLL PAGE DOWN PAGE DOWN

CROLL PAGE LEFT CTRL+PAGE UP

SCROLL PAGE RIGHT CTRL+PAGE DOWN

SCROLL PAGE UP BY ONE LINE SHIFT+PAGE UP

SCROLL PAGE DOWN BY ONE LINE SHIFT+PAGE DOWN

SCROLL PAGE LEFT BY ONE LINE CTRL+SHIFT+PAGE UP

SCROLL PAGE RIGHT BY ONE LINE CTRL+SHIFT+PAGE DOWN

PAGE CHANGE

PREVIOUS PAGE ALT+PAGE UP

NEXT PAGE ALT+PAGE DOWN

FIRST PAGE ALT+HOME

LAST PAGE ALT+END

TOGGLE MASTER AND DOCUMENT PAGES ALT+ENTER

PAGE EDITING

DELETE PAGE ALT+DELETE

INSERT PAGE ALT+INSERT

SELECTED OBJECTS MODIFICATION

SELECT ALL OBJECTS CTRL+A

SELECT / DESELECT MULTIPLE OBJECTS SHIFT+MOUSE CLICK

DELETE DELETE

CUT CTRL+X

COPY CTRL+C

PASTE CTRL+V

UNDO PREVIOUS OPERATION CTRL+Z, ALT+BACKSPACE

MOVE SELECTED OBJECTS ARROW KEYS

SMALL MOVEMENT CTRL+ARROW KEYS

MOVE SELECTION POINT ARROW KEYS WITH MOUSE

DOWN

SMALL MOVEMENT OF OBJECTS CTRL+ARROW KEYS WITH

MOUSE

CONSTRAIN MOVEMENT VERTICALLY/HORIZONTALLY SHIFT WHILE MOVING OBJECTS

30

MOVE OBJECTS TO ORIGINAL POSITION ESCAPE WHILE MOVING

OBJECTS

MAKE OBJECT TO SQUARE OR CIRCLE SHIFT WHILE MODIFYING AN

OBJECT

MAKE LINE AT ANY ANGLE SHIFT WHILE MODIFYING A

LINE

SELECTED PICTURES MODIFICATION

MOVE ARROW KEYS

SMALLER MOVEMENT CTRL+ARROW KEYS

DELETE DELETE

CUT CTRL+X

COPY CTRL+C

PASTE CTRL+V

VIEW CHANGE

FIT IN WINDOW F5

50% F6

ACTUAL F7

200% F8

ZOOM IN RIGHT BUTTON CLICK

ZOOM OUT SHIFT+RIGHT BUTTON CLICK

FILE OPERATIONS

CREATE A NEW DOCUMENT CTRL+N

OPEN AN EXISTING DOCUMENT CTRL+O

SAVE DOCUMENT CTRL+S

SAVE AS DOCUMENT CTRL+ALT+S

PRINT DOCUMENT CTRL+P

PRINT SETUP CTRL+ALT+P

CLOSE DOCUMENT CTRL+F4

IMPORT TEXT OR PICTURE CTRL+Y

EXPORT TEXT OR PICTURE CTRL+ALT+Y

IMPORT PICTURE DOUBLE CLICK ON PICTURE BOX

TOOL SELECTION

TEXT BOX SHIFT+F2

PICTURE BOX SHIFT+F3

ELLIPTICAL PICTURE BOX SHIFT+F4

ROUND CORNERED PICTURE BOX SHIFT+F5

GRAPHIC BOX SHIFT+F6

ELLIPTICAL GRAPHIC BOX SHIFT+F7

ROUND CORNERED GRAPHIC BOX SHIFT+F9

LINE SHIFT+F10

MISCELLANEOUS

HELP F1

SNAP TO GUIDES F9

TYPOGRAPHIC PREFERENCES F11

APPLICATION PREFERENCES ALT+F11

DOCUMENT PREFERENCES CTRL+F11

GO TO THE LAST EDITED ITEM IN RIBBON F12

31

GO TO PAGE SCROLL IN STATUS BAR ALT+F12

GO TO THE VIEW IN STATUS BAR CTRL+F12

ABORT CURRENT IMPORT OF TEXT ESC

EXIT ALT+F4

TAB WITH IN A TABLE CELL CTRL+TAB

APPLICATION PREFERENCES DOUBLE CLICK ON TOOL STRIP

TYPOGRAPHIC PREFERENCES DOUBLE CLICK ON TEXT RIBBON

FORMAT GUIDES DOUBLE CLICK ON RULERS

RESET RULLER ORIGIN DOUBLE CLICK ON ORIGINAL BOX

PAGE SCROLL CTRL+LEFT BUTTON CLICK

CREATE OBJECT WITH HANDLES (FOR TEXT, TITLE AND PICTURE

BOXES)

DOUBLE CLICK ON THE TOOL

OPEN FILES FROM FILE MANAGER DRAG DROP INPAGE FILE

IMPORT PICTURES FROM FILE MANAGER IF A PICTURE BOX IS

ACTIVE

DRAG DROP PICTURE FILE

IMPORT TEXT FROM FILE MANAGER IF A PICTURE BOX IS ACTIVE DRAG DROP TEXT FILE

SHORT COMMAND ARTIST

FILE MENU

TO OPEN A NEW CTRL+N

TO OPEN A PREVIOUS DOCUMENT CTRL+O

TO SAVE CTRL+S

SAVE AS F12

TO PRINT CTRL+P

EXPORT CTRL+E

EXIT ALT+F4

EDIT MENU

UNDO CTRL+Z

DELETE DELETE

CUT CTRL+X

COPY CTRL+C

PASTE CTRL+V

PASTE INTO INS

DUPLICATE CTRL+D

EDIT SHIFT+ENTER

SELECT ALL CTRL+A

VIEW

FIT IN WINDOW CTRL+W

ZOOM 100% CTRL+1

ZOOM IN CTRL+GREY(+)

ZOOM OUT CTRL+GREY ( )

ZOOM ON SELECTION CTRL+U

HIDE SELECTION CTRL+H

SHOW ALL CTRL+W

SNAP TO GRID CTRL+Y

REDRAW NOW CTRL+R

INSERT

TEXT CTRL+T

GRAPHIC CTRL+G

BACKGROUND GRAPHIC CTRL+B

32

FILL CTRL+F

OBJECT

MOVE UP ALT+GREY+(NUMERIC KEY

PAD)

MOVE BACK ALT+GREY ( )

MAXIMIZE CTRL+M

LOCK CTRL+L

UNLOCK CTRL+K

NTERNET COMMANDS

Shortcut Description

F2 Edit the selected cell.

F3 After a name has been created F3 will paste names.

F4 Repeat last action. For example, if you changed the color of text in

another cell pressing F4 will change the text in cell to the same color.

F5 Go to a specific cell. For example, C6.

F7 Spell check selected text or document.

F11 Create chart from selected data.

Ctrl + Shift + ; Enter the current time.

Ctrl + ; Enter the current date.

Alt + Shift + F1 Insert New Worksheet.

Alt + Enter While typing text in a cell pressing Alt + Enter will move to the next line

allowing for multiple lines of text in one cell.

Shift + F3 Open the Excel formula window.

Shift + F5 Bring up search box.

Ctrl + A Select all contents of the worksheet.

Ctrl + B Bold highlighted selection.

Ctrl + I Italic highlighted selection.

Ctrl + K Insert link.

Ctrl + U Underline highlighted selection.

Ctrl + 1 Change the format of selected cells.

Ctrl + 5 Strikethrough highlighted selection.

Ctrl + P Bring up the print dialog box to begin printing.

Ctrl + Z Undo last action.

Ctrl + F3 Open Excel Name Manager.

Ctrl + F9 Minimize current window.

Ctrl + F10 Maximize currently selected window.

Ctrl + F6 Switch between open workbooks or windows.

Ctrl + Page up Move between Excel work sheets in the same Excel document.

Ctrl + Page down Move between Excel work sheets in the same Excel document.

Ctrl + Tab Move between Two or more open Excel files.

http://www.computerhope.com/jargon/c/cell.htm

http://www.computerhope.com/jargon/n/name.htm

http://www.computerhope.com/jargon/c/chart.htm

http://www.computerhope.com/jargon/s/spreadsh.htm

http://www.computerhope.com/jargon/f/formula.htm

http://www.computerhope.com/jargon/l/link.htm

http://www.computerhope.com/jargon/s/striketh.htm

http://www.computerhope.com/jargon/n/name.htm

http://www.computerhope.com/jargon/m/minimize.htm

http://www.computerhope.com/jargon/m/maximize.htm

33

Alt + = Create a formula to sum all of the above cells

Ctrl + ' Insert the value of the above cell into cell currently selected.

Ctrl + Shift +! Format number in comma format.

Ctrl + Shift + $ Format number in currency format.

Ctrl + Shift + # Format number in date format.

Ctrl + Shift + % Format number in percentage format.

Ctrl + Shift + ^ Format number in scientific format.

Ctrl + Shift + @ Format number in time format.

Ctrl + Arrow key Move to next section of text.

Ctrl + Space Select entire column.

Shift + Space Select entire row.

Ctrl + - Delete the selected column or row.

Ctrl + Shift + = Insert a new column or row.

Ctrl + Home Move to cell A1.

Ctrl + ~ Switch between showing Excel formulas or their values in cells

http://www.computerhope.com/jargon/c/column.htm

http://www.computerhope.com/jargon/r/row.htm

shortcuts (computer commannds)

Self Improvement

ctrl key

left ctrl shift

ctrl g

paragraph left ctrl

preceding text ctrl

paragraph ctrl e

tabs ctrl shift tab

tabs ctrl tab