Google-sheets – copy a drawing figure in Google Sheets

google sheets

In Google Sheets, one can insert a drawing by selecting "Insert > Drawing". Now let's say I want to make a multiple copies of same drawing. I want to achieve it by copying one figure and pasting it in many places. This method however, I cannot figure out how can I achieve it (or even if its possible).

Question

Is it possible to copy single drawing object and paste it in other place so that I can obtain multiple objects of same shaped drawing figure?

What I have tried

select the target object
"Edit > Copy" from menu
"Edit > Paste" from menu

This does nothing.

Best Answer

Double click on the drawing you want to copy. This should open the drawing window.
Use the mouse draw a selection box around the entire drawing.
Select copy from the action menu
Save and Close the drawing window.
Select "Insert drawing" from the google sheets menu
Select paste in the drawing window action menu.
Save and Close the drawing window.

This should paste an exact copy of your entire drawing into a new location on the sheet.

Related Solutions

Google-sheets – Paste format only in Google Spreadsheets with Chrome as the browser

cmd + c then,

cmd + alt + v

works for me on a Mac.

Ctrl + C then,

Ctrl + Alt + V

works on Windows

Google-sheets – Creating duplicate linked Google spreadsheets that share copy and formatting

You can achieve this by using an array of importrange() functions. This cannot import the formatting information, which is not possible without Apps Script, but it will pull in multiple sheets and aggregate them into one list, which you can then sort with an additional formula. Keep in mind that each imported sheet will have to have the same number of columns. For example, if you have four sheets to import with 4 columns each, the import formula will be as follows:

={
importrange("url_to_sheet_1", "Approved!$A:$D");
importrange("url_to_sheet_2", "Approved!$A:$D");
importrange("url_to_sheet_3", "Approved!$A:$D");
importrange("url_to_sheet_4", "Approved!$A:$D")
}