Carpe diem: Excel - Customize your Quick Access Toolbar

Customize your Quick Access Toolbar to save time. 

This is for the new version of Excel that looks like mine in the pictures.    The toolbar is the dark row across the very top of the program.

The blue row under it is now called a ribbon (I think somebody at Microsoft has too much time on their hands and just sits around and thinks up crazy names to call stuff-my favorite technical term).  We will look at the ribbon later when we need to use different functions such formulas, charts, sorting, etc.

You add the icons for things you use most often so you don’t have to hunt for them every time.

For example, I have print preview, undo, save, open file, new document, and search.  I can change these anytime I want if I start using a feature more often and need to add it or can delete ones from the toolbar I no longer use frequently.

The first step is to click on the chevron (looks like a sargeants stripe) at the end of any icons already on the toolbar.  You will get a drop down box and the ones with yellow checks are currently on your toolbar.  If you click on More Commands you can see all your options.  Don’t get over whelmed with all the choices.  Just pick a few you use ALL the time.  Let me know if you have a hard time making decisions and I will tell you what to put on your toolbar! 


The next picture will show you more.  If you are new to this, just use the Popular Commands to choose from.  If you don’t see what you need, click on All Commands to get a VERY LONG list.

The left side is what you choose from and the right side is what is already on your toobar.


Once you have chosen your command, click on Add in the middle and it will put the icon on the right side and on your toolbar.  You can add and remove at any time so just play with it.


That’s all for now.  I am working on printing options for the next lesson and then we will get going with how to manipulate the data on your spreadsheet.  I know that is what you are anxiously awaiting!  I can feel the excitement in the air.



« Return to Carpe diem

« Return to the Pages table of contents.

Carpe diem

This is a meeting place for people all over the world to discuss and share information about all areas of this ever shrinking globe. NEW!! I have added a forum for discussions about using Excel and tutorials in the PAGES section.

» Home
» Forums
» Articles
» Pages
» Links

Cubit owner: weeds

Admin team:

» Contact the admins

Want to browse around and see what other Cubits are about? Try the Cubit Finder