FAO Excel Gurus

[Ricochet J]

I have 36 worksheets in file.xlsx. Except from the different data each worksheet contains, they're all in exactly the same format.

Say I wanted to do (A1+A2)/A3 for all the worksheets, how do I do this?
Say I wanted to highlight cell A4 for all the worksheets, how do I do this?

Thank you for your help!

 

[muon]

You can select multiple sheets using ctrl across the bottom. Then if you edit a cell, it will replace the cell in all those sheets.

 

[Ricochet J]

Amazing. Thank you, I didn't know that.

I usually do all my data type stuff in Fortran. I'm a noob when using Excel!

 

[wonko]

I've learnt something new too - thanks