How to enter formula in multiple cells in Excel at the same time.
- For updated video clips in structured Excel courses with practical example files, have a look at our MS Excel online training courses . You can even try the Free MS Excel tips and tricks course.
- To see if this video matches your skill level (see the suggested skill score below) do our free MS Excel skills assessment.
- If you are based in South Africa look at the live courses we offer in Johannesburg and Cape Town.
Enter formula in multiple cells
By holding the control key down while you push enter, you are able to enter formula in multiple cells be they number or text at the same time. The easiest way to explain is to show you. So for example if I decide I’m going to highlight say these and I will highlight that. So what I’ve now done is highlighted about 10 cells. The active cell is shown here. So if I start typing I’ll say equals that plus that. If in this situation I push “enter” you’ll see what happens is the sum happens there and all that happens is the cursor moves one way across. I am just going to undo it. If however I push equals that plus that but before I push enter I hold the control key down, watch what happens in all these cells I’ve highlighted. I push enter, so I’m holding control and push enter, you’ll see every single cell that was highlighted now contains that formula of adding the two cells above it together. This is a very useful way of performing the same function in multiple cells