How Copilot Learns Your Preferences in Excel

Microsoft is making Copilot in Excel more useful by allowing it to remember how you like your spreadsheets formatted. You can set preferences for things like currency formatting, report layouts, naming conventions, and formulas. And Copilot will apply those rules automatically in future. That means less time repeating the same instructions and more time focusing on the information.

There’s also a new feature that allows workbook-specific rules to travel with a spreadsheet when it’s shared. This helps teams stay consistent, as Copilot can follow the same formatting and reporting standards regardless of who is working on the file.

What This Means for Your Business

If you use Excel regularly, you know the frustrating part isn’t the analysis. It’s getting your information into the format you want. Maybe you always present figures in a certain way. Perhaps reports need specific headings. Maybe your team uses particular formulas for recurring calculations.

Copilot now handles these repetitive tasks. While AI-generated results should still be checked carefully, especially when dealing with financial or business data, this update removes a lot of the repetitive work that comes with managing spreadsheets. That frees up time for actual analysis and decision-making.

SquarePlanIT can help you get that clarity. Get in touch today.

Next Steps

Are you looking for a new IT service provider? Check out our free guide that explains how to choose your next IT service provider for some quick tips to get you started! Schedule a free 15-minute discovery call with someone from our team to see if we’re a good mutual fit!

Subscribe today.

Get the latest tech and productivity tips delivered directly to your inbox!

Not sure where to start?

Choosing a technology provider isn’t always easy, and it can be a substantial commitment. Here’s our guide that covers the 5 things to look for in your next IT service provider.