Excel Shortcut Cheat Sheet 2019 PDF: Boost Your Productivity Now

Excel Shortcuts Overview

If you’re looking to increase your productivity and efficiency in Excel, learning keyboard shortcuts is a must. Excel shortcuts are combinations of keys that perform a specific action, allowing you to perform tasks quickly and easily. In this section, we’ll provide an overview of Excel shortcuts, including what they are, how to use them, and some of the most essential ones to know.

Excel shortcuts can be accessed by pressing a combination of keys on your keyboard, also known as shortcut keys or hotkeys. These shortcuts can be used to perform a wide range of tasks in Excel, from navigating between cells and worksheets to formatting data and running macros. By using shortcuts, you can save time and reduce the strain on your hands and wrists caused by repetitive mouse movements.

To use Excel shortcuts, you’ll need to memorize the key combinations for the actions you want to perform. Some of the most commonly used shortcuts include Ctrl+C for copying, Ctrl+V for pasting, and Ctrl+Z for undoing. Excel also provides a range of built-in shortcuts for specific tasks, such as filtering data, inserting rows and columns, and formatting cells.

Here’s a table summarizing some of the most essential Excel shortcuts:

Shortcut Key	Action
Ctrl+C	Copy
Ctrl+V	Paste
Ctrl+Z	Undo
Ctrl+A	Select all
Ctrl+B	Bold
Ctrl+I	Italic
Ctrl+U	Underline
Ctrl+F	Find
Ctrl+H	Replace
Ctrl+P	Print

Learning Excel shortcuts can take some time and practice, but it’s well worth the effort. By mastering these key combinations, you can significantly improve your productivity and efficiency in Excel, making it easier to work with large amounts of data and perform complex calculations. So why not give it a try and see how much time you can save?

Basic Excel Shortcuts

Excel shortcuts can save you time and effort. By knowing key navigation, cell editing, and formatting shortcuts, you can increase your productivity and streamline your workflow. In this section, we will cover some of the most basic Excel shortcuts that you can use on a daily basis.

Navigation Shortcuts

Navigation shortcuts allow you to move around your Excel workbook quickly and efficiently. Here are some of the most useful navigation shortcuts:

Shortcut	Description
Ctrl + Home	Move to the beginning of the worksheet
Ctrl + End	Move to the end of the worksheet
Ctrl + Arrow Keys	Move to the last non-empty cell in the row or column
Ctrl + Page Up	Move to the previous worksheet
Ctrl + Page Down	Move to the next worksheet

Editing Shortcuts

Editing shortcuts allow you to quickly edit cells in your Excel workbook. Here are some of the most useful editing shortcuts:

Shortcut	Description
Ctrl + C	Copy selected cells
Ctrl + X	Cut selected cells
Ctrl + V	Paste copied or cut cells
Ctrl + Z	Undo last action
Ctrl + Y	Redo last action

Formatting Shortcuts

Formatting shortcuts allow you to quickly format cells in your Excel workbook. Here are some of the most useful formatting shortcuts:

Shortcut	Description
Ctrl + B	Bold selected text
Ctrl + I	Italicize selected text
Ctrl + U	Underline selected text
Ctrl + S	Save workbook
F12	Save workbook as
Ctrl + P	Print workbook
Ctrl + F2	Open print preview

By using these basic Excel shortcuts, you can save time and work more efficiently. Whether you’re navigating your workbook, editing cells, or formatting your data, these shortcuts will help you get the job done quickly and easily.

Excel Shortcuts for Navigation

Navigating through large Excel spreadsheets can be time-consuming, but using keyboard shortcuts can make it much faster and efficient. Here are some essential Excel shortcuts for navigation that you should know:

Shortcut	Function
Arrow keys	Move one cell in the direction of the arrow
Page Up	Move up one screen
Page Down	Move down one screen
Ctrl + Arrow keys	Move to the last cell in the direction of the arrow that contains data
Ctrl + Home	Move to the beginning of the worksheet
Ctrl + End	Move to the last cell that contains data on the worksheet
Ctrl + G	Display the Go To dialog box

Using the arrow keys is the most basic way to navigate through an Excel spreadsheet. Pressing the up or down arrow key moves you one cell in that direction, while pressing the right or left arrow key moves you one cell in that direction.

If you need to move quickly up or down a large spreadsheet, you can use the Page Up or Page Down keys. This will move you up or down one screen at a time.

To move to the last cell in a column or row that contains data, press Ctrl and the arrow key in the direction you want to move. For example, if you want to move to the last cell with data in column A, press Ctrl + Down Arrow.

If you want to quickly move to the beginning or end of the worksheet, use Ctrl + Home or Ctrl + End, respectively. This is especially useful when you are working with large spreadsheets.

Finally, if you need to move to a specific cell, use Ctrl + G to display the Go To dialog box. Here you can enter the cell address or a range of cells that you want to move to.

By using these essential Excel shortcuts for navigation, you can save time and work more efficiently in Excel.

Excel Shortcuts for Data Handling

When working with large amounts of data in Excel, it’s important to know how to efficiently handle and manipulate that data. Here are some useful Excel shortcuts for data handling that can save you time and effort:

Inserting and Deleting Data

To insert a new row or column, simply select the row or column next to where you want to insert and press Ctrl + Shift + +. To delete a row or column, select the row or column you want to delete and press Ctrl + -.

Using Paste Special

The Paste Special feature in Excel allows you to paste only certain aspects of copied data, such as values or formatting. To access the Paste Special dialog box, press Ctrl + Alt + V.

Working with Data Ranges

To quickly select a range of cells, click on the first cell in the range and then hold down the Shift key while clicking on the last cell in the range. To select an entire column, click on the column letter at the top of the column. To select an entire row, click on the row number to the left of the row.

Using the Clipboard

The Clipboard in Excel allows you to copy and paste multiple items at once. To access the Clipboard, click on the Home tab and then click on the Clipboard button in the Clipboard group.

Table of Excel Shortcuts for Data Handling

Here is a table summarizing the Excel shortcuts for data handling:

Action	Shortcut
Insert new row or column	Ctrl + Shift + +
Delete row or column	Ctrl + -
Paste Special	Ctrl + Alt + V
Select range of cells	Click first cell, hold Shift, click last cell
Select entire column	Click column letter
Select entire row	Click row number
Access Clipboard	Home tab, Clipboard button

Excel Shortcuts for Cell and Text Formatting

When working with Excel, formatting cells and text is an important aspect of creating a professional-looking and organized spreadsheet. Here are some useful Excel shortcuts for formatting cells and text:

Shortcut	Function
Ctrl + 1	Open the Format Cells 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 number format with two decimal places
Ctrl + B	Bold text
Ctrl + I	Italicize text
Ctrl + U	Underline text
Ctrl + 5	Strikethrough text
Ctrl + Shift + F	Open the Format Cells dialog box with the Font tab selected
Ctrl + Shift + P	Open the Format Cells dialog box with the Border tab selected
Ctrl + Shift + L	Toggle filter on/off
Ctrl + Shift + &	Apply outline border to selected cells
Ctrl + Shift + _	Remove outline border from selected cells
Ctrl + Shift + ~	Apply General format to selected cells
Ctrl + Shift + $	Apply Currency format to selected cells
Ctrl + Shift + %	Apply Percentage format to selected cells
Ctrl + Shift + ^	Apply Exponential format to selected cells
Ctrl + Shift + #	Apply Date format to selected cells
Ctrl + Shift + @	Apply Time format to selected cells
Ctrl + Shift + !	Apply Number format to selected cells

To apply conditional formatting to cells, use the following shortcut:

Shortcut	Function
Alt + H + L	Open the Conditional Formatting menu

To copy the formatting of one cell to another, use the following shortcut:

Shortcut	Function
Ctrl + Shift + C	Copy cell formatting
Ctrl + Shift + V	Paste cell formatting

To quickly apply a cell style, use the following shortcut:

Shortcut	Function
Alt + H + J	Open the Cell Styles menu

To copy the format of a cell to another cell using the Format Painter, use the following shortcut:

Shortcut	Function
Ctrl + Shift + C	Copy cell formatting
Ctrl + Shift + V	Paste cell formatting
Ctrl + Shift + P	Toggle Format Painter on/off

In conclusion, using Excel shortcuts for cell and text formatting can save you time and effort when creating and organizing your spreadsheets. With these shortcuts, you can quickly apply formatting to cells and text, copy formatting from one cell to another, and apply conditional formatting to highlight important data.

Excel Shortcuts for Calculation and Functions

When it comes to working with Excel, calculations and functions are some of the most important features. Here are some essential Excel shortcuts for calculations and functions that you should know:

• Formulas: Excel formulas are essential for performing calculations. To insert a formula, you can use the “=” key. For example, if you want to add the values in cells A1 and A2, you can type “=A1+A2”.

• Sum and Count: The SUM and COUNT functions are commonly used in Excel. To quickly calculate the sum of a range of cells, you can use the “Alt + =” shortcut. To count the number of cells in a range, you can use the “Ctrl + Shift + #”.

