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

Q

Shift + Ctrl+ Exclamation

A

Gives the decimal in a number

Q

Shift + Ctrl + @

A

Time

Q

Shift + Ctrl + #

A

Date in DD/Month/YY

Q

Shift + Ctrl + $

A

Dollar sign

Q

Shift + Ctrl + %

A

Percentage sign

Q

Ctrl + c/x

A

Copy or cut

Q

Ctrl + V

A

PAste to selected cells or range

Q

Alt + E + S + T

A

Paste the format

Q

Alt + E + S + V

A

Paste the values

Q

Alt + E + S + F

A

Paste the formulas

Q

Alt + E + S + N

A

Paste data validation

Q

Alt + E + S + M + F

A

Multiply a range

Q

Ctrl + D

A

Fill down

Q

Ctrl + R

A

Fill right

Q

Shift + Down

A

Highlight in direction of arrow

Q

Shift + Ctrl + Down

A

Highlight everything until the end

Q

Shift, Ctrl, +

A

Will insert highlighted cells or rows

Q

Ctrl, -

A

Will delete highlighted cells or rows

Q

Alt + E + A + F

A

Clear all formats

Q

Alt + E + A + A

A

Clear all numbers and formats

Q

Alt + H + E

A

Clear

Q

Alt + H + F + S

A

Change Font size

Q

Alt + H + O + R

A

Rename Sheet

Q

Shift + Ctrl + -

A

Remove all borders