Setting the Same View on all Sheets

[khchang74]

I have a Workbook that has around 140 sheets in it. I would like to globally set every sheet's zoom factor starting cell to be the same, so that when you open the file and go from sheet to sheet, you start with the same view with the first cell (A1) being selected, and at the same zoom factor. What's the easiest way to do this?

 

[Ed in Aus]

go down to the bottom right click on one of the sheets --> select all sheets then go to the cell you want and adjust the zoom. finally back to the bottom unselect sheets and save.