Change the default zoom % when I open a new workbook, add a sheet, or even just open a workbook I already changed the % in
I'm using a work laptop so some options may be limited. I have Excel 365 on desktop.
A couple weeks ago I had my laptop reimaged (basically returned to original settings). One setting I did not expect to change was how excel behaved. My vision is a bit crap so I view documents at 120%. Somehow this was the default before the reimaging, but now the default is 100%. Even on workbooks I've worked on for ages now open at 100% and I have to increase it.
AI gave me instructions to create a new template, which I did, but that didn't work. It also said if I increased the zoom to 120 the worksheet would open later at 120 which of course wasn't true.
Any other options? Should I ask my IT department about it? Do I have to just live with this now??
[edit: a macro is not an option]
thanks!!
AI's instructions:
- Open a blank workbook.
- Set the zoom to 120%
- View tab → Zoom → 120%
- Make any other defaults you want.
- Save the workbook as an Excel template:
- File → Save As
- File type: Excel Template (*.xltx)
- Name it:
Book.xltx
- Save it in Excel’s startup folder:
[link] [comments]
Want to read more?
Check out the full article on the original site