Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Print Preview and Changes

I would like to keep the print preview window visible while I make
changes to the underlying worksheet. As the changes are made they would
be reflected in the document in print preview.

Is this possible?

Thanks,

Kelly

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 811
Default Print Preview and Changes

"scorpion53061" wrote in message
...
I would like to keep the print preview window visible while I make changes
to the underlying worksheet. As the changes are made they would be
reflected in the document in print preview.

Is this possible?


Hi Kelly,

No, this isn't possible. You can think of Print Preview as sort of a
separate program within Excel that uses the printer driver of the currently
active to take a snapshot of what your worksheet will look like when it's
printed. The only changes that will be reflected once the Print Preview
window is open are page setup changes.

There is a view called Page Break Preview (use the Tools/Page Break
Preview menu to switch to it) that shows you how the layout will be
paginated. You can change the worksheet in this view just like in normal
view, but it's not a true preview of what the printed worksheet will look
like other than where the page breaks will be located.

--
Rob Bovey, Excel MVP
Application Professionals
http://www.appspro.com/

* Take your Excel development skills to the next level.
* Professional Excel Development
http://www.appspro.com/Books/Books.htm


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Print Preview and Changes

No.

Maybe using PageBreak View under setup will suffice.

--
Regards,
Tom Ogilvy

"scorpion53061" wrote in message
...
I would like to keep the print preview window visible while I make
changes to the underlying worksheet. As the changes are made they would
be reflected in the document in print preview.

Is this possible?

Thanks,

Kelly



  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Print Preview and Changes

Hi Tom,

How can I switch back to "normal" view from Print Preview? Do you think
I can alternate on each change the user makes without the app being
annoying

"Tom Ogilvy" wrote in message :
No.

Maybe using PageBreak View under setup will suffice.

--
Regards,
Tom Ogilvy

"scorpion53061" wrote in message
...
I would like to keep the print preview window visible while I make
changes to the underlying worksheet. As the changes are made they
would
be reflected in the document in print preview.

Is this possible?

Thanks,

Kelly


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
Plot Area Automatically Expands in Print and Print Preview Myk D. Charts and Charting in Excel 2 March 12th 09 01:41 PM
First page of Excel sheerepeats in print layout or print preview philfrotonda Excel Discussion (Misc queries) 1 July 12th 07 09:28 PM
Print and Print Preview Graphic Moving Resizing 2007/2003 Adam Rayburn Excel Discussion (Misc queries) 0 April 4th 07 04:18 PM
print preview v page break preview SamB Excel Discussion (Misc queries) 0 November 16th 06 05:09 PM
cell borders that I create dont show on print preview or print scott3435 Excel Discussion (Misc queries) 2 April 6th 06 02:37 AM


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