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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top