+ Reply to Thread
Results 1 to 12 of 12

Print preview

  1. #1
    Ska
    Guest

    Print preview

    How can i have the dooteed lines indicating the pages on the sheet, what i am
    doing at present is clicking print preview and then closing straight away so
    that these dotted lines are shown, i do a lot of large copying and pasting
    in the sheets so it will be easier to see where to position things.

    Ta


    Stu

  2. #2
    Registered User
    Join Date
    02-09-2004
    Location
    The Netherlands
    Posts
    46
    I think you want to see the page break preview.
    View --> Page Break Preview.

  3. #3
    Dave Peterson
    Guest

    Re: Print preview

    When I want to see those dotted lines, I just do a quick print preview.

    If I don't want to see them, I go through:

    Tools|Options|View tab|and uncheck page breaks

    Ska wrote:
    >
    > How can i have the dooteed lines indicating the pages on the sheet, what i am
    > doing at present is clicking print preview and then closing straight away so
    > that these dotted lines are shown, i do a lot of large copying and pasting
    > in the sheets so it will be easier to see where to position things.
    >
    > Ta
    >
    > Stu


    --

    Dave Peterson

  4. #4
    rmpete
    Guest

    Re: Print preview

    Hello Dave,
    My Tools|Options|View tab|has the Page Breaks checked but I still cannot see
    the dotted lines. What do I do now?
    Thanks

    "Dave Peterson" wrote:

    > When I want to see those dotted lines, I just do a quick print preview.
    >
    > If I don't want to see them, I go through:
    >
    > Tools|Options|View tab|and uncheck page breaks
    >
    > Ska wrote:
    > >
    > > How can i have the dooteed lines indicating the pages on the sheet, what i am
    > > doing at present is clicking print preview and then closing straight away so
    > > that these dotted lines are shown, i do a lot of large copying and pasting
    > > in the sheets so it will be easier to see where to position things.
    > >
    > > Ta
    > >
    > > Stu

    >
    > --
    >
    > Dave Peterson
    >


  5. #5
    Dave Peterson
    Guest

    Re: Print preview

    Try the print preview.


    rmpete wrote:
    >
    > Hello Dave,
    > My Tools|Options|View tab|has the Page Breaks checked but I still cannot see
    > the dotted lines. What do I do now?
    > Thanks
    >
    > "Dave Peterson" wrote:
    >
    > > When I want to see those dotted lines, I just do a quick print preview.
    > >
    > > If I don't want to see them, I go through:
    > >
    > > Tools|Options|View tab|and uncheck page breaks
    > >
    > > Ska wrote:
    > > >
    > > > How can i have the dooteed lines indicating the pages on the sheet, what i am
    > > > doing at present is clicking print preview and then closing straight away so
    > > > that these dotted lines are shown, i do a lot of large copying and pasting
    > > > in the sheets so it will be easier to see where to position things.
    > > >
    > > > Ta
    > > >
    > > > Stu

    > >
    > > --
    > >
    > > Dave Peterson
    > >


    --

    Dave Peterson

  6. #6
    rmpete
    Guest

    Re: Print preview

    That's the point:
    I did try the Print Preview and I still can't see the dotted lines even
    though the the Page Breaks is checked .
    What do I do now?


    "Dave Peterson" wrote:

    > Try the print preview.
    >
    >
    > rmpete wrote:
    > >
    > > Hello Dave,
    > > My Tools|Options|View tab|has the Page Breaks checked but I still cannot see
    > > the dotted lines. What do I do now?
    > > Thanks
    > >
    > > "Dave Peterson" wrote:
    > >
    > > > When I want to see those dotted lines, I just do a quick print preview.
    > > >
    > > > If I don't want to see them, I go through:
    > > >
    > > > Tools|Options|View tab|and uncheck page breaks
    > > >
    > > > Ska wrote:
    > > > >
    > > > > How can i have the dooteed lines indicating the pages on the sheet, what i am
    > > > > doing at present is clicking print preview and then closing straight away so
    > > > > that these dotted lines are shown, i do a lot of large copying and pasting
    > > > > in the sheets so it will be easier to see where to position things.
    > > > >
    > > > > Ta
    > > > >
    > > > > Stu
    > > >
    > > > --
    > > >
    > > > Dave Peterson
    > > >

    >
    > --
    >
    > Dave Peterson
    >


  7. #7
    Dave Peterson
    Guest

    Re: Print preview

    Maybe you'll be able to see where those dashed lines are by turning of Gridlines
    (also under tools|options|View tab).

    If that doesn't help, you could use View|Page break preview to see where they
    should be.

    (and View|Normal to get it back to normal)

    Do you have any borders that might be interfering with the view?

    rmpete wrote:
    >
    > That's the point:
    > I did try the Print Preview and I still can't see the dotted lines even
    > though the the Page Breaks is checked .
    > What do I do now?
    >
    > "Dave Peterson" wrote:
    >
    > > Try the print preview.
    > >
    > >
    > > rmpete wrote:
    > > >
    > > > Hello Dave,
    > > > My Tools|Options|View tab|has the Page Breaks checked but I still cannot see
    > > > the dotted lines. What do I do now?
    > > > Thanks
    > > >
    > > > "Dave Peterson" wrote:
    > > >
    > > > > When I want to see those dotted lines, I just do a quick print preview.
    > > > >
    > > > > If I don't want to see them, I go through:
    > > > >
    > > > > Tools|Options|View tab|and uncheck page breaks
    > > > >
    > > > > Ska wrote:
    > > > > >
    > > > > > How can i have the dooteed lines indicating the pages on the sheet, what i am
    > > > > > doing at present is clicking print preview and then closing straight away so
    > > > > > that these dotted lines are shown, i do a lot of large copying and pasting
    > > > > > in the sheets so it will be easier to see where to position things.
    > > > > >
    > > > > > Ta
    > > > > >
    > > > > > Stu
    > > > >
    > > > > --
    > > > >
    > > > > Dave Peterson
    > > > >

    > >
    > > --
    > >
    > > Dave Peterson
    > >


    --

    Dave Peterson

  8. #8
    Debra Dalgleish
    Guest

    Re: Print preview

    And if the Scaling is set to "Fit to", the page break dashes won't be
    visible.

    Scaling is set under File>Page Setup, Page tab.

    Dave Peterson wrote:
    > Maybe you'll be able to see where those dashed lines are by turning of Gridlines
    > (also under tools|options|View tab).
    >
    > If that doesn't help, you could use View|Page break preview to see where they
    > should be.
    >
    > (and View|Normal to get it back to normal)
    >
    > Do you have any borders that might be interfering with the view?
    >
    > rmpete wrote:
    >
    >>That's the point:
    >>I did try the Print Preview and I still can't see the dotted lines even
    >>though the the Page Breaks is checked .
    >>What do I do now?
    >>
    >>"Dave Peterson" wrote:
    >>
    >>
    >>>Try the print preview.
    >>>
    >>>
    >>>rmpete wrote:
    >>>
    >>>>Hello Dave,
    >>>>My Tools|Options|View tab|has the Page Breaks checked but I still cannot see
    >>>>the dotted lines. What do I do now?
    >>>>Thanks
    >>>>
    >>>>"Dave Peterson" wrote:
    >>>>
    >>>>
    >>>>>When I want to see those dotted lines, I just do a quick print preview.
    >>>>>
    >>>>>If I don't want to see them, I go through:
    >>>>>
    >>>>>Tools|Options|View tab|and uncheck page breaks
    >>>>>
    >>>>>Ska wrote:
    >>>>>
    >>>>>>How can i have the dooteed lines indicating the pages on the sheet, what i am
    >>>>>>doing at present is clicking print preview and then closing straight away so
    >>>>>>that these dotted lines are shown, i do a lot of large copying and pasting
    >>>>>>in the sheets so it will be easier to see where to position things.
    >>>>>>
    >>>>>>Ta
    >>>>>>
    >>>>>>Stu
    >>>>>
    >>>>>--
    >>>>>
    >>>>>Dave Peterson
    >>>>>
    >>>>
    >>>--
    >>>
    >>>Dave Peterson
    >>>

    >>

    >



    --
    Debra Dalgleish
    Excel FAQ, Tips & Book List
    http://www.contextures.com/tiptech.html


  9. #9
    Dave Peterson
    Guest

    Re: Print preview

    As in fit to 1 page wide by 1 page tall?

    I could see the horizontal pagebreaks if I did:
    fit to 1 page wide by (empty) pages tall.

    (ps. Thanks for suggestion--I was running out of guesses!)

    Debra Dalgleish wrote:
    >
    > And if the Scaling is set to "Fit to", the page break dashes won't be
    > visible.
    >
    > Scaling is set under File>Page Setup, Page tab.
    >
    > Dave Peterson wrote:
    > > Maybe you'll be able to see where those dashed lines are by turning of Gridlines
    > > (also under tools|options|View tab).
    > >
    > > If that doesn't help, you could use View|Page break preview to see where they
    > > should be.
    > >
    > > (and View|Normal to get it back to normal)
    > >
    > > Do you have any borders that might be interfering with the view?
    > >
    > > rmpete wrote:
    > >
    > >>That's the point:
    > >>I did try the Print Preview and I still can't see the dotted lines even
    > >>though the the Page Breaks is checked .
    > >>What do I do now?
    > >>
    > >>"Dave Peterson" wrote:
    > >>
    > >>
    > >>>Try the print preview.
    > >>>
    > >>>
    > >>>rmpete wrote:
    > >>>
    > >>>>Hello Dave,
    > >>>>My Tools|Options|View tab|has the Page Breaks checked but I still cannot see
    > >>>>the dotted lines. What do I do now?
    > >>>>Thanks
    > >>>>
    > >>>>"Dave Peterson" wrote:
    > >>>>
    > >>>>
    > >>>>>When I want to see those dotted lines, I just do a quick print preview.
    > >>>>>
    > >>>>>If I don't want to see them, I go through:
    > >>>>>
    > >>>>>Tools|Options|View tab|and uncheck page breaks
    > >>>>>
    > >>>>>Ska wrote:
    > >>>>>
    > >>>>>>How can i have the dooteed lines indicating the pages on the sheet, what i am
    > >>>>>>doing at present is clicking print preview and then closing straight away so
    > >>>>>>that these dotted lines are shown, i do a lot of large copying and pasting
    > >>>>>>in the sheets so it will be easier to see where to position things.
    > >>>>>>
    > >>>>>>Ta
    > >>>>>>
    > >>>>>>Stu
    > >>>>>
    > >>>>>--
    > >>>>>
    > >>>>>Dave Peterson
    > >>>>>
    > >>>>
    > >>>--
    > >>>
    > >>>Dave Peterson
    > >>>
    > >>

    > >

    >
    > --
    > Debra Dalgleish
    > Excel FAQ, Tips & Book List
    > http://www.contextures.com/tiptech.html


    --

    Dave Peterson

  10. #10
    rmpete
    Guest

    Re: Print preview

    Thank you Debra!!
    The Scaling was set to "Fit to", and the page break dashes were not
    visible. Now I can continue working.
    Thanks again,
    rmpete


    "Debra Dalgleish" wrote:

    > And if the Scaling is set to "Fit to", the page break dashes won't be
    > visible.
    >
    > Scaling is set under File>Page Setup, Page tab.
    >
    > Dave Peterson wrote:
    > > Maybe you'll be able to see where those dashed lines are by turning of Gridlines
    > > (also under tools|options|View tab).
    > >
    > > If that doesn't help, you could use View|Page break preview to see where they
    > > should be.
    > >
    > > (and View|Normal to get it back to normal)
    > >
    > > Do you have any borders that might be interfering with the view?
    > >
    > > rmpete wrote:
    > >
    > >>That's the point:
    > >>I did try the Print Preview and I still can't see the dotted lines even
    > >>though the the Page Breaks is checked .
    > >>What do I do now?
    > >>
    > >>"Dave Peterson" wrote:
    > >>
    > >>
    > >>>Try the print preview.
    > >>>
    > >>>
    > >>>rmpete wrote:
    > >>>
    > >>>>Hello Dave,
    > >>>>My Tools|Options|View tab|has the Page Breaks checked but I still cannot see
    > >>>>the dotted lines. What do I do now?
    > >>>>Thanks
    > >>>>
    > >>>>"Dave Peterson" wrote:
    > >>>>
    > >>>>
    > >>>>>When I want to see those dotted lines, I just do a quick print preview.
    > >>>>>
    > >>>>>If I don't want to see them, I go through:
    > >>>>>
    > >>>>>Tools|Options|View tab|and uncheck page breaks
    > >>>>>
    > >>>>>Ska wrote:
    > >>>>>
    > >>>>>>How can i have the dooteed lines indicating the pages on the sheet, what i am
    > >>>>>>doing at present is clicking print preview and then closing straight away so
    > >>>>>>that these dotted lines are shown, i do a lot of large copying and pasting
    > >>>>>>in the sheets so it will be easier to see where to position things.
    > >>>>>>
    > >>>>>>Ta
    > >>>>>>
    > >>>>>>Stu
    > >>>>>
    > >>>>>--
    > >>>>>
    > >>>>>Dave Peterson
    > >>>>>
    > >>>>
    > >>>--
    > >>>
    > >>>Dave Peterson
    > >>>
    > >>

    > >

    >
    >
    > --
    > Debra Dalgleish
    > Excel FAQ, Tips & Book List
    > http://www.contextures.com/tiptech.html
    >
    >


  11. #11
    Debra Dalgleish
    Guest

    Re: Print preview

    You're welcome! Thanks for letting me know that was the problem.

    (And thanks to Dave, for eliminating all the other possible causes.)

    rmpete wrote:
    > Thank you Debra!!
    > The Scaling was set to "Fit to", and the page break dashes were not
    > visible. Now I can continue working.
    > Thanks again,
    > rmpete
    >
    >
    > "Debra Dalgleish" wrote:
    >
    >
    >>And if the Scaling is set to "Fit to", the page break dashes won't be
    >>visible.
    >>
    >>Scaling is set under File>Page Setup, Page tab.
    >>
    >>Dave Peterson wrote:
    >>
    >>>Maybe you'll be able to see where those dashed lines are by turning of Gridlines
    >>>(also under tools|options|View tab).
    >>>
    >>>If that doesn't help, you could use View|Page break preview to see where they
    >>>should be.
    >>>
    >>>(and View|Normal to get it back to normal)
    >>>
    >>>Do you have any borders that might be interfering with the view?
    >>>
    >>>rmpete wrote:
    >>>
    >>>
    >>>>That's the point:
    >>>>I did try the Print Preview and I still can't see the dotted lines even
    >>>>though the the Page Breaks is checked .
    >>>>What do I do now?
    >>>>
    >>>>"Dave Peterson" wrote:
    >>>>
    >>>>
    >>>>
    >>>>>Try the print preview.
    >>>>>
    >>>>>
    >>>>>rmpete wrote:
    >>>>>
    >>>>>
    >>>>>>Hello Dave,
    >>>>>>My Tools|Options|View tab|has the Page Breaks checked but I still cannot see
    >>>>>>the dotted lines. What do I do now?
    >>>>>>Thanks
    >>>>>>
    >>>>>>"Dave Peterson" wrote:
    >>>>>>
    >>>>>>
    >>>>>>
    >>>>>>>When I want to see those dotted lines, I just do a quick print preview.
    >>>>>>>
    >>>>>>>If I don't want to see them, I go through:
    >>>>>>>
    >>>>>>>Tools|Options|View tab|and uncheck page breaks
    >>>>>>>
    >>>>>>>Ska wrote:
    >>>>>>>
    >>>>>>>
    >>>>>>>>How can i have the dooteed lines indicating the pages on the sheet, what i am
    >>>>>>>>doing at present is clicking print preview and then closing straight away so
    >>>>>>>>that these dotted lines are shown, i do a lot of large copying and pasting
    >>>>>>>>in the sheets so it will be easier to see where to position things.



    --
    Debra Dalgleish
    Excel FAQ, Tips & Book List
    http://www.contextures.com/tiptech.html


  12. #12
    Dave Peterson
    Guest

    Re: Print preview

    You're welcome, ma'am for being wrong so many times!

    I'll try to keep up the good work.

    <vbg>

    Debra Dalgleish wrote:
    >
    > You're welcome! Thanks for letting me know that was the problem.
    >
    > (And thanks to Dave, for eliminating all the other possible causes.)
    >
    > rmpete wrote:
    > > Thank you Debra!!
    > > The Scaling was set to "Fit to", and the page break dashes were not
    > > visible. Now I can continue working.
    > > Thanks again,
    > > rmpete
    > >
    > >
    > > "Debra Dalgleish" wrote:
    > >
    > >
    > >>And if the Scaling is set to "Fit to", the page break dashes won't be
    > >>visible.
    > >>
    > >>Scaling is set under File>Page Setup, Page tab.
    > >>
    > >>Dave Peterson wrote:
    > >>
    > >>>Maybe you'll be able to see where those dashed lines are by turning of Gridlines
    > >>>(also under tools|options|View tab).
    > >>>
    > >>>If that doesn't help, you could use View|Page break preview to see where they
    > >>>should be.
    > >>>
    > >>>(and View|Normal to get it back to normal)
    > >>>
    > >>>Do you have any borders that might be interfering with the view?
    > >>>
    > >>>rmpete wrote:
    > >>>
    > >>>
    > >>>>That's the point:
    > >>>>I did try the Print Preview and I still can't see the dotted lines even
    > >>>>though the the Page Breaks is checked .
    > >>>>What do I do now?
    > >>>>
    > >>>>"Dave Peterson" wrote:
    > >>>>
    > >>>>
    > >>>>
    > >>>>>Try the print preview.
    > >>>>>
    > >>>>>
    > >>>>>rmpete wrote:
    > >>>>>
    > >>>>>
    > >>>>>>Hello Dave,
    > >>>>>>My Tools|Options|View tab|has the Page Breaks checked but I still cannot see
    > >>>>>>the dotted lines. What do I do now?
    > >>>>>>Thanks
    > >>>>>>
    > >>>>>>"Dave Peterson" wrote:
    > >>>>>>
    > >>>>>>
    > >>>>>>
    > >>>>>>>When I want to see those dotted lines, I just do a quick print preview.
    > >>>>>>>
    > >>>>>>>If I don't want to see them, I go through:
    > >>>>>>>
    > >>>>>>>Tools|Options|View tab|and uncheck page breaks
    > >>>>>>>
    > >>>>>>>Ska wrote:
    > >>>>>>>
    > >>>>>>>
    > >>>>>>>>How can i have the dooteed lines indicating the pages on the sheet, what i am
    > >>>>>>>>doing at present is clicking print preview and then closing straight away so
    > >>>>>>>>that these dotted lines are shown, i do a lot of large copying and pasting
    > >>>>>>>>in the sheets so it will be easier to see where to position things.

    >
    > --
    > Debra Dalgleish
    > Excel FAQ, Tips & Book List
    > http://www.contextures.com/tiptech.html


    --

    Dave Peterson

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1