• Autosum: If you want to quickly calculate the sum of a column or row, you can use the Autosum feature. To use Autosum, select the cell where you want to display the sum, and then press “Alt + =”.

• Relative Reference: When you use a formula in Excel, you can use relative references to make the formula flexible. For example, if you want to add the values in cells A1 and A2, you can use the formula “=A1+A2”. If you copy and paste this formula to cell B2, it will automatically adjust to “=B1+B2”.

Table

Shortcut	Function
=	Insert a formula
Alt + =	Autosum
Ctrl + Shift + #	Count cells
F2	Edit cell contents
F4	Repeat the last action
Shift + F3	Insert a function
Ctrl + Shift + Enter	Array formula
Ctrl + `	Display formulas
Ctrl + Shift + %	Format as percentage
Ctrl + Shift + $	Format as currency
Ctrl + Shift + #	Format as date
Ctrl + Shift + @	Format as time
Ctrl + Shift + ^	Format as scientific notation
Ctrl + Shift + !	Format as number
Ctrl + Shift + &	Apply outline border
Ctrl + Shift + _	Remove outline border
Ctrl + Shift + *	Select current region

Excel Shortcuts for Working with Tables

Working with tables in Excel can be time-consuming, but there are several keyboard shortcuts that can make the process quicker and more efficient. Here are some Excel shortcuts that you can use when working with tables:

Navigation

Navigating through tables can be a hassle, but with these shortcuts, you can quickly move around your table:

• Tab: Move to the next cell
• Shift + Tab: Move to the previous cell
• Ctrl + Arrow keys: Move to the last cell in a row or column
• Ctrl + Home: Move to the first cell in a worksheet
• Ctrl + End: Move to the last cell in a worksheet
• Ctrl + Page Up: Move to the previous sheet in a workbook
• Ctrl + Page Down: Move to the next sheet in a workbook

Columns

When working with tables, you may need to insert or delete columns. These shortcuts can help you quickly make changes to your table:

• Ctrl + Spacebar: Select the entire column
• Ctrl + Shift + + (plus sign): Insert a new column to the right of the selected column
• Ctrl + – (minus sign): Delete the selected column

Pivot Tables

Pivot tables are a powerful tool in Excel that can help you analyze and summarize large amounts of data. Here are some shortcuts that can help you work with pivot tables:

• Alt + D, P: Create a pivot table
• Alt + D, F, F: Refresh a pivot table
• Alt + J, T, F: Change the format of a pivot table

Table Formatting

Formatting tables can be time-consuming, but with these shortcuts, you can quickly format your table:

• Ctrl + 1: Open the Format Cells dialog box
• Ctrl + B: Apply bold formatting to the selected cells
• Ctrl + I: Apply italic formatting to the selected cells
• Ctrl + U: Apply underline formatting to the selected cells

Table Shortcuts Table

Here is a table that summarizes the Excel shortcuts for working with tables:

Shortcut	Description
Tab	Move to the next cell
Shift + Tab	Move to the previous cell
Ctrl + Arrow keys	Move to the last cell in a row or column
Ctrl + Home	Move to the first cell in a worksheet
Ctrl + End	Move to the last cell in a worksheet
Ctrl + Page Up	Move to the previous sheet in a workbook
Ctrl + Page Down	Move to the next sheet in a workbook
Ctrl + Spacebar	Select the entire column
Ctrl + Shift + + (plus sign)	Insert a new column to the right of the selected column
Ctrl + – (minus sign)	Delete the selected column
Alt + D, P	Create a pivot table
Alt + D, F, F	Refresh a pivot table
Alt + J, T, F	Change the format of a pivot table
Ctrl + 1	Open the Format Cells dialog box
Ctrl + B	Apply bold formatting to the selected cells
Ctrl + I	Apply italic formatting to the selected cells
Ctrl + U	Apply underline formatting to the selected cells

Using these Excel shortcuts for working with tables can save you time and effort, making your workflow more efficient.

Excel Shortcuts for Viewing and Display

When working in Excel, you will often need to adjust your view to see the data more clearly. Here are some keyboard shortcuts to help you quickly change the display settings:

Shortcut	Action
Ctrl + F1	Show/hide the ribbon
Ctrl + `	Show/hide gridlines
Ctrl + Shift + L	Show/hide filter dropdowns
Ctrl + Shift + *	Select current region (data area around active cell)
Ctrl + 0	Hide selected columns
Ctrl + 9	Hide selected rows
Ctrl + Shift + 0	Unhide hidden columns within selection
Ctrl + Shift + 9	Unhide hidden rows within selection

