If you’re like most people, you probably spend a lot of time working in Microsoft Excel. And if you’re like most people, you probably don’t know all of the shortcuts that can make your life a lot easier. Here are 15 lower case shortcuts that will help you work faster and more efficiently in Excel.
1. Ctrl + s – Save your workbook
2. Ctrl + c – Copy selected cells
3. Ctrl + v – Paste copied cells
4. Ctrl + z – Undo your last action
5. Ctrl + y – Redo your last undone action
6. Ctrl + b – Bold selected cells
7. Ctrl + i – Italicize selected cells
8. Ctrl + u – Underline selected cells
9. Ctrl + 5 – Strike through selected cells
10. Ctrl + 1 – Format cells
11. Ctrl + 2 – Format as number
12. Ctrl + 3 – Format as currency
13. Ctrl + 4 – Format as percentage
14. Ctrl + 6 – Format as date
15. Ctrl + 7 – Format as time
These are just a few of the many lower case shortcuts that can make your life easier when working in Excel. For a complete list of shortcuts, consult the Excel help file or online help.
Excel is a powerful tool that can help you manage and analyze data with ease. However, navigating through the software can be time-consuming, especially if you’re not familiar with the shortcuts. In this article, we’ll be discussing 15 lower case Excel shortcuts that will make your life easier. These shortcuts will help you save time and increase your productivity when working with Excel.
1. ctrl + a
The first shortcut on our list is ctrl + a. This shortcut selects all the cells in the current worksheet. This is useful when you want to copy or format all the cells in the worksheet.
2. ctrl + b
The second shortcut on our list is ctrl + b. This shortcut applies bold formatting to the selected cells. This is useful when you want to highlight important data in your worksheet.
3. ctrl + c
The third shortcut on our list is ctrl + c. This shortcut copies the selected cells. This is useful when you want to duplicate data in your worksheet.
4. ctrl + d
The fourth shortcut on our list is ctrl + d. This shortcut fills the selected cells with the contents of the cell above. This is useful when you want to quickly fill a column or row with the same data.
5. ctrl + e
The fifth shortcut on our list is ctrl + e. This shortcut activates the search box. This is useful when you want to quickly find a specific value in your worksheet.
6. ctrl + f
The sixth shortcut on our list is ctrl + f. This shortcut opens the find and replace dialog box. This is useful when you want to replace a specific value in your worksheet.
7. ctrl + g
The seventh shortcut on our list is ctrl + g. This shortcut opens the go to dialog box. This is useful when you want to quickly navigate to a specific cell or range of cells in your worksheet.
8. ctrl + h
The eighth shortcut on our list is ctrl + h. This shortcut opens the find and replace dialog box with the replace tab selected. This is useful when you want to replace a specific value in your worksheet.
9. ctrl + i
The ninth shortcut on our list is ctrl + i. This shortcut applies italic formatting to the selected cells. This is useful when you want to emphasize certain data in your worksheet.
10. ctrl + k
The tenth shortcut on our list is ctrl + k. This shortcut opens the insert hyperlink dialog box. This is useful when you want to add a hyperlink to your worksheet.
11. ctrl + n
The eleventh shortcut on our list is ctrl + n. This shortcut creates a new workbook. This is useful when you want to start a new project in Excel.
12. ctrl + o
The twelfth shortcut on our list is ctrl + o. This shortcut opens an existing workbook. This is useful when you want to continue working on a previous project in Excel.
13. ctrl + p
The thirteenth shortcut on our list is ctrl + p. This shortcut opens the print dialog box. This is useful when you want to print your worksheet.
14. ctrl + s
The fourteenth shortcut on our list is ctrl + s. This shortcut saves the current workbook. This is useful when you want to save your progress in Excel.
15. ctrl + z
The fifteenth shortcut on our list is ctrl + z. This shortcut undoes the last action. This is useful when you make a mistake in your worksheet and want to undo it.
These are just a few of the many shortcuts available in Excel. By using these shortcuts, you can save time and increase your productivity when working with Excel. Try incorporating these shortcuts into your workflow and see how much time you can save!