Important Excel Shortcuts (Macabacus)

Ace your homework & exams now with Quizwiz!

AutoSum

Alt + =

Paste formulas

Alt E S F

Paste formats

Alt E S T

Paste values

Alt E S V

Print Preview

Alt F V

Name Manager...

Alt I N D

Insert row/column

Alt I R / Alt I C

Tools > Options...

Alt T O

Trace precedents/dependents

Alt T U T / Alt T U D

Zoom...

Alt V Z

Format cells...

Ctrl + 1 (or Alt O E)

Go to end of contiguous range

Ctrl + Arrow Keys

Format bold/underline/italic

Ctrl + B / Ctrl + U / Ctrl + I

Copy/cut

Ctrl + C / Ctrl + X

Go home (cell A1)

Ctrl + Home

Print

Ctrl + P

Worksheet next/previous

Ctrl + PgUp / Ctrl + PgDn

Fill right/down

Ctrl + R / Ctrl + D

Border around selection

Ctrl + Shift + 7

Select contiguous range

Ctrl + Shift + Arrow Keys

Enter formula array

Ctrl + Shift + Enter

Borders remove (all)

Ctrl + Shift + _

Workbook toggle

Ctrl + Tab

Paste

Ctrl + V

Workbook close/new/open

Ctrl + W / Ctrl + N / Ctrl + O

Undo/redo/repeat

Ctrl + Z / Ctrl + Y / F4

Go to precedent cells

Ctrl + [

Save as

F12

Edit cell

F2

Anchor cells

F4

Go To...

F5 (or Ctrl + G)

Recalculate all

F9

Select a range

Shift + Arrow Keys

Insert worksheet

Shift + F11 (or Alt I W)

Comment insert/edit

Shift + F2

Select entire row/column

Shift / Ctrl + Spacebar


Related study sets

MKT 205-010 Principles of Marketing Final Exam Part 1

View Set

Online Personal Finance Final Review (in progress)

View Set