Tuesday, 22 August 2017

MICROSOFT EXCLE

1)Absolute/relative/blended reference (F4)

2)AutoSum (ALT=)

3) Bold (CTRL-B)

4)Border lines off (CTRL-SHIFT_)

5) Border lines on (CTRL-SHIFT&)

6)Calculate dynamic (SHEET SHIFT-F9)

7) Calculate all woreksheets (F9)

8)Close (CTRL-W)

9) Collapse determination to dynamic cell (SHIFT - BACKSPACE)

10)Comment embed/alter (SHIFT - F2)

11) Copy (CTRL-C)

12) Copy equation from cell above (CTRL')

13) Copy an incentive from cell above (CTRL-SHIFT'')

14)Cut (CTRL-X)

15)Date (CTRL;)

16)Delete territory (CTRL-)

17)Delete to end of line (CTRL-DEL)

18)Show esteems/recipes (CTRL)

19)Edit cell (F2)

20)Enter recipe as cluster (CTRL-SHIFT-ENTER)

21)Fill down (CTRL-D)

22)Fill right (CTRL-R)

23) Find (CTRL-F)

24)Format commas(2 decimal spots) (CTRL-SHIFT!)

25)Format currency(2 decimal spots) (CTRL-SHIFT$)

26)Format date(day,month,year) (CTRL-SHIFT#)

27) Format exponential number (CTRL-SHIFT^)

(2 decimal spots)

28) Format general number (CTRL-SHIFT~)

29) Format rate (CTRL-SHIFT%)

(0 decimal spots)

30) Format time (hour and moment) (CTRL-SHIFT@)

31)Formula (=)

32)Function Wizard (SHIFT-F3)

33) Go To (CTRL - G)

34) Group push/segment (ALT - SHIFT-RIGHT)

35)Hard Return in cell (ALT - ENTER)

36)Hide Selected column(s) (CTRL-0(ZERO)

37)Hide Selected row(s) (CTRL-F9)

38)Insert Function Components (CTRL-SHIFT-A)

39)Insert outline sheet (F11)

40)Insert territory (CTRL-SHIFT-PLUS)

41)Insert worksheet (SHIFT-F11)

42)Italics (CTRL-I)

43)Menu bar (F10)

44) Move between noncontiguous (CTRL-ALT - LEFT/RIGHT)

Choices

45) Move left/right one screen (ALT-PGUP/PGDN)

46) Move to start of worksheet (CTRL - HOME)

47) Move to edge of district (CTRL - ARROW)

48) Move to end of line (END,ENTER)

49) Move to end of worksheet (CTRL - END)

50) Move to next corner of choice (CTRL .)

51) Move up through a choice (SHIFT-ENTER)

52)Name a range(Insert/Name/Create) (CTRL-SHIFT-F3)

53)Name a range( (Insert/Name/Define) (CTRL-F3)

54)New (CTRL-N)

55)Next window (CTRL-F6)

56)Next worksheet (CTRL PAGE UP)

57) Open (CTRL-O)

58) Outline images show/hide (CTRL-8)

59) paste (CTRL +V)

60) glue named run (F3)

(Embed/Name/glue)

61) Previous Window (CTRL-SHIFT-F6)

62)Previous worksheet (CTRL PAGE DOWN)

63)Print (CTRL-P)

64)Repeat Find (SHIFT-F4)

65)Repeat/Redo (CTRL-Y)

66)Replace (CTRL-H)

67) Save (CTRL-S)

68) Save As (F12)

69)Scroll to show dynamic cell (CTRL-BACKSPACE)

70)Select cluster to which dynamic (CTRL/)

Cell has a place

71)Select cells specifically alluded (CTRL[)

To by chose recipe

72)Select cells alluded (CTRL-SHIFT{)

To by chose recipe

73)Select cells with remarks (CTRL-SHIFT ?)

74)Select section (CTRL-SPACEBAR)

75)Select current district (CTRL-SHIFT*)

76)Select recipes that specifically (CTRL])

Allude to dynamic cell

77)Select recipes that allude (CTRL-SHIFT})

to dynamic cell

78)Select protests on worksheet (CTRL-SHIFT-SPACEBAR)

79)Select row (SHIFT-SPACEBAR)

80)Select to start of line (SHIFT-HOME)

81)Select to start of worksheet (CTRL-SHIFT-HOME)

82)Select to edge of district (CTRL-SHIFT-(ARROW)

83)Select to end of line (END,SHIFT-ENTER)

84)Select to end of worksheet (CTRL-SHIFT-END)

85)Select to obvious cell in determination (ALT;)

86)Select worksheet (CTRL-A)

87)Shortcut Menu (SHIFT-F10)

88)Spelling and Grammar check (F7)

89)Strikethrough on/off (CTRL-5)

90)Style box (ALT')

91)Tab embedded (CTRL-ALT - TAB)

92) Time (CTRL-SHIFT-COLON)

93) Underline (CTRL-U)

94)Undo (CTRL-Z)

95)Ungroup line/section (ALT - SHIFT-LEFT)

96)Unhide column(s) (CTRL-SHIFT))

97)Unhide row(s) (CTRL-SHIFT( )

No comments:

Post a Comment