Quickly enter a formula in multiple cells
Entering the same formula or value into multiple cells can be time consuming and boring. Most people, if they want to enter the same formula into a row or column of data, will enter the formula in the first cell, then copy and paste it into the rest of the cells where they need the formula. This lesson shows you the quick way to do it.
There is a quicker way to do this:
- Select the cells where you want the formula to go
- Type the formula into the cell (but don't press ENTER just yet)
- Hold the CTRL key down, then press ENTER
The formula will be entered into all the cells you had selected, taking account of any relative references you had in the original formula (i.e. C3 will become C4 in the next cell down, etc)
This also works if y ou want to quickly enter a value into a range of cells. Simply select all the cells, type the value into the first cell, then press CTRL+ENTER.
About Us
Fiveminutelessons.com is a website dedicated to providing free training on a range of subjects. We're starting with lessons on Microsoft Word, Excel and PowerPoint but have plans to add other subjects over time such as Adobe Photoshop and Microsoft Project as well as non-software subjects.
We're based in Tauranga, New Zealand but have years of experience in the UK, USA and Ireland working in the training industry with a range of clients from small businesses to blue chip corporates.
Commercial Services
As well as the free training you get at www.fiveminutelessons.com, we also offer a range of commercial services to help you with your training and online learning requirements including:
- Private labelling
- Courseware development
- e-learning development
- Corporate subscriptions
- Learning consultancy services
- Documentation and user guide development
- Development of innovative corporate learning environments
We offer these services for Microsoft Word, Excel and PowerPoint, as well as a range of other popular software applications. We can also assist with documentation and courseware development for custom or in-house software packages.
Contact us now to find out more about our learning consultancy and courseware development services