Depending on how we use Excel, we can customize it, so we finish our work faster.
One tool is “Quick Access Toolbar” which we can use to get our common commands (Bottoms) nearer to work Area.
- The Quick Access Toolbar can be located in one of two places:

You can use the last bottom
to add or remove more commands from this bar:
If you want more than (New, Open, save, Email……), go to More Commands….
There you will find all commands in excel and you can add, sort & remove any command in your own “Quick access Toolbar” from this window (Esay to use):

Or Easily, you can Add a command to the Quick Access Toolbar directly from the Ribbon:
- On the Ribbon, click the appropriate tab or group to display the command that you want to add to the Quick Access Toolbar.
- Right-click the command, and then click Add to Quick Access Toolbar on the shortcut menu.

Then when you using excel press “Alt “, you will find that the commands will be numbered as shortcut key.
This is mine for example:

Ref: Excel Help & Personal Snaps
Hope, it helps.
Good Luck
No comments:
Post a Comment