As we know that ms-excel features calculation, pivot tables, etc. if you are working with excel daily activity then you might know MS Excel shortcuts, incomes with ms-excel it is best to know shortcut keys which will boost your productivity and information can fill quickly in a short period. Knowing the shortcut can help you to save your time and create a fast and easier excel sheet etc.
If you are a beginner
then it is the best time to start up with shortcuts keys. below we have listed
out shortcut keys of ms-excel. There may be some different keys for windows and
macOS because of the keyboard configuration.
There are above more
than 45+ ms-excel shortcuts for windows and macOS following are shown below.
Symbols to identify: These are Command (or Cmd) ⌘,
Shift ⇧,
Option (or Alt) ⌥, Control (or Ctrl) ⌃, and Fn.
Shortcuts Keys
|
Shortcuts |
Windows |
Mac |
|
To Create new workbook |
Ctrl + N |
⌘ + N |
|
To Apply number format |
Ctrl + Shift + ! |
⌃ + ⇧ + ! |
|
To Remove indent |
Alt + H + 5 |
⌃ + ⌥ + ⇧ + Tab |
|
To Open workbook |
Ctrl + O |
⌘ + O |
|
To Save workbook |
Ctrl + S |
⌘ + S |
|
To Save as |
F12 |
⌘ + ⇧ + S |
|
To Print file |
Ctrl + P |
⌘ + P |
|
To Open print preview window |
Ctrl + F2 |
|
|
To Close current workbook |
Ctrl + W |
⌘ + W |
|
To Close Excel |
Alt + F4 |
⌘ + Q |
|
To Open options |
Alt + F + T |
⌘ + , |
|
To Open help |
F1 |
⌘ + / |
|
To Undo last action |
Ctrl + Z |
⌘ + Z |
|
To Redo last action |
Ctrl + Y |
⌘ + Y |
|
To Copy selected cells |
Ctrl + C |
⌘ + C |
|
To Repeat last action |
F4 |
⌘ + Y |
|
To Cut selected cells |
Ctrl + X |
⌘ + X |
|
To Paste content from clipboard |
Ctrl + V |
⌘ + V |
|
To Display the Paste Special dialog box |
Ctrl + Alt + V |
⌘ + ⌃ + V |
|
To Display find and replace |
Ctrl + F |
⌘ + F |
|
To Display find and replace and replace selected |
Ctrl + H |
⌃ + H |
|
To Find next match |
Shift + F4 |
⌘ + G |
|
To Find previous match |
Ctrl + Shift + F4 |
⌘ + ⇧ + G |
|
To Create embedded chart |
Alt + F1 |
Fn + ⌥ + F1 |
|
To Create chart in new worksheet |
F11 |
Fn + F11 |
|
To Drag and cut |
drag |
drag |
|
To Go to the next workbook |
Ctrl + Tab |
⌃ + Tab |
|
To Drag and copy |
Ctrl + drag |
⌥ + drag |
|
To Go to the previous workbook |
Ctrl + Shift + Tab |
⌃ + ⇧ + Tab |
|
To Zoom in |
Ctrl + Alt + + |
⌥ + ⌘ + + |
|
To Toggle table total row |
Ctrl + Shift + T |
⌘ + ⇧ + T |
|
To Move one screen right |
Alt + Pg + Dn |
Fn + ⌥ + ↓ |
|
To Hide or show outline symbols |
Ctrl + 8 |
⌃ + 8 |
|
To Move one screen left |
Alt + Pg + Up |
Fn + ⌥ + ↑ |
|
To Zoom out |
Ctrl + Alt + – |
⌥ +⌘ + – |
|
To Minimize the current workbook window |
Ctrl + F9 |
⌘ + M |
|
To Move one screen up |
Pg + Up |
Fn + ↑ |
|
To Apply general format |
Ctrl + Shift + ~ |
⌃ + ⇧ + ~ |
|
To Align left |
Alt + H + A + L |
⌘ + L |
|
To Drag and insert |
Shift + drag |
⇧ + drag |
|
To Decrease font size one step |
Alt + H + FK |
⌘ + ⇧ + < |
|
To Maximize the current workbook window |
Ctrl + F10 |
fn + ⌃ + F10 |
|
To Move one screen down |
Pg + Dn |
Fn + ↓ |
|
To Apply percentage format |
Ctrl + Shift + % |
⌃ + ⇧ + % |
|
To Move to right edge of data region |
Ctrl + → |
⌃ + → |
|
To Apply currency format |
Ctrl + Shift + $ |
⌃ + ⇧ + $ |
|
To Align right |
Alt + H + A + R |
⌘ + R |
|
To Drag and insert copy |
Ctrl + Shift + drag |
⌥ + ⇧ + drag |
|
To Move to the previous tab |
Ctrl + Shift + Tab |
⌃ + ⇧ + Tab |
|
To Insert rows |
Ctrl + Shift + + |
⌘ + ⇧ + + |
|
To Move to the next tab |
Ctrl + Tab |
⌃ + Tab |
|
To Apply scientific format |
Ctrl + Shift + ^ |
⌃ + ⇧ + ^ |
|
To Insert columns |
Ctrl + Shift + + |
⌘ + ⇧ + + |
|
To Drag to worksheet |
Alt + drag |
⌘ + drag |
|
To Increase font size one step |
Alt + H + FG |
⌘ + ⇧ + > |
|
To Move to the top edge of the data region |
Ctrl + ↑ |
⌃ + ↑ |
|
To Toggle full screen |
Ctrl + Shift + F1 |
⌃ + ⌘ + F |
|
To Add Indent |
Alt + H + 6 |
⌃ + ⌥ + Tab |
|
To Move to the left edge of the data region |
Ctrl + ← |
⌃ + ← |
|
To Insert a new worksheet |
Shift + F11 |
fn + ⇧ + F11 |
|
To Move to the bottom edge of the data region |
Ctr + l↓ |
⌃ + ↓ |
|
To Drag to duplicate worksheet |
Ctrl + drag |
⌥ + drag |
|
To Apply date format |
Ctrl + Shift + # |
⌃ + ⇧ + # |
|
To Apply time format |
Ctrl + Shift + @ |
⌃ + ⇧ + @ |
|
To Move to the beginning of the row |
Home |
Fn + ← |
|
To Ungroup rows or columns |
Alt + Shift + ← |
⌘ + ⇧ + J |
|
To Insert table |
Ctrl + T |
⌃ + T |
|
To Group rows or columns |
Alt + Shift + → |
⌘ + ⇧ + K |
|
To Go to the next worksheet |
Ctrl + Pg + Dn |
Fn + ⌃ + ↓ |
|
To Unhide columns |
Ctrl + Shift + 0 |
⌃ + ⇧ + 0 |
|
To Toggle Autofilter |
Ctrl + Shift + L |
⌘ + ⇧ + F |
|
To Hide columns |
Ctrl + 0 |
⌃ + 0 |
|
To Go to the previous worksheet |
Ctrl + Pg + Up |
Fn + ⌃ + ↑ |
|
To Unhide rows |
Ctrl + Shift + 9 |
⌃ + ⇧ + 9 |
|
To Move to last cell in the worksheet |
Ctrl + End |
Fn + ⌃ + → |
|
To Hide rows |
Ctrl + 9 |
⌃ + 9 |
|
To Activate filter |
Alt + ↓ |
⌥ + ↓ |
|
To Delete columns |
Ctrl + – |
⌘ + – |
|
To Move to the first cell in worksheet |
Ctrl + Home |
Fn + ⌃ + ← |
|
To Delete rows |
Ctrl + – |
⌘ + – |
|
To Select table row |
Shift + Space |
⇧ + Space |
|
To Select the table column |
Ctrl + Space |
⌃ + Space |
|
To Display Delete dialog box |
Ctrl + – |
⌘ + – |
|
To Select table |
Ctrl + A |
⌘ + A |
|
To Move to the next pane |
F6 |
Fn + F6 |
|
To Move to the previous pane |
Shift + F6 |
Fn + ⇧ + F6 |
|
To Clear slicer filter |
Alt + C |
⌥ + C |
|
To Go back to hyperlink |
Ctrl + G + Enter |
⌃ + G + Return |
0 Comments