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:

/wp-content/uploads/2014/05/2014_05_27_141241_461408.jpg

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

/wp-content/uploads/2014/05/2014_05_27_141544_461410.jpg

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

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

Leave a Reply