Keyboard shortcuts can be a big time saver if you do similar tasks over and over again. In this post I will introduce you to some of my favorite Excel shortcuts.
Keyboard shortcuts for Excel
If you use Microsoft Excel on a regular basis you might like these Excel shortcuts I am about to present for you. I will show you some of my favorite shortcuts for Excel. It makes simple tasks even easier and faster to perform. Work smarter, not harder đ
8 Great shortcuts for Excel
Below you find 8 easy shortcut that every Excel user should now about:
1. Edit selected cell
No need to reach out for the mouse when you want to edit a cell. Just press F2 and you can change the value of a cell.
2. Insert Total Sum
Select the cells you want to sum up, then select the cell you want the result to be displayed and press Alt + =
3. Select Entire Row
Select the entire row of a sheet by pressing: Shift + Space
4. Select Entire Column
Select the entire column of a sheet by pressing: Ctrl + Space
5. Hide a Row
Hide a row in a sheet by pressing: Ctrl + 9
6. Hide a Column
Hide a column of a sheet by pressing: Ctrl + 0
7. Start a New Line in a Cell
Sometimes you need to add an extra line to a cell. If you just press enter like you normally would to the curser drops to the column below. Instead press Alt + Enter. That will allow you to enter in an additional line in the same cell
8. Autosum selected cells
Sum selected cells with this simple shortcut by pressing: Alt + = The combination works on both columns and rows.
Please leave me a comment
I hope you found above information relevant and informative. If you have any questions or feedback, please leave me a comment below. More Excel keyboard shortcuts
I think another handy feature in Excel is the replicate option at the bottom right of each cell.
I like to highlight whole rows and they replicate, as well as link to the new corresponding rows.
Super time saving, just like the shortcuts đ
Thomas, thank you for such nice article. i was searching google for excel shortcut to autosum and i came to this page.
it helped me a lot. My report on moringa oleifera would be ready.
Nice blog post about useful keyboard shortcut used for excel. Nice blog post keep the good work going.