You can also use the View tab on the ribbon to adjust your display settings. Here are some of the most commonly used options:

• Zoom: Adjust the zoom level of the worksheet.
• Freeze Panes: Keep certain rows or columns visible while scrolling through the rest of the worksheet.
• Split: Split the worksheet into multiple panes for easier viewing.
• Gridlines: Show or hide gridlines.
• Headings: Show or hide row and column headings.
• Workbook Views: Switch between Normal, Page Layout, and Page Break Preview views.

In addition to these shortcuts and options, you can also use keyboard shortcuts to navigate around the worksheet. Here are some of the most useful ones:

• Ctrl + Home: Go to the top-left cell of the worksheet.
• Ctrl + End: Go to the last cell containing data on the worksheet.
• Ctrl + Arrow Keys: Move to the edge of the current data region in the direction of the arrow.
• Ctrl + Page Up/Page Down: Switch between worksheets in the current workbook.

By using these shortcuts and options, you can quickly adjust your display settings and navigate around the worksheet with ease.

Advanced Excel Shortcuts

When it comes to working with Excel, knowing the basic shortcuts can save you a lot of time. But if you’re looking to take your productivity to the next level, it’s time to learn some advanced Excel shortcuts. These shortcuts can help you navigate through Excel more efficiently and perform complex tasks with ease.

Function Keys

Function keys are a set of keys located at the top of your keyboard that can be used to perform specific tasks in Excel. Here are some of the most commonly used function keys:

• F2: Edit the selected cell
• F5: Go to a specific cell or range
• F11: Create a chart of the selected data

Ribbon Keyboard Shortcuts

The ribbon is the menu bar at the top of the Excel window that contains all the commands and tools you need to work with your data. Here are some of the most commonly used ribbon keyboard shortcuts:

• Alt: Display the keyboard shortcuts for the ribbon
• Alt + H: Home tab
• Alt + N: Insert tab
• Alt + P: Page Layout tab
• Alt + M: Formulas tab
• Alt + A: Data tab
• Alt + R: Review tab
• Alt + W: View tab

Key Tips

Key tips are small letters that appear on the ribbon when you press the Alt key. They allow you to quickly navigate to a specific command or tool. Here’s how to use key tips:

1. Press the Alt key to display the key tips.
2. Press the letter corresponding to the command or tool you want to use.
3. Press Enter to activate the command or tool.

Table

Here’s a table summarizing some of the advanced Excel shortcuts:

Shortcut	Description
F2	Edit the selected cell
F5	Go to a specific cell or range
F11	Create a chart of the selected data
Alt	Display the keyboard shortcuts for the ribbon
Alt + H	Home tab
Alt + N	Insert tab
Alt + P	Page Layout tab
Alt + M	Formulas tab
Alt + A	Data tab
Alt + R	Review tab
Alt + W	View tab

By learning and using these advanced Excel shortcuts, you can become more efficient and productive in your work.

Excel Shortcuts for Different Operating Systems

Excel shortcuts can be incredibly useful for increasing your productivity and streamlining your workflow. Knowing key navigation, cell editing, and formatting shortcuts can save you time and effort. However, it is important to note that some shortcuts may differ depending on the operating system you are using. Here are some Excel shortcuts for different operating systems:

Windows

If you are using Excel on a Windows operating system, you can use the following shortcuts:

Shortcut	Description
Ctrl + C	Copy selected cells
Ctrl + V	Paste copied cells
Ctrl + X	Cut selected cells
Ctrl + Z	Undo last action
Ctrl + Y	Redo last action
Ctrl + B	Bold selected cells
Ctrl + I	Italicize selected cells
Ctrl + U	Underline selected cells
Ctrl + F	Find and replace values
F2	Edit selected cell

macOS

If you are using Excel on a macOS operating system, you can use the following shortcuts:

Shortcut	Description
Command + C	Copy selected cells
Command + V	Paste copied cells
Command + X	Cut selected cells
Command + Z	Undo last action
Command + Shift + Z	Redo last action
Command + B	Bold selected cells
Command + I	Italicize selected cells
Command + U	Underline selected cells
Command + F	Find and replace values
Control + U	Edit selected cell

Android

If you are using Excel on an Android operating system, you can use the following shortcuts:

Shortcut	Description
Long press + Drag	Select multiple cells
Double tap + Drag	Select multiple cells
Double tap	Edit selected cell
Swipe left	Delete selected cells
Swipe right	Insert new cells
Swipe down	Insert new rows
Swipe up	Delete selected rows

iOS

If you are using Excel on an iOS operating system, you can use the following shortcuts:

