fbpx
Search
Close this search box.

Super Timesaver Tip – Add “Select Objects” to Quick Access Toolbar

Share

Facebook
Twitter
LinkedIn

Add Select Objects to Quick Access Toolbar

Here is a very quick, very short excel tip. Add the “select objects” tool to Quick Access Toolbar.

In excel 2003 and earlier, this button is available in the bottom left corner (on the drawing toolbar) so that whenever you are working with charts or drawing shapes, you could easily select multiple objects and drag, align, format them. But in Excel 2007 the tool bars have vanished and “Select Objects” tool was moved to a sub-menu inside home ribbon. Going there everytime you need to format a bunch of objects is a huge waste of time. Instead, you can save time by adding this tool to Quick Access Toolbar like this:

Select Objects tool is available in Home > Find & Select Menu

Related: Quick Access Toolbar Customization tips & tweaks | More Quick Excel Tips

What tools you have in Quick Access Toolbar? Share your QAT tips & tricks using comments

Facebook
Twitter
LinkedIn

Share this tip with your colleagues

Excel and Power BI tips - Chandoo.org Newsletter

Get FREE Excel + Power BI Tips

Simple, fun and useful emails, once per week.

Learn & be awesome.

Welcome to Chandoo.org

Thank you so much for visiting. My aim is to make you awesome in Excel & Power BI. I do this by sharing videos, tips, examples and downloads on this website. There are more than 1,000 pages with all things Excel, Power BI, Dashboards & VBA here. Go ahead and spend few minutes to be AWESOME.

Read my storyFREE Excel tips book

Overall I learned a lot and I thought you did a great job of explaining how to do things. This will definitely elevate my reporting in the future.
Rebekah S
Reporting Analyst
Excel formula list - 100+ examples and howto guide for you

From simple to complex, there is a formula for every occasion. Check out the list now.

Calendars, invoices, trackers and much more. All free, fun and fantastic.

Advanced Pivot Table tricks

Power Query, Data model, DAX, Filters, Slicers, Conditional formats and beautiful charts. It's all here.

Still on fence about Power BI? In this getting started guide, learn what is Power BI, how to get it and how to create your first report from scratch.

13 Responses to “Super Timesaver Tip – Add “Select Objects” to Quick Access Toolbar”

  1. oldchippy says:

    Thanks Chandoo - I needed that yesterday, do you think I could find it - I've now added it to my toolbar!

  2. Serhat says:

    This is another reason why people should not switch to Excel 2007. Chandoo, can you name 10 reasons that prove 2007 is better than 2003?

    I've been very happy with my 2003 so far.

  3. JP says:

    Your readers might also like a previous article of yours:

    http://chandoo.org/wp/2009/10/19/excel-2003-toolbar-in-2007/

    You can customize the QAT to look just like Excel 2003's menus.

  4. Ninad Pradhan says:

    Definitely worth having it at a click.

    @ALL: What are the most common buttons added to the QAT. Seeing Chandoo's image of the QAT, he surely does have a few.

  5. Nimesh says:

    Hi Chandoo,

    I recently added this to quick access toolbar.
    I wanted to remove objects that got copied along with web page data.

  6. Joseph says:

    Thanks for the tip.

    However, doesn't Ctrl + Click do the same thing?

  7. Hui says:

    I always add Set Print Area, Print Preview, Print, Paste Values, Paste Formulas

  8. Clarity says:

    I also add in a couple of custom buttons on there for a format macro and a loop macro that I use regularly

  9. sam says:

    Wrong way of doing it. Heres the right way 🙂
    http://i41.tinypic.com/24dg77c.jpg

  10. I add Switch Windows if I don't show all in the task bar.

    Looks like you like playing with Autoshapes Chandoo. Me too 🙂

  11. Chandoo says:

    @Serhat: I found excel 2007 quite ok. Infact on the rare occasions when I work with 2003 I find it a bit rustic and old (although very fast). I think most of it is in the mind.

    @Ninad and Andrew, yes, I use autoshapes and alignment tools alot to keep my dashboards crisp and elegant.

    @Joseph: Yes, ctrl+click does the same, but it is a bit painful to use that as we have to hold down ctrl and move around. click, drag is much more intuitive and simple.

  12. [...] Excel 2007 I don’t have that button anywhere but I found a way to add it in Pointy haired [...]

  13. GlenC says:

    Note: Just to make this even more annoying the select object option does not select some type of objects (e.g. checkboxes added to the worksheet via a paste from html content) like excel 2003- did.  It seems to have two types of objects now!   You will need to enable design mode first to get to these "other objects", then use the select object tool (isn't this now making things more difficult for the user, as they don't care what type of object it is, they just want to select it!)  My advice is to add the Design mode icon to your Quick Launch toolbar also (so you can toggle it on and off).  I hope this helps someone else, cause it stuffed me around for a while.

Leave a Reply