Basic Excel Shortcuts 2010
Understanding Keyboard Shortcuts
Keyboard shortcuts are combinations of keys that perform a specific action in Microsoft Excel. They can save you time and improve your efficiency when working with large amounts of data. To use a keyboard shortcut, press and hold the Ctrl key and then press the corresponding letter or number key. For example, to copy selected cells, press Ctrl+C.
Essential Keyboard Shortcuts
Here are some essential keyboard shortcuts that you should know:
- Ctrl+A: Selects all cells in the current worksheet.
- Ctrl+B: Applies bold formatting to the selected cells.
- Ctrl+C: Copies the selected cells.
- Ctrl+D: Copies the contents of the cell above into the selected cells.
- Ctrl+E: Activates the search box.
- Ctrl+F: Opens the Find and Replace dialog box.
- Ctrl+G: Opens the Go To dialog box.
- Ctrl+H: Opens the Find and Replace dialog box with the Replace tab selected.
- Ctrl+I: Applies italic formatting to the selected cells.
- Ctrl+K: Inserts a hyperlink.
- Ctrl+L: Displays the Create Table dialog box.
- Ctrl+M: Adds a new row to the selected table.
- Ctrl+N: Creates a new workbook.
- Ctrl+O: Opens an existing workbook.
- Ctrl+P: Opens the Print dialog box.
- Ctrl+R: Copies the contents of the cell to the left into the selected cells.
- Ctrl+S: Saves the current workbook.
- Ctrl+U: Applies underline formatting to the selected cells.
- Ctrl+V: Pastes the copied cells.
- Ctrl+X: Cuts the selected cells.
- Ctrl+Y: Repeats the last action.
- Ctrl+Z: Undoes the last action.
Function Key Shortcuts
Function key shortcuts are combinations of keys that perform specific Excel functions. Here are some function key shortcuts that you should know:
- F2: Edits the selected cell.
- F8: Enters Extend Selection mode.
- F9: Calculates all worksheets in all open workbooks.
- F11: Creates a chart of the selected data.
- Ctrl+1: Opens the Format Cells dialog box.
- Ctrl+2: Applies or removes bold formatting.
- Ctrl+3: Applies or removes italic formatting.
- Ctrl+4: Applies or removes underline formatting.
- Ctrl+5: Applies or removes strikethrough formatting.
- Ctrl+6: Shows or hides objects.
- Ctrl+8: Shows or hides the outline symbols.
- Ctrl+9: Hides the selected rows.
- Ctrl+Shift+:: Inserts a new row or column.
- Ctrl+Shift+A: Inserts the argument names and parentheses for a function.
- Ctrl+Shift+~: Applies the General number format.
- Ctrl+Shift+$: Applies the Currency format.
- Ctrl+Shift+%: Applies the Percent format.
- Ctrl+Shift+#: Applies the Date format.
- Ctrl+Shift+!: Applies the Time format.
- Ctrl+Shift+:: Applies the Time format with the hour and minute separated by a colon.
- Ctrl+-: Deletes the selected cells.
- Ctrl+`: Toggles between displaying cell values and formulas.
- Shift+F8: Adds a non-adjacent cell or range to a selection.
- Shift+F11: Inserts a new worksheet.
- Shift+Space: Selects the entire row.
- Alt+Enter: Starts a new line in the same cell.
- Semicolon (;): Enters the current date.
- Colon (:): Enters the current time.
- Grave accent (`): Toggles between displaying absolute and relative cell references.
| Shortcut | Description |
|---|---|
| Ctrl+A | Selects all cells in the current worksheet. |
| Ctrl+B | Applies bold formatting to the selected cells. |
| Ctrl+C | Copies the selected cells. |
| Ctrl+D | Copies the contents of the cell above into the selected cells. |
| Ctrl+E | Activates the search box. |
| Ctrl+F | Opens the Find and Replace dialog box. |
| Ctrl+G | Opens the Go To dialog box. |
| Ctrl+H | Opens the Find and Replace dialog box with the Replace tab selected. |
| Ctrl+I | Applies italic formatting to the selected cells. |
| Ctrl+K | Inserts a hyperlink. |
| Ctrl+L | Displays the Create Table dialog box. |
| Ctrl+M | Adds a new row to the selected table. |
| Ctrl+N | Creates a new workbook. |
| Ctrl+O | Opens an existing workbook. |
| Ctrl+P | Opens the Print dialog box. |
| Ctrl+R | Copies the contents of the cell to the left into the selected cells. |
| Ctrl+S | Saves the current |
Navigating and Selecting in Excel
When working with Excel, it’s important to be able to navigate and select cells efficiently. Here are some shortcuts and tips to help you do just that.
Using Arrow Keys
Arrow keys are a quick and easy way to move around your worksheet. Use the following arrow key shortcuts to move in different directions:
- Up arrow – move one cell up
- Down arrow – move one cell down
- Left arrow – move one cell to the left
- Right arrow – move one cell to the right
You can also use a combination of arrow keys with the Ctrl key to move to the beginning or end of a row or column. For example, Ctrl + Left arrow will take you to the beginning of the current row, and Ctrl + Up arrow will take you to the beginning of the current column.
Page Navigation Shortcuts
If you have a large worksheet, it can be helpful to use page navigation shortcuts to move quickly between different parts of the sheet. Here are some shortcuts you can use:
- Page Up – move up one screen
- Page Down – move down one screen
- Ctrl + Home – move to the beginning of the worksheet
- Ctrl + End – move to the end of the worksheet
Selection Shortcuts
When working with large amounts of data, selecting cells efficiently can save you a lot of time. Here are some selection shortcuts you can use:
- Shift + arrow keys – select cells in the direction of the arrow key
- Ctrl + ; – select the current date
- Ctrl + Shift + : – select the current time
- Ctrl + A – select all cells in the worksheet
Table
| Shortcut | Action |
|---|---|
| Up arrow | Move one cell up |
| Down arrow | Move one cell down |
| Left arrow | Move one cell to the left |
| Right arrow | Move one cell to the right |
| Ctrl + Left arrow | Move to the beginning of the current row |
| Ctrl + Up arrow | Move to the beginning of the current column |
| Page Up | Move up one screen |
| Page Down | Move down one screen |
| Ctrl + Home | Move to the beginning of the worksheet |
| Ctrl + End | Move to the end of the worksheet |
| Shift + arrow keys | Select cells in the direction of the arrow key |
| Ctrl + ; | Select the current date |
| Ctrl + Shift + : | Select the current time |
| Ctrl + A | Select all cells in the worksheet |
Editing and Formatting in Excel
Cell Editing Shortcuts
When working with Excel, editing cells is an essential task. Here are some useful shortcuts to help you edit cells quickly and efficiently:
| Shortcut | Action |
|---|---|
| Ctrl+Z | Undo |
| Ctrl+Y | Redo |
| Ctrl+C | Copy |
| Ctrl+V | Paste |
| Ctrl+X | Cut |
| Delete | Deletes the selected cells |
| Ctrl+D | Copies the contents of the cell above the current cell |
Formatting Shortcuts
Formatting cells in Excel can be a time-consuming task, but using shortcuts can save you a lot of time. Here are some formatting shortcuts that you can use:
| Shortcut | Action |
|---|---|
| Ctrl+K | Create a hyperlink |
| Ctrl+B | Bold |
| Ctrl+I | Italic |
| Ctrl+U | Underline |
| Ctrl+3 | Apply the number format with two decimal places, thousands separator, and minus sign (-) for negative values |
| Ctrl+4 | Apply the currency format with two decimal places |
| Ctrl+5 | Apply the strikethrough format |
| Ctrl+6 | Apply the outline border |
| Ctrl+Shift+! | Apply the comma format |
| Ctrl+Shift+$ | Apply the currency format |
| Ctrl+Shift+% | Apply the percentage format |
| Ctrl+Shift+# | Apply the date format |
| Ctrl+Shift+@ | Apply the time format |
To format cells, you can also use the Format Cells dialog box. To access this dialog box, select the cells you want to format, right-click and select Format Cells. In the Format Cells dialog box, you can choose from a variety of formatting options, including font, number, alignment, and border.
By using these editing and formatting shortcuts, you can work more efficiently in Excel and save time.
Working with Data in Excel
When it comes to working with data in Excel, there are plenty of shortcuts that can help you save time and increase your productivity. In this section, we will cover some of the most useful data entry and manipulation shortcuts in Excel 2010.
Data Entry Shortcuts
Excel has several shortcuts that make data entry faster and more efficient. Here are a few of the most useful ones:
- Ctrl+; – Inserts the current date in the active cell
- Ctrl+Shift+: – Inserts the current time in the active cell
- Ctrl+, – Selects the current region around the active cell
- Ctrl+Shift+A – Inserts the argument names and parentheses for a function in the formula bar
- Ctrl+R – Copies the contents of the leftmost cell in a selected range to the right
- Ctrl+L – Copies the contents of the topmost cell in a selected range downwards
Data Manipulation Shortcuts
Excel also has several shortcuts that make it easy to manipulate data. Here are a few of the most useful ones:
- Ctrl+E – Flash Fill: Automatically fills values in a column based on patterns it recognizes in the data you have already entered
- Ctrl+Shift+L – Turns Autofilter on or off
- Ctrl+; – Enters the current date in the selected cell(s)
- Ctrl+Shift+: – Enters the current time in the selected cell(s)
- List Sum – Quickly adds up a list of numbers by selecting the range and pressing Alt+=
- Formula – Quickly creates a formula by selecting the range and typing the formula in the formula bar
Table
Here’s a table that summarizes some of the most useful data entry and manipulation shortcuts in Excel 2010:
| Shortcut | Function |
|---|---|
| Ctrl+; | Inserts the current date |
| Ctrl+Shift+: | Inserts the current time |
| Ctrl+, | Selects the current region |
| Ctrl+Shift+A | Inserts function argument names |
| Ctrl+R | Copies contents to the right |
| Ctrl+L | Copies contents downwards |
| Ctrl+E | Flash Fill |
| Ctrl+Shift+L | Toggles Autofilter |
| Alt+= | Quickly adds up a list of numbers |
| Formula | Quickly creates a formula |
Managing Worksheets and Workbooks in Excel
When working with Excel, managing worksheets and workbooks is an essential part of the process. Here are some useful shortcuts to help you manage your worksheets and workbooks more efficiently.
Workbook Management Shortcuts
| Shortcut | Functionality |
|---|---|
| Ctrl+N | Create a new blank workbook |
| Ctrl+O | Open an existing workbook |
| Ctrl+S | Save the current workbook |
| Ctrl+W | Close the current workbook |
| Ctrl+F4 | Close the selected workbook window |
| Ctrl+Tab | Switch between open workbooks |
| Ctrl+F6 | Switch between open workbooks or windows |
| Ctrl+Shift+N | Create a new folder in the Open dialog box |
Worksheet Management Shortcuts
| Shortcut | Functionality |
|---|---|
| Ctrl+Page Up | Move to the previous worksheet |
| Ctrl+Page Down | Move to the next worksheet |
| Shift+F11 | Insert a new worksheet |
| Ctrl+M | Create a new window for the selected worksheet |
| Ctrl+P | Print the current worksheet |
| Ctrl+G | Display the Go To dialog box |
| Ctrl+H | Display the Find and Replace dialog box |
| Ctrl+9 | Hide the current row |
| Ctrl+0 | Hide the current column |
| Ctrl+Shift+( | Unhide any hidden rows within the selection |
| Ctrl+Shift+) | Unhide any hidden columns within the selection |
Table
Here is a table summarizing some of the most useful worksheet and workbook management shortcuts:
| Shortcut | Functionality |
|---|---|
| Ctrl+N | Create a new blank workbook |
| Ctrl+O | Open an existing workbook |
| Ctrl+S | Save the current workbook |
| Ctrl+W | Close the current workbook |
| Ctrl+F4 | Close the selected workbook window |
| Ctrl+Tab | Switch between open workbooks |
| Ctrl+F6 | Switch between open workbooks or windows |
| Ctrl+Shift+N | Create a new folder in the Open dialog box |
| Ctrl+Page Up | Move to the previous worksheet |
| Ctrl+Page Down | Move to the next worksheet |
| Shift+F11 | Insert a new worksheet |
| Ctrl+M | Create a new window for the selected worksheet |
| Ctrl+P | Print the current worksheet |
| Ctrl+G | Display the Go To dialog box |
| Ctrl+H | Display the Find and Replace dialog box |
| Ctrl+9 | Hide the current row |
| Ctrl+0 | Hide the current column |
| Ctrl+Shift+( | Unhide any hidden rows within the selection |
| Ctrl+Shift+) | Unhide any hidden columns within the selection |
Using these shortcuts can help you manage your worksheets and workbooks more efficiently, saving you time and effort.
