[go: up one dir, main page]
Scribd
Upload
12 views9 pages

Development Modeling Excel Shortcuts

This document is a cheat sheet for Excel hotkeys and shortcuts, organized into categories such as navigation, controlling columns and rows, text formatting, font style, borders, alignment, function shortcuts, and copy & paste. Each category lists specific actions along with their corresponding keyboard shortcuts. It serves as a quick reference guide for users to enhance their efficiency in Excel.

Uploaded by

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

Development Modeling Excel Shortcuts

This document is a cheat sheet for Excel hotkeys and shortcuts, organized into categories such as navigation, controlling columns and rows, text formatting, font style, borders, alignment, function shortcuts, and copy & paste. Each category lists specific actions along with their corresponding keyboard shortcuts. It serves as a quick reference guide for users to enhance their efficiency in Excel.

Uploaded by

dukehernandes612
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 9

EXCEL HOTKEYS & SHORTCUTS CHEAT SHEET

Navigating Throughout The


Sheet & Workbook
• Highlight Cell A1
o Ctrl + Home
• Move to Next/Previous
Sheet
o Ctrl + Page Down/Up
• Move to Next Cell That
Contains a Value
o Ctrl + Arrow Key
• Select Cells in a
Contiguous Row or Column
o Shift + Arrow Key
Controlling Columns + Rows
• AutoFit Column Width
o Alt + H + O + I

• AutoFit Row Height


o Alt + H + O + A

• Add Row/Column
o Ctrl + Shift + =

• Delete Row/Column
o Ctrl + -
Text Formatting
• Currency
o Alt + H + N + C
• Percentage
o Alt + H + N + P
• Number
o Alt + H + N + N
• Short Date
o Alt + H + N + S
• Format Cells
o Ctrl + 1
Font Style
• Font Style
o Alt + H + F + F

• Font Size
o Alt + H + F + S

• Cell Highlight Color


o Alt + H + H

• Text Color
o Alt + H + F + C
Borders
• Top Border
o Alt + H + B + P

• Bottom Border
o Alt + H + B + O

• Outside Borders
o Alt + H + B + S

• All Borders
o Alt + H + B + A
Alignment
• Right Align
o Alt + H + A + R
• Left Align
o Alt + H + A + L
• Center Align
o Alt + H + A + C
• Merge + Center
o Alt + H + M + C
• Wrap Text
o Alt + H + W
Function Shortcuts
• Edit Cell Formula
o F2

• AutoFill Function
o Tab

• AutoSum Contiguous Range


o Alt + =
Copy & Paste
• Paste Values
o Alt + E + S + V
• Paste Formulas
o Alt + E + S + F
• Paste Formats
o Alt + E + S + T
• Copy Cells Across Columns
o Ctrl + R
• Copy Cells Down Rows
o Ctrl + D

You might also like