9. Excel Tips - Change values on multiple sheets

Nick's picture

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: