8 Useful Keyboard Shortcuts for Excel

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

Below you find some of my favorite shortcuts for Excel. It makes simple tasks even easier to perform. Work smarter, not harder 😉


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 leve me a comment

I hope you found above information relevant and informativ. If you have any questions or feedback, please leave me a comment below. More Excel keyboard shorcuts

About the author:
I am an IT Professional that has this blog as a hobby project in my spare time. I have been in the IT business since 1996 and want to share some of the thing I have picked up over the years, with people who visit this blog.

>>Subscribe to my Newsletter<<

One Response to 8 Useful Keyboard Shortcuts for Excel

  1. Rob Wilson says:

    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 🙂

Leave a Reply

Your email address will not be published. Required fields are marked *