Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
RTP
 
Posts: n/a
Default Copying spreadsheet with fonts and patterns

I am trying to copy a spreadsheet and am pasting it into a new worksheet. In
the process I am losing the fonts and patterns. How do I copy the spreadsheet
exactly with the fonts and patterns in tact???

Thanks!
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
how do you copy the sheet exactly?

--
Regards
Frank Kabel
Frankfurt, Germany

"RTP" schrieb im Newsbeitrag
...
I am trying to copy a spreadsheet and am pasting it into a new

worksheet. In
the process I am losing the fonts and patterns. How do I copy the

spreadsheet
exactly with the fonts and patterns in tact???

Thanks!


  #3   Report Post  
RTP
 
Posts: n/a
Default

I highlight the cells I want to copy and then do an Edit == Copy

I try to close the worksheet I'm copying from and I am prompted with the
message that says...

There is a large amount of information on the clipboard.

I then open a New excel workbook and try to Paste and the fonts and
formatting are NOT coming over.

This seems too stupid. I promise I'm not.

"Frank Kabel" wrote:

Hi
how do you copy the sheet exactly?

--
Regards
Frank Kabel
Frankfurt, Germany

"RTP" schrieb im Newsbeitrag
...
I am trying to copy a spreadsheet and am pasting it into a new

worksheet. In
the process I am losing the fonts and patterns. How do I copy the

spreadsheet
exactly with the fonts and patterns in tact???

Thanks!



  #4   Report Post  
Dave Peterson
 
Posts: n/a
Default

What happens if you hold off closing your "sending" workbook until you paste?

Edit|copy
Edit|paste
(close sending)

If that doesn't work...

New workbook
swap back to sending
edit|copy
swap to new
edit|paste
swap to sending
close sending


RTP wrote:

I highlight the cells I want to copy and then do an Edit == Copy

I try to close the worksheet I'm copying from and I am prompted with the
message that says...

There is a large amount of information on the clipboard.

I then open a New excel workbook and try to Paste and the fonts and
formatting are NOT coming over.

This seems too stupid. I promise I'm not.

"Frank Kabel" wrote:

Hi
how do you copy the sheet exactly?

--
Regards
Frank Kabel
Frankfurt, Germany

"RTP" schrieb im Newsbeitrag
...
I am trying to copy a spreadsheet and am pasting it into a new

worksheet. In
the process I am losing the fonts and patterns. How do I copy the

spreadsheet
exactly with the fonts and patterns in tact???

Thanks!




--

Dave Peterson
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



All times are GMT +1. The time now is 08:43 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"