Shortcut	Description
Long press + Drag	Select multiple cells
Double tap + Drag	Select multiple cells
Double tap	Edit selected cell
Swipe left	Delete selected cells
Swipe right	Insert new cells
Swipe down	Insert new rows
Swipe up	Delete selected rows

Overall, Excel shortcuts can be incredibly useful for increasing your productivity and streamlining your workflow. By knowing the key navigation, cell editing, and formatting shortcuts for your operating system, you can save time and effort when working with Excel.

Excel Shortcuts Cheat Sheet PDF

If you’re looking to improve your efficiency with Excel, then using keyboard shortcuts is a must. Excel shortcuts can save you a lot of time and effort when working on spreadsheets. And the best way to learn them is by using a cheat sheet.

One of the best Excel shortcut cheat sheets available is the Excel 2019 Shortcut Cheat Sheet PDF. This PDF contains a comprehensive list of Excel shortcuts that you can use to speed up your work. You can download it for free from various websites.

Here are some of the most commonly used Excel shortcuts that you’ll find in the cheat sheet:

• Ctrl + C: Copy
• Ctrl + V: Paste
• Ctrl + Z: Undo
• Ctrl + Y: Redo
• Ctrl + A: Select All
• Ctrl + F: Find
• Ctrl + H: Replace
• Ctrl + S: Save
• Ctrl + P: Print

Using these shortcuts can save you a lot of time and effort, especially if you’re working with large spreadsheets.

In addition to the shortcuts listed above, the Excel 2019 Shortcut Cheat Sheet PDF also includes shortcuts for formatting, navigation, and working with formulas. It’s a comprehensive resource that can help you become an Excel power user.

If you’re new to Excel shortcuts, it can be overwhelming to try and learn them all at once. That’s why it’s a good idea to start with the most commonly used shortcuts and gradually work your way up to the more advanced ones.

To help you get started, here’s a table of some of the most commonly used Excel shortcuts:

Shortcut	Function
Ctrl + C	Copy
Ctrl + V	Paste
Ctrl + Z	Undo
Ctrl + Y	Redo
Ctrl + A	Select All
Ctrl + F	Find
Ctrl + H	Replace
Ctrl + S	Save
Ctrl + P	Print

In conclusion, if you’re looking to improve your Excel skills, then using keyboard shortcuts is a must. The Excel 2019 Shortcut Cheat Sheet PDF is a great resource that can help you become an Excel power user. Download it today and start improving your efficiency with Excel.

Additional Resources

If you’re looking to further improve your productivity with Excel, there are a variety of additional resources available to you. Here are a few options to consider:

• Microsoft Excel Help Center: If you’re ever unsure about how to perform a certain task in Excel, the Help Center is a great place to start. You can access it by clicking the question mark icon in the top right corner of the Excel window. From there, you can search for specific topics or browse through the various categories.

• Excel Submenus: Excel has a number of submenus that can be accessed by clicking on the down arrow next to a selected button. These submenus contain additional options and commands that can help you work more efficiently. For example, the Insert tab has submenus for charts, tables, and more.

• Excel Line Charts and Sparklines: Line charts and sparklines are both great tools for visualizing data in Excel. Line charts show changes in data over time, while sparklines are small charts that can be embedded in cells to show trends and patterns. You can create both of these types of charts using the Insert tab.

• Excel Data Tab: The Data tab in Excel contains a variety of tools for working with data, including sorting, filtering, and analyzing data. If you work with large data sets on a regular basis, mastering the tools on this tab can help you save a lot of time.

• Excel Shortcut Cheat Sheet 2019 PDF: Of course, one of the best resources for improving your Excel productivity is the Excel Shortcut Cheat Sheet 2019 PDF. This cheat sheet contains a comprehensive list of keyboard shortcuts that can help you work more efficiently in Excel. You can download it for free from a variety of sources online.

Resource	Description
Microsoft Excel Help Center	Accessible through the question mark icon in the top right corner of the Excel window. Contains a variety of topics and categories to search through.
Excel Submenus	Accessed by clicking on the down arrow next to a selected button. Contains additional options and commands to help you work more efficiently.
Excel Line Charts and Sparklines	Great tools for visualizing data in Excel. Line charts show changes in data over time, while sparklines are small charts that can be embedded in cells to show trends and patterns.
Excel Data Tab	Contains a variety of tools for working with data, including sorting, filtering, and analyzing data.
Excel Shortcut Cheat Sheet 2019 PDF	A comprehensive list of keyboard shortcuts that can help you work more efficiently in Excel. Can be downloaded for free online.