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

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.

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

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

"jimtx" wrote in message
...
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.

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

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

"jimtx" wrote:

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.