All the Useful Microsoft Excel Keyboard Shortcuts

code-adda Microsoft excel shortcuts
All the useful Microsoft excel shortcuts

There are many keyword shortcuts available for Microsoft Excel. Here we’ve tried to gather all the useful keywords and managed to display category wise, so you can find as per your interest. And, Don’t worry! almost all of mentioned excel shortcuts have been around for a long time, so they should be helpful no matter what version of Excel you’re using right now for your work.

Note:
By using Search option available at every excel shortcuts table, You can easily search particular shortcuts.

All the shortcuts are mentioned here for both Window and Mac.

Microsoft Excel – File Shortcuts

Here are a few shortcuts that can help you to perform your excel sheet related work that you can find easily in file menu.

S.NOACTIONWINDOWS SHORTCUT MAC SHORTCUT
1 New

Ctrl

N




N


2 Open

Ctrl

O




O


3 Save workbook

Ctrl

S





4 Save As

F12





Shift

S


5 Print

Ctrl

P




P


6 Open print preview window

Ctrl

F2





7 Go to next workbook

Ctrl

Tab




-


8 Close file

Ctrl

F4




W


9 Close all open Excel files

Alt

F4




Q


Microsoft Excel – Navigation Shortcuts

Here are a few shortcuts that to help you easily navigate between cells.

S.NOACTIONWINDOWS SHORTCUT MAC SHORTCUT
1 Move from cell to cell

Arrows



Arrows


2 Go to

F5



F5


3 Go to cell A1

Ctrl

Home



Fn

Ctrl

Left


4 Go to beginning of row

Home



Fn

Left


5 Select the adjacent cell

Shift

Arrow



Shift

Arrow


6 Select entire row

Shift

Spacebar



Shift

Spacebar


7 Select entire column

Ctrl

Spacebar



Ctrl

Spacebar


8 Select all to the start of the sheet

Ctrl

Shift

Home



Ctrl

Shift

Home


9 Select all to the last used cell of the sheet

Ctrl

Shift

End



Ctrl

Shift

End


10 Select to the end of the last used cell in row/column

Ctrl

Shift

Arrow



Ctrl

Shift

Arrow


11 Select the last used cell in row/column

Ctrl

Arrow



Ctrl

Arrow


12 Move one screen up

PageUp



Fn

Up


13 Move one screen down

PageDown



Fn

Down


14 Move one screen left

Alt

PageUp



Fn

Option

Up


15 Move one screen right

Alt

PageDown



Fn

Option

Down


16 Move to the next or previous worksheet (Move between tabs if you are
in a menu window)

Ctrl

PageUp/Down



Ctrl

PageUp/Down


17 Move to next workbook (while in spreadsheet) Move to next divider
(when in menu options)

Ctrl

Tab



Ctrl

Tab


18 Move to the next cell (Move between items within a menu window)

Tab



Tab


Microsoft Excel – Formatting Shortcuts

Here are a few shortcuts that can help you easily format your cells.

S.NOACTIONWINDOWS SHORTCUT MAC SHORTCUT
1 Brings up format cells menu

Ctrl

1




1


2 Bold

Ctrl

B




B


6 Repeat last action

F4




Y


3 Italic

Ctrl

I




I


4 Undo

Ctrl

Z




Z


5 Redo

Ctrl

Y




Y


7 Select all used cells (select entire worksheet if command is repeated)

Ctrl

A




A


8 Number format

Ctrl

Shift

!



Ctrl

Shift

!


10 Percent format

Ctrl

Shift

%



Ctrl

Shift

%


9 Date format

Ctrl

Shift

#



Ctrl

Shift

#


11 Increase font size

Alt

h

fg




Shift

>


12 Decrease font size

Alt

h

fk




Shift

<


13 Increase decimal

Alt

h

O





14 Decrease decimal

Alt

h

9





15 Increase indent

Alt

h

6



Ctrl

M


16 Decrease indent

Alt

h

5




Shift

m


Microsoft Excel – Select Shortcuts

Here are a few shortcuts that can help you easily select cells.

S.NOACTIONWINDOWS SHORTCUT MAC SHORTCUT
1 Select a cell range

Shift

Arrows



Shift

Arrows

2 Highlight a contiguous range

Ctrl

Shift

Arrows


Ctrl

Shift

Arrows

3 Extend selection up one screen

Shift

PageUp


Fn

Shift

Up

4 Extend selection down one screen

Shift

PageDown


Fn

Shift

Down

5 Extend selection left one screen

Alt

shift

PageUp


Fn

Shift


Up

6 Extend selection right one screen

Alt

shift

PageDown


Fn

Shift


Down

7 Select all

Ctrl

A



A

Microsoft Excel – Paste Shortcuts

Here are a few shortcuts that can help you easily paste data in cells.

S.NoACTIONWINDOWS SHORTCUT MAC SHORTCUT
1 Paste Special formats

Ctrl

Alt

V

t



Ctrl


V

t


2 Paste Special values

Ctrl

Alt

V

v



Ctrl


V

v


3 Paste Special formulas

Ctrl

Alt

V

f



Ctrl


V

f


4 Paste Special comments

Ctrl

Alt

V

c



Ctrl


V

c


Microsoft Excel – Data Editing Shortcuts

Here are a few shortcuts that can help you to easily edit cells with data.

S.NOACTIONWINDOWS SHORTCUT MAC SHORTCUT
1 Edit the active cell (edit mode)

F2



F2


5 Insert line break within cell

Alt

Enter



Option

Enter


2 While editing cell, allow use of arrow keys to create reference

F2



F2


3 Confirm change and get out of cell

Enter



Enter


4 Cancel a cell entry and get out of cell

Esc



Esc


10 Delete character to left

Backspace



Delete


7 Highlight contiguous items

Ctrl

Shift

Left/Right



Ctrl

Shift

Left/Right


6 Highlight within a cell

Shift

Left/Right



Shift

Left/Right


8 Jump to beginning of cell contents

Home



Fn

Left


12 Accept autocomplete suggestion

Tab



Tab


9 Jump to end of cell contents

End



Fn

Right


11 Delete character to right

Delete



Fn

Delete


13 Referencing a cell from another worksheet

Ctrl

PageUp/Down

Arrows



Ctrl

Fn

Down/Up

Arrows


It’s not easy to memorize all the excel shortcuts at once but it can be easy if you use keyboard shortcuts frequently. The more you work with shortcuts the easier they are to remember.

If you think, If we have missed any shortcuts to mention here. we would like to request you please let us know in comment box so we can update the excel shortcuts list that can be quite useful for others.

If you find this blog useful. Please share with your dear one. This can be useful for others.

About Ravi Ranjan Kumar 32 Articles
An Indian who Living, Loving & Learning Technology with different tastes and willing to share knowledge and thoughts.

Be the first to comment

Leave a Reply