Microsoft Excel

Microsoft Excel Keyboard Shortcuts

Microsoft Excel is a versatile tool for data analysis and spreadsheet management, used extensively in finance, education, and business. From complex calculations to data visualization, Excel's functionalities are unmatched. Keyboard shortcuts in Excel improve efficiency, enabling swift data entry, formula application, and table formatting for users at all skill levels.

Open a workbook

⌘ + O

Create new workbook

⌘ + N

Save workbook

⌘ + S

Print workbook

⌘ + P

Find text

⌘ + F

Replace text

⌘ + H

Undo

⌘ + Z

Redo

⌘ + Y

Go to cell

⌘ + G

Navigate to edge of data region

⌘ + Arrow keys

Selection and Editing

Select all data

⌘ + A

Copy

⌘ + C

Cut

⌘ + X

Paste

⌘ + V

Bold

⌘ + B

Italic

⌘ + I

Underline

⌘ + U

Align left

⌘ + L

Align center

⌘ + E

Align right

⌘ + R

Formatting

Format cells

⌘ + 1

Apply filter

⌘ + Shift + L

Apply outline border

⌘ + Shift + &

Remove outline border

⌘ + Shift + _

Resize column to fit

Alt + H + H

Set print area

Alt + O + C + A

Create name from values

⌘ + Shift + F3

Formula and Functions

AutoSum

= =

Insert AutoSum formula

Alt + =

Insert function

Shift + F3

Insert function arguments

⌘ + Shift + A

View and Window Management

Switch to next workbook window

⌘ + Tab

Switch to next workbook window (alternative)

⌘ + F6

Close workbook

⌘ + F4

Close Excel

⌘ + W

Quickly close Excel

⌘ + Shift + Q

Create new chart on a separate sheet

F11

Miscellaneous

Insert hyperlink

⌘ + K

Apply bold formatting

⌘ + 2

Apply italic formatting

⌘ + 3

Apply underline formatting

⌘ + 4

Microsoft Excel

Additional information not available for this software.

Supported Platforms: