How to Create Flowcharts in Excel Series -

How to Select Multiple Flowchart Shapes
in 1 Step

By Nicholas Hebb

Using the Select Multiple Objects Toolbar Function

A quick look at the dialog

The Select Multiple Objects button Select Multiple Objects command button opens a dialog box (shown below) that lists all the shapes on the spreadsheet, allowing you to select all of them in a single click, or a subset of them via checkboxes.

Note: The button doesn't appear on the Drawing toolbar by default. To enable it, you will need to customize the Excel toolbar.

Select Multiple Objects dialog box

Select Multiple Objects is very handy when moving an entire drawing, grouping objects, or selecting all the objects to change the formatting in a single step (instead of one at a time).


Related Articles

Want more useful flowcharting tips? View the list of other flowchart, process map, and process improvement articles here.


About the Author

When he's not writing about flowcharts Nicholas Hebb runs BreezeTree Software, maker of FlowBreeze Flowchart Software - a program that cuts the time to create a flowchart dramatically compared to traditional flowcharting tools. What makes FlowBreeze different?


It converts your text into flowchart symbols based on the words you type, adds a connector from the last shape, and many other time saving features. And, because it's a Microsoft Excel graphics addin, you will create flow charts that are highly portable and integrate directly with Microsoft Office for easy sharing and collaboration.


Click here to view the On-Line FlowBreeze Flowchart Software Demo and see for yourself. (It's a short, 30 second video that loads fast.) You'll be impressed.