MS Excel Shortcut Keys PDF 2023

MS Excel Shortcut Keys PDF 2023, Most Used MS Excel Shortcut Keys PDF for Windows, Ribbon keyboard shortcuts Keys for Windows.

PDF Name	MS Excel Shortcut Keys PDF
No. of Pages	17
PDF Size	796 kb
Language	English
PDF Category	Education & Jobs
Published/Updated	May 18, 2022
Source / Credits	MyPdf
Uploaded By	MyPdf

MS Excel Shortcut Keys PDF

Microsoft Excel is a powerful spreadsheet application that can help you with various tasks, from data entry to data analysis. Here are some of the most useful keyboard shortcuts that can help you work more efficiently in Excel:

MS Excel Shortcut Keys PDF – General

Function	Key
Open Help	F1
Undo Last Action	Ctrl+Z
Redo last action	Ctrl+Y
Copy selection	Ctrl+C
Repeat last action	F4
Cut Selection	Ctrl+X
Paste content from clipboard	Ctrl+V
Display the Paste Special dialog box	Ctrl+Alt+V
Display find and replace with find tab selected	Ctrl+F
Display nd and replace with Replace tab selected	Ctrl+H
Find previous match (after initial Find)	Ctrl+Shift+F4
Find next match (after initial Find)	Shift +F4
Insert embedded chart	Alt+F1
Insert chart in new sheet	F11
Toggle Autolter	Ctrl+Shift+L
Activate filter	Alt+↧
Create table	Ctrl+T
Select table row	Shift+Space
Select table column	Ctrl + Space
Select table (when active cell is in table)	Ctrl+A
Clear slicer lter	Alt+C
Run Spellcheck	F7
Open Thesaurus	Shift+F7
Open Macro dialog box	Alt+F8
Open VBA Editor	Alt+F11
Duplicate object	Ctrl+D
Snap to grid (whilst dragging)	Alt
Hide or show objects	Ctrl+6
Open Modify Cell Style dialog box	Alt+’
Show right-click menu	Shift+F10
Display control menu	Alt+Space

Read More: Basic Autocad Shortcut Keys PDF 2023

MS Excel Shortcut Keys PDF – Worksheet

Function	Key
Insert new worksheet	Shift+F11
Go to next worksheet	Ctrl+PgDn
Go to previous worksheet	Ctrl+PgUp
Rename current worksheet	Alt+O, H,R
Delete current worksheet	Alt+E,L
Move current worksheet	Alt+E, M
Move between the worksheet, Ribbon, task pane and zoom controls in a worksheet that has been split	F6 or Shift+F6
Select adjacent worksheets	Ctrl+Shift+PgUp/PgDn
Select non-adjacent worksheets	Ctrl+Click
Toggle scroll lock	ScrLk
Toggle full screen	Ctrl+Shift+F1
Print	Ctrl+P
Open print preview window	Ctrl+F2
Set print area	Alt+P, R S
Clear print area	Alt+P, R C
Zoom in	Ctrl+ Mouse Wheel Up
Zoom out	Ctrl+ Mouse Wheel Down
Protect sheet	Alt+R, PS

MS Excel Shortcut Keys PDF – Workbook

Functional	Key
Create new workbook	Ctrl+N
Open workbook	Ctrl+O
Save workbook	Ctrl+S
Save as	F12
Go to next workbook	Ctrl+Tab
Go to previous workbook	Ctrl+Shift+Tab
Minimize current workbook window	Ctrl+F9
Maximize current workbook window	Ctrl+F10
Protect workbook	Alt+R, PW
Close current workbook	Ctrl+F4
Close Excel	Alt+F4

MS Excel Shortcut Keys PDF – Ribbon

Function	Key
Expand or collapse ribbon	Ctrl+F1
Activate access keys	Alt
Move through Ribbon tabs and groups	↦ ↤ ↥ ↧
Activate or open selected control	Space or Enter
Conrm control change	Enter
Get help on selected control	F1

Navigation Excel Shortcuts

• Move one cell right – →
• Move one cell left – ←
• Move one cell up – ↑
• Move one cell down – ↓
• Move one screen right – Alt + PgDn
• Move one screen left – Alt + PgUp
• Move one screen up – PgUp
• Move one screen down – PgDn
• Move to right edge of data region – Ctrl + →
• Move to left edge of data region – Ctrl + ←
• Move to top edge of data region – Ctrl + ↑
• Move to bottom edge of data region – Ctrl + ↓
• Move to beginning of row – Home
• Move to last cell in worksheet that contains data – Ctrl + End
• Move to rst cell in worksheet – Ctrl + Home
• Turn End mode on – End

Read More: Basic Maths Formulas Pdf Download

Formatting Excel Shortcuts

• Format cells – Ctrl + 1
• Display Format Cells with Font tab selected – Ctrl + Shift + F
• Apply or remove bold – Ctrl + B
• Apply or remove italics – Ctrl + I
• Apply or remove underscore – Ctrl + U
• Apply or remove strikethrough – Ctrl + 5
• Align center – Alt + H , A C
• Align left – Alt + H , A L
• Indent – Alt + H , 6
• Remove indent – Alt + H , 5
• Wrap text – Alt + H , W
• Align top – Alt + H , A T
• Align middle – Alt + H , A M
• Align bottom – Alt + H , A B
• Increase font size one step – Alt + H , F G
• Decrease font size one step – Alt + H , F K

Number Formatting Excel Shortcuts

• Apply general format – Ctrl + Shift + ~
• Apply number format – Ctrl + Shift + !
• Apply time format – Ctrl + Shift + @
• Apply date format – Ctrl + Shift + #
• Apply currency format – Ctrl + Shift + $
• Apply percentage format – Ctrl + Shift + %
• Apply scientic format – Ctrl + Shift + ^

Note: These shortcuts may vary based on the version of Excel you are using and the keyboard layout you have selected.

So, don’t delay and download the PDF from the link given below.

---

You can download the MS Excel Shortcut Keys PDF at the link given below:

---

Report This: We DO NOT own any copyrights of this PDF File. If you want this to be removed or if it is copyright infringement, do drop us an email at [email protected] and this will be taken down within 24 hours!

Download: Agents of Socialization Pdf Download