Computer Shortcut Keys Set 1 www.jawabadda.com

1 How to Bold toggle for selection

a. Ctrl + V

b. Ctrl + B

c. Alt+B

d. Ctrl+Alt+B

2 How to Italic toggle for selection

a. Alt+I

b. Ctrl + I

c. Ctrl+T

d. Alt+T

3 How to Underline toggle for selection

a. Ctrl+T

b. Alt + U

c. Ctrl + U

d. Alt+T

4 How to Strikethrough for selection

a. Ctrl + H

b. Ctrl + 5

c. Alt + H

d. Alt + 5

5 How to Change the font

a. Ctrl + Alt + Shift + F

b. Shift + F

c. Ctrl + Shift + F

d. Ctrl + F

6 How to Change the font size

a. Ctrl + Shift + F

b. Ctrl + Shift + P

c. Ctrl + Shift + S

d. Alt + Shift + P

7 How to Apply outline borders

a. Ctrl + Shift + 4

b. Ctrl + Shift + 5

c. Ctrl + Shift + 6

d. Ctrl + Shift + 7

8 How to Remove all borders

a. Shift + Underline

b. Ctrl + Shift + Underline

c. Ctrl + Underline

d. Alt + Shift + Underline

9 How to Wrap text in same cell

a. Alt + W

b. Alt + R

c. Alt + Enter

d. Alt + T

10 How to Format cells

a. Ctrl + 4

b. Ctrl + 3

c. Ctrl + 2

d. Ctrl + 1

11 How to Select font

a. Ctrl + Alt + Shift + F

b. Shift + F

c. Ctrl + F

d. Ctrl + Shift + F

12 How to Select point size

a. Alt + Shift + P

b. Ctrl + Shift + P

c. Ctrl + Alt + P

d. Alt + P

13 How to Format as currency

a. Ctrl + Shift + 2

b. Ctrl + Shift + 3

c. Ctrl + Shift + 4

d. Ctrl + Shift + 5

14 How to Format as general (to remove any formatting)

a. Ctrl + Shift + $

b. Ctrl + Shift + #

c. Ctrl + Shift + %

d. Ctrl + Shift + *

15 How to Format as percentage

a. Ctrl + Shift + 5

b. Ctrl + Shift + 6

c. Ctrl + Shift + 7

d. Ctrl + Shift + 8

16 How to Format as number

a. Ctrl + Shift + 3

b. Ctrl + Shift + 2

c. Ctrl + Shift + 1

d. Ctrl + Shift + 4

17 How to Delete one character to right

a. Ctrl + Delete

b. Delete

c. Alt + Delete

d. Shift + Delete

18 How to Delete one character to left

a. Ctrl + Delete

b. Alt + Delete

c. Shift + Delete

d. Backspace

19 How to Edit active cell

a. F4

b. F1

c. F2

d. F3

20 How to Cancel cell entry

a. Alt + C

b. Escape Key

c. Ctrl + C

d. Delete

21 How to Select entire worksheet

a. Ctrl + A

b. Alt + A

c. Alt + Ctrl + A

d. Ctrl + Shift + A

22 How to Select entire row

a. Shift + Spacebar

b. Ctrl + R

c. Alt + R

d. Ctrl + Shift + R

23 How to Select entire column

a. Ctrl + C

b. Ctrl + Spacebar

c. Alt + C

d. Ctrl + Shift + C

24 How to Cut

a. Ctrl + C

b. Alt + C

c. Alt + Ctrl + C

d. Ctrl + X

25 How to Copy

a. Ctrl + C

b. Alt + C

c. Alt + Ctrl + C

d. Ctrl + X

26 How to Paste

a. Ctrl + P

b. Alt + P

c. Alt + Ctrl + P

d. Ctrl + V

27 How to Autosum a range of cells

a. Ctrl + Equals Sign

b. Alt + Equals Sign

c. Ctrl + Alt + Equals Sign

d. Equals Sign

28 How to Insert the date

a. Ctrl + ;

b. Ctrl + D

c. Alt + D

d. Ctrl + Alt + D

29 How to Insert the time

a. Ctrl + Shift + T

b. Ctrl + Shift + ;

c. Ctrl + T

d. Ctrl + Alt + T

30 How to Insert columns/rows

a. Ctrl + Shift + -

b. Ctrl + Shift + N

c. Ctrl + Shift + +

d. Ctrl + Shift + R

31 How to Insert a new worksheet

a. Shift + F9

b. Shift + F10

c. Shift + F11

d. Shift + F12

32 How to Find text

a. Ctrl + Shift + F

b. Ctrl + Shift + F

c. Alt + F

d. Ctrl + F

33 How to Replace text dialog

a. Ctrl + Shift + R

b. Ctrl + Shift + R

c. Ctrl + H

d. Ctrl + R

34 How to Create a chart automatically on new sheet

a. F10

b. F11

c. F12

d. F13

35 How to Edit a cell comment

a. Shift + F5

b. Shift + F1

c. Shift + F2

d. Shift + F3

1 How to Bold toggle for selection

2 How to Italic toggle for selection

3 How to Underline toggle for selection

4 How to Strikethrough for selection

5 How to Change the font

6 How to Change the font size

7 How to Apply outline borders

8 How to Remove all borders

9 How to Wrap text in same cell

10 How to Format cells

11 How to Select font

12 How to Select point size

13 How to Format as currency

14 How to Format as general (to remove any formatting)

15 How to Format as percentage

16 How to Format as number

17 How to Delete one character to right

18 How to Delete one character to left

19 How to Edit active cell

20 How to Cancel cell entry

21 How to Select entire worksheet

22 How to Select entire row

23 How to Select entire column

24 How to Cut

25 How to Copy

26 How to Paste

27 How to Autosum a range of cells

28 How to Insert the date

29 How to Insert the time

30 How to Insert columns/rows

31 How to Insert a new worksheet

32 How to Find text

33 How to Replace text dialog

34 How to Create a chart automatically on new sheet

35 How to Edit a cell comment

tags