.png)
.png)
.png)
Change the currency format.
Rename the headings.
Move that column.
Format the dates correctly.
Make this report look like the one we sent last month.
If your business uses Excel regularly, you probably have certain ways you expect spreadsheets to look and behave.
The frustrating part is having to explain—or fix—those same things repeatedly.
Microsoft is working on making Copilot in Excel better at remembering those preferences.
And that could turn AI into something more useful than a tool that simply answers questions.
Microsoft has been adding Copilot features to Excel for some time.
What's interesting about this development is that Copilot can learn more about how you prefer to work.
For example, the source describes being able to tell Copilot preferences such as:
Instead of repeatedly providing the same instructions, Copilot can remember preferences and apply them to future work.
That may sound like a small improvement.
But think about how many small, repetitive spreadsheet tasks your employees perform every week.
Removing a few minutes here and there can add up quickly.
The feature becomes even more interesting when multiple employees work with the same spreadsheet.
One person formats a report one way.
Someone else changes it.
A third employee creates their own version.
Before long, you've got three variations of something that was supposed to follow the same process.
Microsoft is introducing workbook rules that can stay with the spreadsheet.
Those rules can provide Copilot with instructions for how that particular workbook should be handled. When the file is shared with someone else, the rules go with it.
That could help teams create more consistent spreadsheets without someone having to repeatedly explain:
"This is how we do this report."
This is part of a bigger shift we're seeing with business AI.
The first wave of AI tools focused heavily on creating things.
Write this.
Summarize that.
Explain this formula.
The next step is making AI better at understanding how your business actually works.
Your preferred formats.
Your processes.
Your standards.
Your way of organizing information.
The better the tool understands those expectations, the less time your team may need to spend correcting repetitive details.
That's where AI starts becoming more useful in everyday workflows—not because it's doing something spectacular, but because it's quietly removing tedious work.
There's one important caution.
Just because Copilot understands how you want a spreadsheet formatted doesn't mean you should stop checking its work.
Spreadsheets can contain important business information.
If AI is helping with:
someone still needs to verify that the results are correct.
The source makes this point explicitly: these features don't remove the need for human oversight, especially when formulas, financial data, and reporting are involved.
AI can make the process faster.
Your people still own the result.
When businesses ask where AI can help, it's tempting to look for a huge transformation.
Sometimes the better place to start is much smaller.
Ask your employees:
"What do you have to fix, format, explain, or repeat every week?"
Those tasks are often excellent candidates for automation.
If Copilot can remember how you want a spreadsheet structured instead of making your team explain it every time, that's time your employees can spend actually using the information inside the spreadsheet.
And that's the real opportunity.
The most useful AI features won't necessarily be the flashy ones.
They'll be the ones that quietly eliminate repetitive work.
Microsoft's improvements to Copilot in Excel are moving in that direction—giving the software more context about how you prefer to work and helping teams maintain consistency across shared spreadsheets.
At TectronIQ IT Services, we help businesses understand which Microsoft 365 and AI tools can genuinely improve productivity—and which ones are more hype than help.
Because AI shouldn't give your team another tool to manage.
It should give them time back.
You’ve got a business to run. We’ve got your back. We help teams stay strong with fast, flexible IT—95% of calls answered in 20 seconds or less. Let’s make sure your tech works as hard as you do.