Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 340
Default 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.



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 663
Default 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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can i copy data from a tabbed working sheet to a summary sheet StephenF Excel Discussion (Misc queries) 1 March 15th 07 03:40 PM
how to copy a cell with formula from sheet 1 (data is all vertical) into sheet 2 parag Excel Worksheet Functions 3 June 15th 06 10:29 PM
'Copy to' Advance Filter depend only on sheet ID not start sheet Sandy Yates Excel Worksheet Functions 0 April 4th 06 03:48 AM
Copy the entire sheet to overlay existing sheet? LurfysMa New Users to Excel 2 August 29th 05 07:05 PM
relative sheet references ala sheet(-1)!B11 so I can copy a sheet. RonMc5 Excel Discussion (Misc queries) 9 February 3rd 05 12:51 AM


All times are GMT +1. The time now is 09:27 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"