Super Timesaver Tip – 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:
What tools you have in Quick Access Toolbar? Share your QAT tips & tricks using comments
My name is Chandoo. Thanks for dropping by. My mission is to make you awesome in Excel & your work. I live in Wellington, New Zealand. When I am not F9ing my formulas, I cycle, cook or play lego with my kids. Know more about me.
Thank you and see you around.
Leave a Reply
|« Making a Dynamic Dashboard in Excel [Part 1 of 4]||Introducing PHD Sparkline Maker – Dead Simple way to Create Excel Sparklines »|