Excel Shortcuts For PC and Mac is very important for you and your business, whether you run an organization or work for an organization that uses Excel
For that, in this article we have compiled various important shortcuts for you as follows:
- The importance of excel shortcuts
- Excel general shortcuts
- Excel navigation shortcuts
- Excel format Shortcuts
- Excel shortcuts for selecting rows and columns
See: Microsoft Excel Tips
The importance of excel shortcuts
Microsoft Excel is a powerful data visualization and analysis program that uses spreadsheets to store, organize, and keep track of data sets using formulas and functions.
Excel is used by marketers, accountants, data analysts, and other specialists.
Many users use Microsoft Excel every day, whether it is to create a chart, analyze data, or run a report to present at the next team meeting.
Generating such reports in Excel takes a long enough time. How can we spend less time navigating, formatting, choosing, and entering formulas for our data? Wouldn't it be great if there were keyboard shortcuts that could help us do our work faster?
All of these shortcuts can be accessed on PCs and Macs, so we've included both types below where possible.
Important:
For Mac users: To access the F keys (F1 - F12), you must hold down the Fn key before pressing any F key—unless you have enabled these keys as standard function keys.
Excel general shortcuts
Here are some of the time-saving and premium shortcuts to manage the size of your Excel worksheet:
These shortcuts can help you in general and basically while using Excel.
F2 | Move to end of text in cell |
Alt + Shift + F1 | Insert new worksheet |
Ctrl + Shift + ($) | Apply currency format to numbers |
Ctrl + Shift + (!) | Apply number format with 2 decimal places |
Alt + Enter | Add line break in cell |
Shift + Space bar | Selects row |
Ctrl + (-) | Delete cell deletion (Check Follow) |
Ctrl + (-) + L | Shifts cells left |
Ctrl + (-) + U | Shift cells up |
Alt + W + F | Freeze panes (Check Follow) |
Alt + W + F + R | Freeze top row |
Alt + W + F + C | Freeze first column |
Alt + W + F + F | Freeze a certain number of rows. Also Unfreeze. (If Freeze has been |
Alt + H + B | Add border. Options |
Alt + H + B + O | Bottom border |
Alt + H + B + A | All borders |
Alt + H + B + N | No border |
Alt + H + B + S | Outside borders |
Alt + H + B + H | Thick bottom border |
Alt + H + B + B | Double bottom border |
Ctrl + Space bar | Selects column |
Alt + ( =) | Auto-sum numbers |
Ctrl + (‘) | Copy formula from above |
Ctrl + 9 | Hides row |
Ctrl + 0 | Hides column |
Ctrl + Shift + 9 | Unhides row |
Ctrl + Shift + 0 | Unhides column |
Alt + H + D + R | Delete row |
Alt + H + D + C | Delete column |
Ctrl + Shift + (+) | Insert. Options (Check Follow) |
Ctrl + Shift + “ + ” + I | Shifts cells right to insert cell |
Ctrl + Shift + “ + ” + D | Shift cells down to insert cell |
Ctrl + Shift + (+) + R | Inserts entire row |
Ctrl + Shift + (+) + C | Inserts entire column |
Ctrl + Shift + (%) | Apply percentage format to numbers |
F9 | Recalculate all workbooks |
Alt + H + H | Choose fill color |
Excel navigation shortcuts
These simple shortcuts can help you navigate workbooks, sheets, rows, and columns:
| Shortcuts | PC | Mac |
| Jump to the top of a column | CTRL + ↑ | Command + ↓ |
| Jump to the corner of a selection | CTRL + . | CTRL + . |
| Close the active workbook window | CTRL + w | Command + W |
| Switch to previous workbook window | CTRL + Shift + F6 | Command + Shift + F6 |
| Switch to the next open worksheet | None | CTRL + Tab |
| Start a new chart sheet | F11 | F11 |
| Insert a new sheet | Shift + F11 | Shift + F11 |
| Repeat the last action | CTRL + Y | Command + Y |
| Fill selected cell with the content in the cell above selected cell | CTRL + D | CTRL + D |
| Fill selected cell with the content in the cell to the left of selected cell | CTRL + R | CTRL + R |
| Move up through a selection | Shift + Enter | Shift + Enter |
Excel format Shortcuts
Here are a few shortcuts that to help you easily format your cells:
| Shortcuts | PC | Mac |
Note:
The Excel strikethrough shortcut will strike a line through the middle of the value or text in a highlighted cell.
To strike a line through a cell, highlight the cell and press CTRL + 5 on your keyboard.
To find and replace values CTRL + F (PC) And Command + F (Mac)
Excel shortcuts for selecting rows and columns
Save yourself manual drag and pick rows and columns with these handy keyboard tricks:
| Shortcuts | PC | Mac |
| Expand the selection by one cell either upward (↑) or downward (↓) | Shift + ↑ [or] Shift + ↓ | Shift + ↑ [or] Shift + ↓ |
| Expand the selection to the last non-empty cell | CTRL + Shift + Arrow Key | Command + Shift + Arrow Key |
| Select entire column | CTRL + spacebar | CTRL + spacebar |
| Select entire row | Shift + spacebar | Shift + spacebar |
| Select entire sheet | CTRL + A | Command + A |
| Select only the visible cells in the current selection | Alt + ; | Command + Shift + z |
Note:
The insert row shortcut in Excel will create a new row below a highlighted cell. To insert a new row, highlight a cell or entire row and press CTRL + Shift + + on your keyword, literally pressing the plus sign after Shift.
This will open a small window of options where you can insert a new row or column.