Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default copying worksheets size mismatch

Hi!

When copying a intire worksheet to another, print area & formulas, are the
same, but...(there´s always a but) Now, when "print previewing" the new
worksheet, i´ve got 2 pages (was 1 page) and the new worksheet is smaller in
width. I´ve compared page config, and apparently is all the same. Any
suggestions???

Paulo Coelho
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 663
Default copying worksheets size mismatch

Hi,

It is recommended that you copy a worskheet from one Workbook to a different
workbook by right clicking on the Worksheet tab and then selecting Move or
Copy command.

Note: To do this procedure, both the Microsoft workbook must be opened.

Challa Prabhu

"Papa Charlie" wrote:

Hi!

When copying a intire worksheet to another, print area & formulas, are the
same, but...(there´s always a but) Now, when "print previewing" the new
worksheet, i´ve got 2 pages (was 1 page) and the new worksheet is smaller in
width. I´ve compared page config, and apparently is all the same. Any
suggestions???

Paulo Coelho

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default copying worksheets size mismatch


Strange thing is: I´ve used the copy/move command and now i´ve got the
orginal worksheet with only 1 page (in print area), and the copy with 2 pages
(missing 2 rows in page one), and smaller in width, any help? Of course I can
make a fit to page, but, it makes the worksheet overall smaller.

Paulo Coelho

"challa prabhu" wrote:

Hi,

It is recommended that you copy a worskheet from one Workbook to a different
workbook by right clicking on the Worksheet tab and then selecting Move or
Copy command.

Note: To do this procedure, both the Microsoft workbook must be opened.

Challa Prabhu

"Papa Charlie" wrote:

Hi!

When copying a intire worksheet to another, print area & formulas, are the
same, but...(there´s always a but) Now, when "print previewing" the new
worksheet, i´ve got 2 pages (was 1 page) and the new worksheet is smaller in
width. I´ve compared page config, and apparently is all the same. Any
suggestions???

Paulo Coelho

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 13
Default copying worksheets size mismatch

Are you using the same printer to preview your two documents? Why don't you
simply copy the file itself, instead of its sheet (unless you have several
sheets in the source document and want to copy only one, of course)?

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
Retain size of shape when copying to other sheets Boothie Excel Discussion (Misc queries) 0 August 23rd 06 02:51 PM
copying dynamic size to ms powerpoint confused Excel Worksheet Functions 1 October 17th 05 11:48 AM
Trouble copying worksheets between books - is there size limit? kris2u Excel Worksheet Functions 2 October 13th 05 08:44 PM
2 ?, Size and copying? Johnz414 Excel Worksheet Functions 0 June 27th 05 10:55 PM
copying worksheets tea1952 Excel Discussion (Misc queries) 2 January 5th 05 07:11 PM


All times are GMT +1. The time now is 11:53 AM.

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

About Us

"It's about Microsoft Excel"