Scribd
Upload
74 views1 page

Excel Mac Shortcuts

Uploaded by

sukriti

This document provides an overview of keyboard shortcuts for navigating and performing common tasks in Excel for Mac. It includes shortcuts for general navigation within Excel and between workbooks, selecting and editing cells, formatting text, inserting formulas and comments, navigating dialog boxes, and more. Many common Windows shortcuts have equivalent Mac shortcuts using the Command (⌘) key instead of Control.

Copyright:

© All Rights Reserved
Download as PDF, TXT or read online from Scribd
Download as pdf or txt

Excel Mac Shortcuts

Uploaded by

sukriti
74 views1 page
This document provides an overview of keyboard shortcuts for navigating and performing common tasks in Excel for Mac. It includes shortcuts for general navigation within Excel and between workbooks, selecting and editing cells, formatting text, inserting formulas and comments, navigating dialog boxes, and more. Many common Windows shortcuts have equivalent Mac shortcuts using the Command (⌘) key instead of Control.

Original Description:

Some quick short cuts that can improve excel speed.

Copyright

© © All Rights Reserved

Available Formats

PDF, TXT or read online from Scribd

Did you find this document useful?

Is this content inappropriate?

This document provides an overview of keyboard shortcuts for navigating and performing common tasks in Excel for Mac. It includes shortcuts for general navigation within Excel and between workbooks, selecting and editing cells, formatting text, inserting formulas and comments, navigating dialog boxes, and more. Many common Windows shortcuts have equivalent Mac shortcuts using the Command (⌘) key instead of Control.

Copyright:

© All Rights Reserved
Download as PDF, TXT or read online from Scribd
Download as pdf or txt
74 views1 page

Excel Mac Shortcuts

Uploaded by

sukriti
This document provides an overview of keyboard shortcuts for navigating and performing common tasks in Excel for Mac. It includes shortcuts for general navigation within Excel and between workbooks, selecting and editing cells, formatting text, inserting formulas and comments, navigating dialog boxes, and more. Many common Windows shortcuts have equivalent Mac shortcuts using the Command (⌘) key instead of Control.

Copyright:

© All Rights Reserved
Download as PDF, TXT or read online from Scribd
Download as pdf or txt
You are on page 1/ 1

www.wallstreetprep.

com

Excel for Mac Reference Sheet


General Excel navigation

Using Toolbars

Activate menu bar (ALT in PC)

CTRL + F2 (see WSP Mac Setup)

Make a toolbar active

ALT + F10

Page Up / Page Down

CTRL FN + UP / DOWN

Moving to left / right in toolbar

TAB / SHIFT + TAB

Moving to left/right tabs

CTRL + PAGEUP/DOWN

Select the next / previous toolbar CTRL + TAB / CTRL + SHIFT + TAB

Excel Options

+,

Perform the desired action

Edit cells (F2 in PC)

CTRL+U

Formatting shortcuts

RETURN

Row / column shortcuts


Select column

CTRL + Space (see WSP Mac Setup)

+B
Italic
+I
Underline
+U
Format Box
+1
Outline border
+ALT+ZERO
Left, right, top, and bottom border +ALT+ARROW KEYS
Remove border
+ALT+HYPHEN

Select row

Shift + Space

Delete row(s) / column(s)

CTRL + minus sign

Add row(s) / column(s)

CTRL + i

Group / ungroup rows & columns

+ Shift + K / J

Select All

+A

Insert / delete a comment

SHIFT + F2 / SHIFT + F2 + DELETE

Fill Down

CTRL+D

Copy

+C
+V

Fill right

CTRL+R

Bold

Paste
Paste Special formats
Paste Special formulas
Cut
Repeat
Undo
Delete selected cells

CTRL + + V, + T (Excel 2011 only)

CTRL + + V, + F (Excel 2011 only)

+X
+Y
+Z
+ Minus sign

Workbook navigation shortcuts

Data editing shortcuts

Find CTRL+F
Replace CTRL+H
Start a formula

= (equal sign)

Insert AutoSum formula

+ SHIFT + T

Data editing shortcuts when inside cell


Start new line in same cell

CTRL+ALT+RETURN

Highlight within cells

SHIFT + Arrow keys

Highlight contiguous items

SHIFT + CTRL + Arrow keys

Toggle Excel workbooks

CTRL + TAB

Delete preceding character

DELETE

New workbook

+N
+P
+O
+S
+W

Delete character to the right

FN + DELETE

Anchor Fix Cells

+T

Cancel a cell entry

ESC

Print
Open workbook
Save workbook
Close window

Other useful shortcuts

Auditing shortcuts
Go to precedent cells

CTRL + [

Go to dependent cells

CTRL + ]

Recalculate all workbooks

SHIFT F9

Go back to original cell

F5, ENTER

Display a drop-down list

ALT + up/down arrow keys

Go to

F5

Display Insert Function box

SHIFT F3

Display Name box

CTRL+L

General Windows Shortcuts (Mac)


Universal applications shortcuts

Cell navigation shortcuts

Switching between applications

+TAB

Show the desktop / restore view

SHIFT F11

Go to end of contiguous range

CTRL + Arrow keys (see WSP Mac Setup)

Select a cell range

SHIFT + Arrow keys

Highlight contiguous range

SHIFT + CTRL + Arrow keys

Office forms (dialog boxes) navigation

Move to beginning of line

HOME

To go from tab to tab

CTRL+TAB

Delete cell/selection

Fn + Delete

Move in a list

Up and down arrow keys

Show formulas/values

CTRL + ~

To move to the next form field clockwise

Fill selection w/ entry

CTRL+RETURN

To move counter clockwise

Shift tab

Select OK

Enter

Select Cancel

Esc

Tab

Note: Some third-party utilities, macros and add-ins can overwrite native shortcut keys

You might also like