docs / articles / Master Excel: Ultimate List of Control Shortcuts

Master Excel: Ultimate List of Control Shortcuts

Sara Jul 09, 2026 2026-07-09 04:40:45

Excel, a staple in the world of spreadsheet software, offers a plethora of shortcuts to enhance productivity and efficiency. These keyboard shortcuts can save you time and effort, allowing you to navigate and manipulate your data with ease. Let's delve into a comprehensive list of control shortcuts in Excel that every user should know.

the excel shortcut keys list is shown in blue and pink, with numbers for each key
the excel shortcut keys list is shown in blue and pink, with numbers for each key

Before we dive into the specifics, it's essential to understand that control shortcuts in Excel typically involve pressing the 'Ctrl' key along with another key. This combination helps you perform various actions quickly, from navigating your worksheet to editing and formatting cells.

Excel shortcut ...✅
Excel shortcut ...✅

Basic Navigation Shortcuts

Mastering these navigation shortcuts can significantly improve your workflow in Excel.

Microsoft Excel Cheat Sheet | Essential Formulas, Shortcuts & Productivity Tips
Microsoft Excel Cheat Sheet | Essential Formulas, Shortcuts & Productivity Tips

1. **Moving Between Cells:** Use the arrow keys (Up, Down, Left, Right) to move between adjacent cells. To move to the last cell in a column or row, press 'Ctrl + Up' or 'Ctrl + Down', and 'Ctrl + Left' or 'Ctrl + Right' for the first cell.

Cell Selection

the keyboard shortcuts list is shown here
the keyboard shortcuts list is shown here

2. **Selecting a Column or Row:** To select an entire column, click the column letter at the top of the worksheet. To select an entire row, click the row number on the left. To select multiple columns or rows, click and drag the column letter or row number.

3. **Selecting a Range:** To select a range of cells, click and drag the mouse over the desired cells. Alternatively, you can use the 'Ctrl' key to select non-adjacent cells. For example, 'Ctrl + Shift + Up' selects all cells from the current cell to the top of the worksheet.

Screen Scrolling

Microsoft Office shortcut
Microsoft Office shortcut

4. **Scrolling Up and Down:** Press 'Page Up' or 'Page Down' to scroll up or down the worksheet. To scroll one screen at a time, use 'Ctrl + Page Up' or 'Ctrl + Page Down'.

5. **Scrolling Left and Right:** To scroll horizontally, use the arrow keys or the 'Home' and 'End' keys. For example, 'Ctrl + Home' moves the screen to the first column, and 'Ctrl + End' moves the screen to the last column.

Editing and Formatting Shortcuts

30+ Excel Shortcuts Every Professional Should Know
30+ Excel Shortcuts Every Professional Should Know

These shortcuts help you edit and format cells quickly, saving you time and effort.

1. **Copying and Pasting:** To copy a cell or range, press 'Ctrl + C'. To paste the copied content, press 'Ctrl + V'. To paste only the values without formatting, use 'Ctrl + Alt + V' and select 'Values' from the menu.

a poster with the words 70 important computer and excel shortcut keys
a poster with the words 70 important computer and excel shortcut keys
the excel ctrl shortcuts cheat sheet
the excel ctrl shortcuts cheat sheet
Microsoft Excel Laminated Shortcut Card - Over 200 Keyboard Shortcuts for Windows and Mac Side-by...
Microsoft Excel Laminated Shortcut Card - Over 200 Keyboard Shortcuts for Windows and Mac Side-by...
Computer tricks😉
Computer tricks😉
📈 Master Excel Like a Pro: 100+ Essential Shortcuts
📈 Master Excel Like a Pro: 100+ Essential Shortcuts
excel useful shortcuts
excel useful shortcuts
an excel sheet with the numbers and colors for each item in this chart, you can see
an excel sheet with the numbers and colors for each item in this chart, you can see
Microsoft Excel Shortcut key
Microsoft Excel Shortcut key
Excel shortcuts
Excel shortcuts
Excel Shortcuts
Excel Shortcuts
the excel shortcuts list is shown with green and black numbers on it, which are
the excel shortcuts list is shown with green and black numbers on it, which are
the excel shortcut keys chart sheet is shown in green and has instructions for how to use
the excel shortcut keys chart sheet is shown in green and has instructions for how to use
Excel Keyboard Shortcuts Every Office User Should Know
Excel Keyboard Shortcuts Every Office User Should Know
short computer keys
short computer keys
⌨️ Still using Excel without keyboard shortcuts? You're wasting hours every week!
⌨️ Still using Excel without keyboard shortcuts? You're wasting hours every week!
an excel shortcuts worksheet with the words, how to use it
an excel shortcuts worksheet with the words, how to use it
Master Excel Shortcuts
Master Excel Shortcuts
an exercise sheet with the words excel shortcuts and how to fill them out
an exercise sheet with the words excel shortcuts and how to fill them out
the google sheet shortcut keys are shown in different colors and sizes, including blue, yellow
the google sheet shortcut keys are shown in different colors and sizes, including blue, yellow
Excel Shortcuts Every Student & Professional Must Know | Boost Productivity Fast
Excel Shortcuts Every Student & Professional Must Know | Boost Productivity Fast

Formatting

2. **Formatting as Table:** To format a range of cells as a table, select the cells and press 'Ctrl + T'. This applies a table style and adds filters to your data.

3. **Clearing Formatting:** To remove formatting from a cell or range, select the cells and press 'Ctrl + Spacebar'. This clears the formatting while keeping the cell values intact.

Editing

4. **Undo and Redo:** To undo the last action, press 'Ctrl + Z'. To redo an undone action, press 'Ctrl + Y' or 'Ctrl + Shift + Z'.

5. **Cutting and Deleting:** To cut a cell or range, press 'Ctrl + X'. To delete the contents of a cell or range, press 'Ctrl + -' (minus key). To delete the entire row or column, select the row or column and press 'Ctrl + -'.

Advanced Shortcuts

These advanced shortcuts allow you to perform complex tasks with ease.

1. **Sorting and Filtering:** To sort a column, select the column and press 'Ctrl + Shift + L'. To apply a filter to a column, select the column and press 'Ctrl + Shift + F'.

Named Ranges

2. **Creating Named Ranges:** To create a named range, select the cells, click in the 'Name Box' (to the left of the formula bar), type a name, and press 'Enter'. This allows you to refer to the range using its name instead of its cell reference.

3. **Using Named Ranges:** To use a named range in a formula, type the name in place of the cell reference. For example, if you have a named range 'Sales', you can use it in a formula like this: =SUM(Sales).

Mastering these control shortcuts in Excel can significantly enhance your productivity and make your work more enjoyable. With practice, these shortcuts will become second nature, allowing you to navigate, edit, and format your worksheets with ease. So, start exploring these shortcuts today and watch your Excel skills soar!