Excel Drawing Toolbar and Select Objects

Drawing Toolbar in Excel 2013-2021, Office 365

In Excel 2013-2021, Office 365, the drawing tools can be found in Insert > Shapes:

drawing-tools-location-in-excel 

Select Objects in Excel 2013-2021, Office 365

The one thing that's really hard to find, however, is the arrow to select multiple objects. To find it, click on the Home tab, then Find & Select, and Select Objects:

excel-select-objects-location

This will allow you to select, copy and paste multiple objects at one time.


Stop using old technology!

Upgrade Your Excel and Data Analysis Skills to Smart Charts Using QI Macros.

Track Data Over Time

Primitive Chart
line graph
Line Graph
Smart Chart
control chart
Control Chart

Compare Categories

Primitive Chart
pie chart
Pie Chart
Smart Chart
pareto chart
Pareto Chart

Analyze Variation

Primitive Chart
bar or column chart
Bar or Column Chart
Smart Chart
histogram
Histogram

QI Macros add-in for Excel makes creating smart charts a snap.