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
- 12256 reads
Recent comments
5 years 36 weeks ago
6 years 22 weeks ago
6 years 34 weeks ago
6 years 37 weeks ago
6 years 38 weeks ago
6 years 43 weeks ago
6 years 52 weeks ago
7 years 2 days ago
7 years 3 days ago
7 years 3 days ago