![alt shift enter in excel alt shift enter in excel](https://cdn.ablebits.com/_img-blog/new-line/add-carriage-return-formula.png)
If you select the empty column, to the right, ( Apples + Pears column), you will get a sum of Apples + Pairs. But why? If you select just the cells you would like to sum up, Apples column in our example, and press ALT + =, only that column will be summed up with the result written in the first empty cell underneath the data selected.
![alt shift enter in excel alt shift enter in excel](https://nira.com/wp-content/uploads/2020/11/image8-8-1024x425.png)
Let’s take a look at the contents of cells (look inside the formula bar) B15, C15, and D15 to see whether we actually got the SUM function. Now simply press ALT + = and there it is. Note: you can select data without headers as well. But whatever way you chose, there is a faster way to SUM your data in Excel.įirst, let’s select the data we would like to sum up. You could also just start typing with the “=” (equal) sign and continue typing SUM afterward to call the function faster. Question: How can we SUM this data quickly, in Excel?ĭo you know the fx button near the formula bar? That good old click on the formula bar and then scrolling to find SUM. IF you find it easier to learn through Videos, here is a link to the Excel Olympics YouTube video explaining all the shortcuts described in this post. Let’s look at some great things you can do using Alt-based shortcuts in Excel. But if you don’t, you are missing some great shortcuts.
![alt shift enter in excel alt shift enter in excel](https://www.spreadsheetweb.com/wp-content/uploads/2019/11/Control-Shift-Enter-CSE-in-Excel-02.png)
But very rarely do users use shortcuts with the Alt key. Sometimes we will even use some that use Ctrl and Shift keys. I guess we all use our fair amount of Excel shortcuts that start with Ctrl.