2 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

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:
submitted by /u/Designer_Signature35
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#Excel compatibility
#Excel alternatives
#rows.com
#natural language processing for spreadsheets
#generative AI for data analysis
#financial modeling with spreadsheets
#no-code spreadsheet solutions
#Excel 365
#zoom
#workbook
#default zoom
#120%
#100%
#template
#worksheet
#Excel template (*.xltx)
#settings
#desktop
#Save As