How do I copy clipart from sheet 1 to sheet 2?

J

jimtx

I have a worksheet with a logo appearing in the upper left corner. I wish to
copy the formatted sheet 1 to sheet 2 which I have successfully done.
However, the logo did not copy into sheet 2.
 
B

Bob Flanagan

Try right clicking the sheet tab and making a copy of the sheet instead of
copying the cells.

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel
 
C

challa prabhu

Hi,

1. Select the sheet by clicking the sheet tab.
2. Press the ctrl key and drag to create a copy of the sheet tab. For
example Sheet 1 will look like Sheet1 (2).
3. Copy the cells in to the new work sheet.

-or-

1. Copy the logo from the first sheet.
2. Click the cell in the second sheet and paste.
The top handle of the image positions on the selected row.
3. Drag the handles of the selected cell to adjust the image.

Challa Prabhu
 
Top