9. Excel Tips - Change values on multiple sheets

Not a lot of people know this trick, but it can be a massive time saver if you have the same information on lots of sheets, and you want to change it.
It's simple when you know how !
Step1:
Select all the sheets that you want to enter a value into or change a value on. You can do this by holding down the CTRL key
Step2:
Simply type the value in the cell you want on the active sheet, and as if by magic, it appears on all the other sheets.
Nick
Training Video on how to Change Values on Multiple sheets:
»
- Nick's blog
- Login or register to post comments
- 12386 reads
Recent comments
5 years 50 weeks ago
6 years 36 weeks ago
6 years 47 weeks ago
6 years 50 weeks ago
6 years 51 weeks ago
7 years 5 weeks ago
7 years 13 weeks ago
7 years 13 weeks ago
7 years 13 weeks ago
7 years 13 weeks ago