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
- 12233 reads
Recent comments
5 years 34 weeks ago
6 years 20 weeks ago
6 years 32 weeks ago
6 years 35 weeks ago
6 years 36 weeks ago
6 years 42 weeks ago
6 years 50 weeks ago
6 years 50 weeks ago
6 years 50 weeks ago
6 years 50 weeks ago