Keyboard Shortcuts Flashcards by Amrapali dixit

Q

F2

A

Enter into a cell

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

F4

A

Repeats last command(or Anchor if within a cell)

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

ESC

A

Exit a cell without making any changes

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Enter

A

Moves down a cell

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Tab

A

Moves right a cell

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Ctrl+Z

A

Undo

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Alt+E+S

A

Paste special

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Ctrl+D

A

Fill down

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Ctrl +R

A

Fill Right

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Ctrl(Up,down,left or right)

A

Moves to first/last non-empty cell in range

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Shift+Ctrl (Up, down, left or right)

A

Highlights up until last non-empty cell in range

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Ctrl+Home

A

Moves to cell A1 ( Unless another home cell has been defined)

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Ctrl+Page up/down

A

Moves between worksheets within workbook

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Alt+Down

A

Opens a drop down list

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Ctrl+Tab

A

Flips between open files of the same program

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Ctrl +End

A

Go to the end of the worksheet

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Ctrl + Tab

A

Flip between Excel Workbooks

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Shift + Down

A

Highlight the cell below

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Shift + Ctrl + Down

A

Highlight everything until the end

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Ctrl + A

A

Select a contiguous area

Q

Shift + Spacebar

A

Select an entire ROW

Q

Ctrl + Spacebar

A

Select an entire COLUMN

Q

Ctrl+1

A

Format cells

Q

Alt + O + E

A

Format cells

Shift + Ctrl+ Exclamation

Gives the decimal in a number

Shift + Ctrl + @

Time

Shift + Ctrl + #

Date in DD/Month/YY

Shift + Ctrl + $

Dollar sign

Shift + Ctrl + %

Percentage sign

Ctrl + c/x

Copy or cut

Ctrl + V

PAste to selected cells or range

Alt + E + S + T

Paste the format

Alt + E + S + V

Paste the values

Alt + E + S + F

Paste the formulas

Alt + E + S + N

Paste data validation

Alt + E + S + M + F

Multiply a range

Ctrl + D

Fill down

Ctrl + R

Fill right

Shift + Down

Highlight in direction of arrow

Shift + Ctrl + Down

Highlight everything until the end

Shift, Ctrl, +

Will insert highlighted cells or rows

Ctrl, -

Will delete highlighted cells or rows

Alt + E + A + F

Clear all formats

Alt + E + A + A

Clear all numbers and formats

Alt + H + E

Clear

Alt + H + F + S

Change Font size

Alt + H + O + R

Rename Sheet

Shift + Ctrl + -

Remove all borders