Skip to Content
Author's profile photo Former Member

Simplify the use of the EPM Add-In for MS Excel – Add to Quick Access Toolbar

There are a number of steps that users might perform regularly, such as Refresh, Create New Document, Sheet Options, etc.  Putting these functions in the Quick Access Toolbar will help users to spend less time toggling between ribbons (EPM, Data Manager, and the rest of the usual Excel ribbons) or drilling down to the different functions, such as Sheet Options.

If you rarely use a function, then it is not a good candidate for this.  However, if you use something regularly, and find that you are constantly switching between ribbons to get to it, then I would suggest adding the function to the Quick Access Toolbar, which is standard functionality in MS Excel 2007.

You can do this by simply right-clicking on the particular function in the ribbon and selecting “Add to Quick Access Toolbar.”  For example:


Now, you should see the new button in your Quick Access Toolbar:


I hope you find this helpful to you and your users.

Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo abilash n
      abilash n

      Thanks Jeff for sharing.