Faster way to work in Workbooks

Start practicing Shortcut keys and make your life simpler than ever. These Excel and Mac shortcut keys can do wonders when it comes to working with excel workbooks. Please comment below if we have missed any shortcut from here

200+ Excel Shortcut Keys

Working with Files

SHORTCUT

Windows

MAC

Creating a new workbook

Open workbook

Save workbook

Save as

Print file

Close current workbook

Close Excel

Open print preview window

Excel Shortcut Keys For - RIBBON

SHORTCUT

Windows

MAC

Expand or collapse ribbon

Activate access keys

Move to next ribbon control

Activate or open selected control

Confirm control change

Get help on selected control

Excel Shortcut Keys For - GENERAL

SHORTCUT

Windows

MAC

Open options

Undo last action

Copy selected cells

Repeat last action

Cut selected cells

Paste content from clipboard

Display the Paste Special dialog box

Display find and replace

Display find and replace, replace selected

Find next match

Find previous match

Create embedded chart

Create chart in new worksheet

Excel Shortcut Keys For - TABLES AND FILTERS

SHORTCUT

Windows

MAC

Insert table

Toggle Autofilter

Activate filter

Select table row

Select table column

Select table

Clear slicer filter

Toggle table total row

Excel Shortcut Keys For - DRAG AND COPY

SHORTCUT

Windows

MAC

Drag and cut

Drag and copy

Drag and insert

Drag and insert copy

Excel Shortcut Keys For - NAVIGATION

SHORTCUT

Windows

MAC

Move one cell right

Move one cell left

Move one cell up

Move one cell down

Move one screen right

Move one screen left

Move one screen up

Move one screen down

Move to right edge of data region

Move to left edge of data region

Move to top edge of data region

Move to bottom edge of data region

Move to beginning of row

Move to last cell in worksheet

Turn End mode on

Go back to hyperlink

Excel Shortcut Keys For - SELECTION

SHORTCUT

Windows

MAC

Select entire row

Select entire column

Select entire worksheet

Add adjacent cells to selection

Same selection in next column

Same selection in previous column

Move right between non-adjacent selections

Move left between non-adjacent selections

Toggle add to selection mode

Cancel selection

Excel Shortcut Keys For - FORMATTING

SHORTCUT

Windows

MAC

Format cells

Display Format Cells with Font tab selected

Apply or remove bold

Apply or remove italics

Apply or remove underscore

Apply or remove strikethrough

Align center

Align left

Align right

Indent

Remove indent

Wrap text

Align top

Align middle

Align bottom

Increase font size one step

Decrease font size one step

Excel Shortcut Keys For - NUMBER FORMATTING

SHORTCUT

Windows

MAC

Apply general format

Apply number format

Apply time format

Apply date format

Apply currency format

Apply percentage format

Apply scientific format

Excel Shortcut Keys For - BORDERS

SHORTCUT

Windows

MAC

Open list of border styles from Ribbon

Add border around selected cells

Add or remove right border

Add or remove left border

Add or remove top border

Add or remove bottom border

Add all borders to all cells in selection

Remove borders

Excel Shortcut Keys For - FORMULAS

SHORTCUT

Windows

MAC

Begin entering a formula

Toggle absolute and relative references (in cell edit mode)

Open the Insert Function Dialog Box

Autosum

Toggle displaying formulas on and off

Insert function arguments

Enter array formula

Calculate worksheets

Calculate active worksheet

Force calculate all worksheets

Evaluate part of a formula (in cell edit mode)

Expand or collapse the formula bar

Display function arguments dialog box

Open Name Manager

Create name from values in row(s)/column(s)

Paste name into formula

Accept function with auto-complete

Excel Shortcut Keys For - GRID OPERATIONS

SHORTCUT

Windows

MAC

Display Insert Dialog box

Insert selected number of rows

Insert selected number of columns

Display Delete dialog box

Delete selected number of rows

Delete selected number of columns

Delete contents of selected cells

Hide columns

Hide rows

Unhide rows

Group rows or columns (with rows/columns selected)

Ungroup rows or columns (with rows/columns selected)

Hide or show outline symbols

Excel Shortcut Keys For - PIVOT TABLES

SHORTCUT

Windows

MAC

Create pivot table

Select entire pivot table

Group pivot table items

Ungroup pivot table items

Hide (filter out) pivot table item

Unhide (clear filter on) pivot table item

Insert pivot chart

Learn Excel in Easy Way and Make Your Data Meaningful.