After selecting your platform, you’ll get access to platform-specific cheat sheets for the actions you perform daily. These shortcuts let you complete common spreadsheet tasks faster than using menus.
Why learn them
- Less clicking: fewer trips to the Ribbon and context menus.
- Faster cleanup: formatting, selection, and edits happen immediately.
- Better flow: you stay in the grid and keep your attention on the data.
- More consistent work: repeatable commands reduce mistakes and rework.
- Quicker troubleshooting: you can filter, find, and adjust sheets without breaking focus.
Clipboard and paste
Cut, Copy, and Paste are some of the most frequently used actions in any spreadsheet workflow and are the quickest way to take advantage of Excel shortcuts. For more precise control, you can use Paste Special, which allows you to choose specific options after opening the command. When your main goal is to paste only the values, the Paste only the values (not formulas) and number formats from copied cell command provides a fast and efficient routine.
Rows and columns
Select entire row and Select entire column are frequent actions in cleaning and maintaining data, so it’s important to select the row or a cell within it first to ensure the command applies correctly. Open the Insert dialog box is used for inserting new rows or columns, and creating new sheets is another repeated task that helps organize your work efficiently.
Cells and highlighting
When formatting headers, section labels, or blocks of data, using shortcuts can save many small, repetitive clicks. Merge cells is a common task, though it can be overused, so it’s best applied only when needed. Choosing a fill color helps highlight important areas and organize your data visually.
Data and filtering
Filtering is one of the most effective ways to speed up work in Excel, as it reduces scrolling and manual searching in large tables. Filter shortcut combined with Find makes it even faster to locate specific values within big sheets. Save workbook and Save As are easy to overlook until you’re under pressure, for example when closing a workbook (Close a workbook), opening a workbook (Open a workbook), sharing a copy, or exporting a report. When working with multiple workbooks, learning both window switching at the operating system level and workbook switching within Excel helps you move between files efficiently without hunting for tabs.