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

Our take

If you’re facing challenges with Excel 365 reverting to a 100% zoom on your work laptop, there are a few steps you can take to address this issue. While you've already tried creating a template, it’s important to ensure it's saved correctly in Excel’s startup folder. If this doesn’t resolve the problem, consider reaching out to your IT department for further assistance. Your visual comfort matters, and exploring options like these will help you manage your spreadsheets more effectively.

In a recent discussion, a user expressed frustration over Excel's default zoom settings reverting to 100% after a laptop reimaging. This seemingly minor issue reflects a deeper concern shared by many Excel users, particularly those who rely on specific settings for accessibility and productivity. The user's challenge—having to manually adjust zoom levels for visibility—highlights the nuances of user experience in spreadsheet applications. It’s a reminder that even small changes in settings can impact daily workflows significantly, especially for those who may have visual impairments or simply prefer a larger view for better clarity. This resonates with the ongoing discourse around user-centric design in tools like Excel, where customization and accessibility should be at the forefront.

The situation raises an important question: how do we balance the flexibility of using powerful tools like Excel with the need for consistent settings that align with individual user preferences? The user in this case had previously established a comfortable workflow by setting their zoom level to 120%. Yet, after the reimaging process, they found themselves not only adjusting the zoom each time but also dealing with the frustration of ineffective solutions suggested by AI. While the advice to create a new template or save a default workbook is well-intended, it underscores a limitation in current software design. Many users may not have the technical background to implement these suggestions effectively or may find that they do not solve the issue completely. This scenario connects well with discussions in our community around the limitations of traditional tools, such as in our article, Huge workbook, lots of tabs & macros--should I use something other than Excel?.

Moreover, the advent of AI in providing user support—while promising—also shows its limitations. Users may often need more than just step-by-step instructions; they seek solutions that feel intuitive and accommodating to their unique needs. The mention of macro options not being viable adds another layer of complexity to the issue. It raises an important point about the accessibility of advanced features in Excel and the need for more straightforward, user-friendly alternatives. For many, the absence of macros can mean a reliance on features that may not deliver the desired results, which can be particularly frustrating when time is of the essence. This reflects a larger trend in software development: the need to ensure that tools are not just powerful but also genuinely user-friendly for all.

Looking ahead, it will be crucial for software developers and IT departments to prioritize user feedback in refining their products. As remote work continues to shape how we utilize technology, ensuring that tools are adaptable to individual needs will enhance productivity and user satisfaction. Organizations should consider implementing more robust support systems that empower users to customize their experiences effectively. The question remains: how can we foster a more accommodating environment in spreadsheet applications, ensuring that all users, regardless of technical expertise, can thrive? The evolution of spreadsheet technology may depend on our ability to answer that question, moving us towards a more inclusive future in data management.

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]

Read on the original site

Open the publisher's page for the full experience

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