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 !
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
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.
Training Video on how to Change Values on Multiple sheets: