Discover the ultimate collection of Excel shortcuts that will revolutionize your workflow. Below is a comprehensive guide to mastering Excel with ease.
| No. | SHORTCUT | FUNCTION |
|---|---|---|
| 1 | Ctrl + F | Quickly find a word, phrase, or number. |
| 3 | Ctrl + H | Find and replace any phrase. |
| 4 | Ctrl + O | Open saved files on your computer. |
| 5 | Ctrl + N | Open a new Excel spreadsheet. |
| 6 | Ctrl + X | Cut |
| 7 | Ctrl + W | Close the current worksheet. |
| 8 | Ctrl + D | Copy content from the row above to the row below by placing the cursor in the cell below and pressing this shortcut. |
| 9 | Ctrl + A | Select all, similar to selecting all text in Word. |
| 10 | Ctrl + Z | Undo the last action to revert to the previous state. |
| 11 | Ctrl + (-) | Delete selected cells, rows, or columns. |
| 12 | Ctrl + L hoặc Ctrl + T | Open the table creation dialog box. |
| 13 | Ctrl + Page up (Page down) | Quickly navigate between sheets in a workbook. |
| 14 | Ctrl + U hoặc Ctrl + 4 | Underline text or remove underlining. |
| 15 | Ctrl + R | Copy content from the cell on the left to the cell on the right. |
| 16 | Ctrl + Enter | Fill the selected range with the current entry. |
| 17 | Ctrl + Delete | Delete all text in a row. |
| 18 | Ctrl + Q | Display Quick Analysis options for selected data. |
| 19 | Ctrl + Y | Redo the last action or command. |
| 20 | Ctrl + B hoặc Ctrl + 2 | Bold or unbold selected text. |
| 21 | Ctrl + I hoặc Ctrl + 3 | Italicize or remove italics from selected text. |
| 22 | Ctrl + U hoặc Ctrl + 4 | Underline or remove underlining from selected text. |
| 23 | Ctrl + 5 | Strikethrough or remove strikethrough from selected text. |
| 24 | Ctrl + 9 | Hide rows in a spreadsheet. |
| 25 | Ctrl + 0 | Hide columns in a spreadsheet. |
| 26 | Ctrl + 8 | Hide/show gridlines. |
| 27 | Ctrl + (;) | Display the current date and time in the selected cell. |
| 28 | Ctrl + 1 | Open the Format Cells dialog box. |
| 29 | Ctrl + K | Insert a hyperlink. |
| 30 | Ctrl + (’) | Similar to Ctrl + D. |
| 31 | Ctrl + Spacebar | Select an entire column in a spreadsheet. |
| 32 | Ctrl + End | Move the cursor to the end of the text in the formula bar. |
| 33 | Ctrl + Shift + (#) | Format date, month, and year. |
| 34 | Ctrl + Shift + (&) | Add borders to selected cells. |
| 35 | Ctrl + Shift + (-) | Remove borders from selected cells. |
| 36 | Ctrl + Shift + (~) | Apply General number format. |
| 37 | Ctrl + Shift + 0 | Unhide columns. |
| 38 | Ctrl + Alt + 5, then Tab repeatedly | Cycle through floating shapes, such as text boxes or images. |
| 39 | Ctrl + Alt + ( ‘ ) | Copy the formula from the cell above into the current cell or formula bar. |
| 40 | Ctrl + Shift + ( _ ) | Remove outer borders from selected cells. |
| 41 | Ctrl + Shift + ( | Unhide rows, opposite of Ctrl + 9. |
| 42 | Ctrl + Shift + (:) | Display the current time in the selected cell. |
| 43 | Ctrl + Shift + (%) | Apply percentage format with no decimal places. |
| 44 | Ctrl + Shift + (+) | Insert blank cells above, below, left, or right. |
| 45 | Ctrl + Shift + Page Down | Select the current and next worksheet in a workbook. |
| 46 | Ctrl + Shift + Page Up | Select the current and previous worksheet in a workbook. |
| 47 | Ctrl + Shift + F Or Ctrl + Shift + P |
Display font, size, and color options for text formatting. |
| 48 | Ctrl + Shift + A | Insert function arguments after entering the function name in a formula. |
| 49 | Ctrl + Shift + Home | Expand the selection to the beginning of the spreadsheet. |
| 50 | Ctrl + Shift + Spacebar | Select all objects on a spreadsheet when an object is selected. |
| 51 | Ctrl + Alt + V | Open the Paste Special dialog box. |
| 52 | Ctrl + Shift + U | Expand or collapse the formula bar. |
| 53 | Ctrl + Shift + ($) | Apply Currency format with two decimal places (negative numbers in parentheses). |
| 54 | Ctrl + Shift + End | Select all text in the formula bar from the cursor position to the end. |
2. Using the Shift Key in Excel
| No. | SHORTCUT | FUNCTION |
|---|---|---|
| 1 | Shift + F10 | Open the right-click menu. |
| 2 | Shift + Tab | Move to the previous cell in Excel or the previous option in a dialog box. |
| 3 | Shift + F2 | Add or edit a comment in a cell. |
| 4 | Shift + Arrow Key | Expand the selected cell range. |
| 5 | Shift + Enter | Complete a cell entry and select the cell above. |
| 6 | Shift + Spacebar | Select an entire row in a spreadsheet. |
| 7 | Shift + F9 | Calculate the active worksheet. |
| 8 | Shift + F3 | Insert a function. |
3. Using the Alt Key in Excel
| No. | SHORTCUT | FUNCTION |
|---|---|---|
| 1 | Alt + H | Go to the HOME tab. |
| 2 | Alt + P | Go to the Page Layout tab. |
| 3 | Alt + N | Go to the INSERT tab. |
| 4 | Alt + A | Go to the DATA tab. |
| 5 | Alt + W | Go to the VIEW tab. |
| 6 | Alt + M | Go to the Formulas tab. |
| 7 | Alt + F | Open the Office Button menu. |
| 8 | Alt + R | Go to the Review tab. |
| 9 | Alt + Page Down | Move one screen to the right in Excel. |
| 10 | Alt + Page Up | Move one screen to the left in a spreadsheet. |
| 11 | Alt + F11 | Open the Microsoft Visual Basic for Applications editor. |
| 12 | Alt + Enter | Start a new line in a cell. |
| 13 | Alt + F8 | Create, run, edit, or delete a macro. |
4. Excel Shortcuts for Navigating Spreadsheets
Arrow Keys (▽◁▷△): Move up, down, left, or right in a spreadsheet.
Pg Dn/Pg Up: Move to the bottom/top of a spreadsheet.
Alt + Pg Dn/Alt + Pg Up: Move the screen right/left in a spreadsheet.
Tab/Shift + Tab: Move one cell right/left in a spreadsheet.
Home: Move to the first cell of a row in a spreadsheet.
Ctrl + Home: Move to the first cell of a spreadsheet.
Ctrl + End: Move to the last cell with content in a spreadsheet.
Ctrl + F: Open the Find and Replace dialog box (Find tab selected).
Ctrl + H: Open the Find and Replace dialog box (Replace tab selected).
Shift + F4: Repeat the last find action.
Ctrl + G (or F5): Open the ‘Go To’ dialog box.
Ctrl + ◁/Ctrl + ▷: Within a cell, move to the left or right edge of the cell.
Alt + ▽: Display the AutoComplete list.
5. Shortcuts for Working with Selected Data
Selecting Cells:
Shift + Spacebar: Select an entire row.
Ctrl + Spacebar: Select an entire column.
Ctrl + Shift + *: Select the entire region around the active cell.
Ctrl + A (or Ctrl + Shift + Spacebar): Select the entire spreadsheet (or data region).
Ctrl + Shift + Pg Up: Select the current and previous sheet in the same file.
Shift + Arrow Keys: Expand the selection from the active cell.
Ctrl + Shift + ▽/△: Select/unselect all cells from the active cell to the bottom of the column.
Shift + Pg Dn/Shift + Pg Up: Expand the selection down/up one screen.
Shift + Home: Expand the selection to the first cell of the row.
Ctrl + Shift + Home: Expand the selection to the first cell of the spreadsheet.
Ctrl + Shift + End: Expand the selection to the last used cell in the spreadsheet.
Managing Selections:
F8: Enable extended selection mode (use arrow keys to expand the selection).
Shift + F8: Add a non-adjacent range to the selection (use arrow keys to add).
Enter/Shift + Enter: Move the active cell down/up within the selected range.
Tab/Shift + Tab: Move the active cell right/left within the selected range.
Esc: Cancel the current selection.
Editing Within Cells:
Shift + ◁/Shift + ▷: Select or unselect a character to the left/right.
Ctrl + Shift + ◁/Ctrl + Shift + ▷: Select or unselect a word to the left/right.
Shift + Home/Shift + End: Select from the cursor to the start/end of the cell.
6. Excel Shortcuts for Data Formatting
Cell Formatting:
Ctrl + 1: Open the Format Cells dialog box.
Ctrl + B (or Ctrl + 2): Apply or remove bold formatting.
Ctrl + I (or Ctrl + 3): Apply or remove italic formatting.
Ctrl + U (or Ctrl + 4): Apply or remove underline formatting.
Ctrl + 5: Apply or remove strikethrough formatting.
Alt + ‘: Open the Style dialog box.
Number Formatting:
Ctrl + Shift + $: Apply Currency format with two decimal places.
Ctrl + Shift + ~: Apply General number format.
Ctrl + Shift + #: Apply Date format (day, month, year).
Ctrl + Shift + @: Apply Time format (hours, minutes, AM/PM).
Ctrl + Shift + ^: Apply Scientific number format with two decimal places.
F4: Repeat the last formatting action.
Cell Alignment:
Alt + H, A, R: Right-align cell content.
Alt + H, A, C: Center cell content.
Alt + H, A, I: Left-align cell content.
Formula Shortcuts:
=: Start a formula.
Shift + F3: Open the Insert Function dialog box.
Ctrl + A: Display function arguments after entering the function name.
Ctrl + Shift + A: Insert function arguments after entering the function name.
Shift + F3: Insert a function into a formula.
Ctrl + Shift + Enter: Enter a formula as an array formula.
F9: Calculate all worksheets in all open workbooks.
Shift + F9: Calculate the active worksheet.
Ctrl + Shift + U: Expand or collapse the formula bar.
Ctrl + ‘: Toggle between displaying cell values and formulas.
Ctrl + Pg Dn (PageDown): Move to the next sheet to the right.
Ctrl + Pg Up (PageUp): Move to the previous sheet to the left.
Ctrl + Arrow Key: Move to the edge of the current data region in the direction of the arrow.
Ctrl + Arrow Key + Shift: Select the data region to the edge in the direction of the arrow.
Double-click the fill handle: Copy a formula down to the last adjacent cell with data.
Ctrl + Shift + 1: Format cells as decimal with two places.
Ctrl + Shift + 4: Format cells as currency.
Ctrl + Shift + 5: Format cells as percentage.
F4: Toggle absolute and relative references in a formula.
&: Combine the contents of two cells (e.g., =A1&” “&B1).
Alt + =: Quickly sum a column of numbers.
Ctrl + Shift + ;: Insert the current time.
Ctrl + ;: Insert the current date.
Ctrl + ~: Toggle between displaying cell values and formulas.
With over 15 years of experience in web design and development, I’ve helped hundreds of businesses develop comprehensive website strategies for sustainable growth and profitability.
3 Revolutionary Hacks for Instantly Snapping the Perfect Phone Screenshot
In today’s fast-paced world, dominated by technology, taking screenshots on your phone has become an essential skill for any smartphone user.
Awaken Your Post-Holiday Slumber: A Guide to Getting Back on Track
The Lunar New Year is a time-honored tradition of reunion and relaxation after a long year of hard work. But, after indulging in festive cheer, we need tips and tricks to get back to work with a bang. Join us as we explore ways to re-energize and refocus post-Tet holiday.
5 Ways to Boost Your Laptop Volume Like a Pro
There are many ways to increase your laptop’s volume, from adjusting the default settings on your device to using third-party software or even customizing the volume for individual apps. If you’re looking to explore the different ways to boost your audio, this article has you covered.
