Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / February 2008

Tip: Looking for answers? Try searching our database.

Page break preview & blue line

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
a - 14 Feb 2008 21:33 GMT
I using Excel 2003

In page break preview I have always do some thing wrong I'm just pull the
blue line by using mouse all page was destroyed

It there any tips to return the blue line to the Default pages size setting
Barbara Wiseman - 16 Feb 2008 11:33 GMT
As far as I know the 'default' print area is all the data, and once you have
changed the print area and saved the file you can not get it to go back to
the previous setting.
If you have problems with this or any other proceedure do try to remember to
save your file before you do the awkward bit and then you can go back to the
saved copy it it does not work.

You might find it easier to use the file, Print area, set print area method,
after first highlighting the area.
There are several ways to make this less tedious.

Put the icon for set print area in your toolbar.
1.  Tools, customise, commands tab
2. In the file category, about half way down the list is the set print area
icon and words.
3. Drag this to your tool bar area and drop it where you would like to see
it.

To highlight a large area click on one of the corners, hold down the shift
key on your keyboard.  Then with the scroll bars find the opposite corner of
the area, and click with your mouse on it (shift is still depressed).

If you have problems with the page break view you can easily move between
that and the normal view by putting the icons on your tool bar.
Tools, customise, commands tab
View category, and the pagebreak view & normal view are the first 2 in the
list, drag them to your toolbars.

Good luck,
>I using Excel 2003
>
[quoted text clipped - 3 lines]
> It there any tips to return the blue line to the Default pages size
> setting
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.