[rank_math_breadcrumb]
logo-v-light

Our Service

15 Excel Shortcuts That Will Help You Get Your Work Done Faster

If you’re like most people, you probably use Microsoft Excel on a daily basis. Whether you’re tracking your personal finances or managing a business budget, Excel is a powerful tool that can save you time and help you work more efficiently.

But did you know that there are a number of shortcuts that can help you get your work done even faster? In this article, we’ll share 15 of our favorite Excel shortcuts that will help you speed up your work and get more done in less time.

1. Ctrl + N: Create a new workbook

If you need to start a new Excel workbook from scratch, simply press Ctrl + N on your keyboard. This shortcut will create a new, blank workbook for you to work in.

2. Ctrl + O: Open an existing workbook

If you need to open an existing Excel workbook, press Ctrl + O on your keyboard. This will open the “Open” dialog box, where you can browse for the file you want to open.

3. Ctrl + S: Save your workbook

To save your Excel workbook, simply press Ctrl + S on your keyboard. This shortcut will save your workbook in its current location.

4. Ctrl + F: Find a value in your workbook

If you need to find a specific value in your Excel workbook, press Ctrl + F on your keyboard. This will open the “Find” dialog box, where you can enter the value you’re looking for.

5. Ctrl + H: Replace a value in your workbook

If you need to replace a value in your Excel workbook, press Ctrl + H on your keyboard. This will open the “Replace” dialog box, where you can enter the value you want to replace and the value you want to replace it with.

6. Ctrl + P: Print your workbook

To print your Excel workbook, press Ctrl + P on your keyboard. This will open the “Print” dialog box, where you can select your printer and choose your print settings.

7. Ctrl + Z: Undo your last action

If you need to undo your last action in Excel, press Ctrl + Z on your keyboard. This shortcut will undo your last change, whether it’s typing in a cell or formatting a worksheet.

8. Ctrl + Y: Redo your last action

If you need to redo your last action in Excel, press Ctrl + Y on your keyboard. This shortcut will redo your last change, whether it’s typing in a cell or formatting a worksheet.

9. Ctrl + A: Select all cells in a worksheet

If you need to select all cells in an Excel worksheet, press Ctrl + A on your keyboard. This shortcut will select all cells in the active worksheet.

10. Ctrl + B: Bold selected cells

To bold the contents of selected cells, press Ctrl + B on your keyboard. This shortcut will bold the contents of all selected cells.

11. Ctrl + I: Italicize selected cells

To italicize the contents of selected cells, press Ctrl + I on your keyboard. This shortcut will italicize the contents of all selected cells.

12. Ctrl + U: Underline selected cells

To underline the contents of selected cells, press Ctrl + U on your keyboard. This shortcut will underline the contents of all selected cells.

13. Ctrl + 5: Strike through selected cells

To strike through the contents of selected cells, press Ctrl + 5 on your keyboard. This shortcut will strike through the contents of all selected cells.

14. Ctrl + 1: Format selected cells

To format selected cells, press Ctrl + 1 on your keyboard. This shortcut will open the “Format Cells” dialog box, where you can select the desired format for your cells.

15. Ctrl + Shift + &: Insert a new worksheet

If you need to insert a new worksheet into your Excel workbook, press Ctrl + Shift + & on your keyboard. This shortcut will insert a new, blank worksheet into your workbook.

We hope you found these Excel shortcuts helpful! If you know of any other shortcuts that can help people work faster in Excel, please share them in the comments below.

Excel is a powerful tool that can help you manage and analyze data quickly and efficiently. However, if you’re not using shortcuts, you’re missing out on some of the best features of the program. In this article, we’ll cover 15 Excel shortcuts that will help you get your work done faster.

1. Ctrl + C and Ctrl + V

Copying and pasting is a basic function in Excel, but using the keyboard shortcuts can save you a lot of time. Use Ctrl + C to copy a cell or range of cells, and Ctrl + V to paste it where you want it.

2. Ctrl + Z

If you make a mistake, don’t worry. Just use Ctrl + Z to undo your last action. This can be a lifesaver if you accidentally delete something important.

3. Ctrl + F

Need to find something in your spreadsheet? Use Ctrl + F to bring up the Find and Replace dialog box. This can save you a lot of time if you’re looking for a specific piece of information.

4. Ctrl + Home and Ctrl + End

If you have a large spreadsheet, it can be difficult to navigate to the beginning or end of it. Use Ctrl + Home to go to the top of the sheet, and Ctrl + End to go to the bottom.

5. Ctrl + Shift + L

If you have a table in your spreadsheet, you can use Ctrl + Shift + L to turn it into a formatted table. This can make it easier to sort and filter your data.

6. Ctrl + Shift + Arrow Keys

If you want to select a large range of cells quickly, use Ctrl + Shift + Arrow Keys. This will select all the cells in the direction you choose.

7. Ctrl + ;

If you need to enter the current date into a cell, use Ctrl + ;. This will automatically enter today’s date into the cell.

8. Ctrl + Shift + :

If you need to enter the current time into a cell, use Ctrl + Shift + :. This will automatically enter the current time into the cell.

9. F2

If you need to edit a cell, just press F2. This will put the cell into edit mode, so you can make changes.

10. Alt + Enter

If you need to enter a line break within a cell, use Alt + Enter. This will create a new line within the cell.

11. Ctrl + Shift + $

If you need to format a cell as currency, use Ctrl + Shift + $. This will format the cell as currency with two decimal places.

12. Ctrl + Shift + %

If you need to format a cell as a percentage, use Ctrl + Shift + %. This will format the cell as a percentage with two decimal places.

13. Ctrl + Shift + #

If you need to format a cell as a date, use Ctrl + Shift + #. This will format the cell as a date with the default date format.

14. Ctrl + Shift + @

If you need to format a cell as a time, use Ctrl + Shift + @. This will format the cell as a time with the default time format.

15. Ctrl + Shift + *

If you need to select the current region (the area around the active cell that contains data), use Ctrl + Shift + *. This can be useful if you need to apply a formula or formatting to a specific area of your spreadsheet.

By using these shortcuts, you can save time and work more efficiently in Excel. Try them out and see how much time you can save!

Related

Did you find this article useful?

Share it with your friends or colleagues

About Aepoch Advisors

We are a boutique accounting and consulting firm servicing international businesses operating in China. We offers book keeping and business advisory service. We also help our clients select and implement SAAS business applications
 
Cloud technology significantly reduces cost foreign companies traditionally spent on tax compliance and ERP systems. Our cloud professionals can help with streamlining your management and controling structure, as well as advising you on how to reduce risks and maximize profits with software purposely built for Chinese business. Contact us today to learn more about our services.