Scribd
Upload
20 views2 pages

Excel Shortcut Keys Guide

The document is a guide to essential Microsoft Excel keyboard shortcuts, categorized into basic, navigation, formatting, data, and advanced shortcuts. Each category lists specific shortcut keys along with their corresponding functions to enhance productivity in Excel. This comprehensive reference aims to help users efficiently navigate and utilize Excel's features.

Uploaded by

muhammedahmed2238
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
20 views2 pages

Excel Shortcut Keys Guide

The document is a guide to essential Microsoft Excel keyboard shortcuts, categorized into basic, navigation, formatting, data, and advanced shortcuts. Each category lists specific shortcut keys along with their corresponding functions to enhance productivity in Excel. This comprehensive reference aims to help users efficiently navigate and utilize Excel's features.

Uploaded by

muhammedahmed2238
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Microsoft Excel Shortcut Keys Guide

Essential Keyboard Shortcuts for Productivity

📘 Basic Shortcuts
Shortcut Key Description
Ctrl + N Create a new workbook
Ctrl + O Open an existing workbook
Ctrl + S Save the current workbook
F12 Save As
Ctrl + P Print the workbook
Ctrl + Z Undo the last action
Ctrl + Y Redo the last action
Ctrl + C Copy selected cells
Ctrl + X Cut selected cells
Ctrl + V Paste copied/cut cells

📗 Navigation Shortcuts
Shortcut Key Description
Arrow Keys Move one cell up, down, left, or right
Ctrl + Arrow Key Jump to the edge of data region
Home Go to the beginning of the row
Ctrl + Home Go to the beginning of the worksheet
Ctrl + End Go to the last used cell
Page Up / Page Down Move one screen up or down
Alt + Page Up / Page Down Move one screen left or right

📙 Formatting Shortcuts
Shortcut Key Description
Ctrl + 1 Format cells dialog box
Ctrl + B Apply or remove bold formatting
Ctrl + I Apply or remove italic formatting
Ctrl + U Apply or remove underline
Alt + E, S, V Paste Special dialog box
Ctrl + Shift + $ Apply currency format
Ctrl + Shift + % Apply percentage format
Ctrl + Shift + # Apply date format
Ctrl + Shift + @ Apply time format
Ctrl + Shift + ^ Apply exponential format

📕 Data Shortcuts
Shortcut Key Description
Alt + = AutoSum selected cells
Ctrl + T Convert range into a table
Ctrl + Shift + L Add or remove filters
Ctrl + ; Insert current date
Ctrl + Shift + : Insert current time
Ctrl + D Fill down
Ctrl + R Fill right
Shift + F9 Calculate active worksheet
F9 Calculate all worksheets

⭐ Advanced & Productivity Shortcuts


Shortcut Key Description
Ctrl + F Find
Ctrl + H Find and Replace
Alt + F1 Insert chart in the same sheet
F11 Insert chart in a new sheet
Ctrl + Shift + " Copy value from cell above
Ctrl + ‘ Copy formula from cell above
Alt + Enter Insert a line break inside a cell
Ctrl + Space Select entire column
Shift + Space Select entire row
Ctrl + Shift + Arrow Keys Select data range

You might also like