MS Excel Shortcut Keys for Beginners (2019)

Hey Everyone, Today is something for MS office user. As you know Excel is one of best program for creating awesome spreadsheets, collecting and analyzing data in a manner.

If you are creating spreadsheet, data tables, charts without knowing the Shortcut Keys of it, then Dude, You are wasting 20% of your time. Today in this article, you are gonna learn about MS Excel Keys which can you help in speeding up your spreadsheet, data analysis work.

I will be telling you which key does what? MS Excel Shortcut Keys along their functions.

MS Excel Shortcut Keys for Beginners

MS-Excel-Shortcut-Keys

Before getting start, lets know windows and Mac may have different keys from each other. But no problem, I will be mentioning keys for both.

Working with files : MS Excel Keyboard Shortcuts

Why are using hovering your mouse all the time on screen while you can do half of work using the keys to work with files in MS Excel such as opening a file, saving, printing, closing Excel etc. Check out the keys below

Windows KeysMac KeysFunctions
Ctrl + N⌘ + NNew File
Ctrl + O⌘ + OOpen File
Ctrl + S⌘ + SSave
Ctrl + Shift + S⌘ + Shift + SSave as
Ctrl + P⌘ + PPrint
Ctrl + F2⌘ + P
Print Preview
Ctrl + W⌘ + WClose Workbook
Ctrl + Q⌘ + QClose Excel

Working with Data : Excel Shortcut Formulas

With these Shortcut Formulas you can speed up the work like copy, pasting, Undo, Redo, Find, etc. Check out these MS Excel shortcut for Mac and Windows.

Windows KeysMac KeysFunctions
Ctrl + C⌘ + CCopy
Ctrl + X⌘ + XCut
Ctrl + V⌘ + VPaste
Ctrl + Alt + VControl + ⌘ + VPaste special
Ctrl + Z⌘ + ZUndo
Ctrl + Y⌘ + Y
Redo
Ctrl + F⌘ + FFind
Ctrl + Shift + F4⌘ + Shift + GFind previous
Ctrl + F4⌘ + GFind next
Ctrl + HControl + HFind and replace

Moving within workbook

Here using these formula, you will be able to move within workbook like moving righ, left, up, down etc.

Windows KeysMac KeysFunctions
Move right
Move left
Move up
Move down
Ctrl + →Control + →Move right to next full cell
Ctrl + ←Control + ←Move left to next full cell
Ctrl + ↑Control + ↑Move up to next full cell
Ctrl + ↓Control + ↓Move down to next full cell
HomeFn + ←Move to beginning of row
Ctrl + EndFn + Control + →Move to last cell
Ctrl + HomeFn + Control + ←Move to first cell
Alt + PgDnFn + Option + ↑Scroll right one screen
Alt + PgUpFn + Option + ↓Scroll left one screen
PgUpFn + ↑Scroll up one screen
PgDnFn + ↓Scroll down one screen
EndFn + →End mode

Selecting Cells : MS Excel Shortcut Keys pc

Windows KeysMac KeysFunctions
Ctrl + GControl + GGo to cell
Ctrl + A⌘ + ASelect all
Shift + SpaceShift + SpaceSelect row
Ctrl + SpaceControl + SpaceSelect column
Ctrl + Shift + *Shift + Control + SpaceSelect current region
Ctrl + /Control + /Select current array
Ctrl + Shift + {Control + Shift + {Select all precedents
Ctrl + ]Control + ]Select direct dependents
Ctrl + Shift + }Control + Shift + }Select all dependents
Alt + ;⌘ + Shift + ZSelect only visible cells
Shift + ClickShift + ClickAdd cell range to selection
Ctrl + Click⌘ + ClickAdd one-off cells to selection
Ctrl + Alt + →Control + Option + →Move active cell right to non-adjacent selection
Ctrl + Alt + ←Control + Option + ←Move active cell left to non-adjacent selection
Option + TabMove selection one column left
Option + Shift + TabMove selection one column right
Shift + F8Fn + Shift + F8Toggle selection add mode
EscEscClear selection
Shift + →Shift + →Expand selection to the right
Shift + ←Shift + ←Expand selection to the left
Shift + ↑Shift + ↑Expand selection up
Shift + ↓Shift + ↓Expand selection down
Ctrl + Shift + →⌘ + Shift + →Expand selection to last full cell to the right
Ctrl + Shift + ←⌘ + Shift + ←Expand selection to last full cell to the left
Ctrl + Shift + ↑⌘ + Shift + ↑Expand selection to last full cell up
Ctrl + Shift + ↓⌘ + Shift + ↓Expand selection to last full cell down
Shift + PgUpFn + Shift + ↑Expand selection up full screen
Shift + PgDnFn + Shift + ↓Expand selection down full screen
Shift + HomeFn + Shift + ←Expand selection to beginning of row
Ctrl + Shift + HomeFn + Control + Shift + ←Expand selection to first worksheet cell
Ctrl + Shift + EndFn + Control + Shift + →Expand selection to last worksheet cell
F8 Fn + F8Toggle extend selection mode
Ctrl + Shift + OFn + Control + Shift + OSelect only cells with comments
Ctrl + \Control + \Select row differences
Ctrl + Shift + |Control + Shift + |Select column differences
Ctrl + [Control + [Select direct precedents

More advanced excel shortcut formulas will be added soon so please bookmark this page and keep checking it for more Keys.

Categories Windows

Leave a Comment