Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Mark G
 
Posts: n/a
Default Page view vs. Print View

One of my co-workers has a workbook that has 1 page that is huge on the
screen (2 screens wide) but prints normal - the problem I have is if I try
to copy/paste the page in to a new workbook it formats out to about 8 pages.
Any way to fix this?
--
MsG
  #2   Report Post  
JulieD
 
Posts: n/a
Default

Hi

rather than copy / paste to a new book how about right mouse click on the
sheet tab and choose move or copy - choose a new book from the drop down and
ENSURE that you click create a copy

then you'll have the same formatting as the original ... you might also need
to check under file / page set up, if scaling or fit to page is turned on
for the original

Cheers
JulieD

"Mark G" wrote in message
...
One of my co-workers has a workbook that has 1 page that is huge on the
screen (2 screens wide) but prints normal - the problem I have is if I try
to copy/paste the page in to a new workbook it formats out to about 8
pages.
Any way to fix this?
--
MsG



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
My scaling is set to print 1x1 pages. But it prints 1000's of page Graeme Excel Worksheet Functions 0 March 23rd 05 02:15 AM
print selected sections on the same page ripley Excel Discussion (Misc queries) 1 February 22nd 05 05:04 PM
Getting rid of 2nd Page on Print. Shadyhosta New Users to Excel 3 December 30th 04 01:36 PM
Page breaks don't show on screen and don't print separately. It i. Peter Excel Discussion (Misc queries) 1 November 29th 04 05:33 PM
how to print a row on the bottom of every page Punx Excel Discussion (Misc queries) 1 November 29th 04 05:20 PM


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

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"