Forum Discussion
Shortcuts to favourite formats in Excel for Web
We're switching to excel for web more and more.
In my desktop excel, i have 6-8 favourite formats stored as simple macros, and short cut buttons in the quick access toolbear
It makes it really easy to tidy up worksheets.
Is there a way to achieve the same within excel for web?
I know i can't add macros, but quick access to favourite formats makes life much easier
2 Replies
Like @SergeyBaklan says, you can do this by recording (writing) Office Script. The only way to quickly access them is by pressing Alt+U, M. This opens the list of scripts and you can use your arrow keys to select the one you need..
Nope, in Excel for web ribbon is not customizable. Instead of macros you may use Office Scripts under Automate, or, for more complex things, generate add-ins using Script Lab.
