Excel Guides

Editing Graphic Objects in Excel

There are a few ways to edit graphic objects in Excel. You can use the "Format" menu, the "Drawing Tools" toolbar, or the "Picture Tools" toolbar. Each of these methods has its own advantages and disadvantages.

Using the Format Menu

The Format menu is the most basic way to edit graphic objects in Excel. To access it, simply right-click on the object you want to edit and select "Format." From here, you can change the object's fill color, line color, and line style. You can also add or remove shadows, 3D effects, and other special effects. One advantage of using the Format menu is that it's very straightforward and easy to use. However, it doesn't offer as many options as the Drawing Tools or Picture Tools toolbar.

Using the Drawing Tools Toolbar

The Drawing Tools toolbar offers more options than the Format menu. To access it, simply click on the object you want to edit and then click on the "Drawing Tools" button in the ribbon. From here, you can change the object's fill color, line color, and line style. You can also add or remove shadows, 3D effects, and other special effects. One advantage of using the Drawing Tools toolbar is that it offers more options than the Format menu. However, it can be a bit more difficult to use because it's not as straightforward.

Using the Picture Tools Toolbar

The Picture Tools toolbar is similar to the Drawing Tools toolbar but offers even more options. To access it, simply click on the object you want to edit and then click on the "Picture Tools" button in the ribbon. From here, you can change the object's fill color, line color, and line style. You can also add or remove shadows, 3D effects, and other special effects. One advantage of using the Picture Tools toolbar is that it offers more options than both the Format menu and Drawing Tools toolbar. However, it can be a bit more difficult to use because it's not as straightforward.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.