Quick Links
Excel has so many tools that finding the right ones can often slow your workflow.
This is why using the Quick Access Toolbar (QAT) is the way forward.
There are various ways tocustomize what you see here.
Lucas Gouveia / How-To Geek
If the AutoSave toggle is green, your work issaved and backed up to your OneDrive cloud.
Similarly, you might only want to copy and paste the formatting, not the data.
Even if you don’t have the time (or the inclination!)
So, having it in my QAT means I don’t have to go searching for it each time.
In this example, I want to freeze row 1 and columns A and B.
This option freezes all rows above and all columns to the left of the selected cell.
Personalized Macro Buttons
Microsoft 365’s macros let youperform very specific actions with one click.
Now, choose the relevant macro, and click “Add.”
you could then choose a suitable icon for your macro by selecting the macro and clicking “Modify.”
You cannot modify QAT icons for standard commandsExcel only lets you change your personalized macro icons.
poke the down arrow next to your QAT, and click “More Commands” to open Excel Options.
