Excel Guides

Duplicating Drawing Objects in Excel

There are a few different ways that you can duplicate drawing objects in Excel. You can use the Duplicate command on the Format tab, you can copy and paste the object, or you can use the Office Clipboard.

Using the Duplicate Command

To use the Duplicate command, first select the drawing object that you want to duplicate. Then, on the Format tab, in the Arrange group, click Duplicate.

A dialog box will appear and you can choose how many copies of the object you want to create and whether you want them to be horizontally or vertically offset from the original object. When you're finished, click OK.

Copying and Pasting

You can also copy and paste a drawing object to create a duplicate. To do this, first select the object that you want to copy. Then press Ctrl+C to copy it to the clipboard. Next, select the cell where you want to paste the object. Finally, press Ctrl+V to paste it.

Using the Office Clipboard

The Office Clipboard allows you to copy up to 24 items from Office documents at one time. This means that you can copy multiple drawing objects and then paste them all at once. To use the Office Clipboard, first select the drawing objects that you want to copy. Then press Ctrl+C to copy them to the clipboard.

Next, open the Office Clipboard by clicking the clipboard icon on the Home tab. (If this icon is not visible, click the arrow in the lower-right corner of the group to expand it.) The Office Clipboard will appear as a task pane on your screen.

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.