+ Reply to Thread
Results 1 to 8 of 8

Pages break in different places on Multiple Computers

  1. #1
    Registered User
    Join Date
    02-07-2019
    Location
    Tacoma, Washington, USA
    MS-Off Ver
    2016
    Posts
    6

    Pages break in different places on Multiple Computers

    Hello,

    I am currently trying to create a bid sheet for our small business that can be opened and printed while in the field with a laptop and mobile printer, as well as from our home offices. I am running into the problem of each computer setting up different page breaks, even when I manually setup the page breaks. I have been trying to search the internet for a solution but am not finding one. Not sure if I am just not typing the correct search fields or what. Any help would be greatly appreciated. Thank you in advance!!!!

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: Pages break in different places on Multiple Computers

    Page breaks are dependent of the active printer and the paper size setting the other computers have set for their chosen printer.
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

  3. #3
    Registered User
    Join Date
    02-07-2019
    Location
    Tacoma, Washington, USA
    MS-Off Ver
    2016
    Posts
    6

    Re: Pages break in different places on Multiple Computers

    That is what I kept finding online, but both my cousin and I have seen, and worked with, excel documents for other companies that could print out on any computer and any printer; yet I can't seem to get mine to work like that. Would putting each page in its own work book help? Then just set excel to always scale each workbook to full page?

  4. #4
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: Pages break in different places on Multiple Computers

    Nobody said it was easy
    I wouldn't go for a workbook for each sheet, since I have no idea what your bid sheet looks like I would have to go on assumptions and you know what they say about ASSUME take it apart and it makes it and A S S of U and ME
    If you define each 'page'as a range, (this is with macros (VBA) then you could copy the range to a temporary sheet where you set the specific layout , and then process the next range etc.
    If you attach a your bidsheet which I assume is a kind of template you fill maybe I can see if I can come up with another idea.
    Yiou know Excel is limited to the user's inventivity and imagination

  5. #5
    Registered User
    Join Date
    02-07-2019
    Location
    Tacoma, Washington, USA
    MS-Off Ver
    2016
    Posts
    6

    Re: Pages break in different places on Multiple Computers

    I haven't gotten into VBA yet, but I am planning too. Here is what I have so far... the first 3 sheets are what I need to be able to print. The rest is to aid the in home designer with creating the contract.
    Attached Files Attached Files

  6. #6
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: Pages break in different places on Multiple Computers

    I've downloaded your file and will see if I can help.
    Maybe you don't need VBA, will see.

  7. #7
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: Pages break in different places on Multiple Computers

    As far as I can see it's just a question of setting the page ranges correct and the layout per page.
    When printing just select all the worksheets and then check print preview and you will see all 5 sheets.
    With the worksheets selected choose SaveAs PDF file it will even come out correctly too.

  8. #8
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: Pages break in different places on Multiple Computers

    Have you taken a look? Does this do what you want?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Excel Macro Runs on Some Computers, Not All- Stalls for computers where it fails to run
    By jamie.harris in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 05-25-2018, 04:54 PM
  2. Pages WATER MARK under Page break Preview
    By mmf in forum Excel General
    Replies: 6
    Last Post: 08-02-2012, 02:45 AM
  3. Page Break, or turn 2 pages into one
    By DeniseB in forum Excel General
    Replies: 3
    Last Post: 09-29-2006, 01:05 PM
  4. [SOLVED] Break cell into multiple lines by line break
    By Chia in forum Excel General
    Replies: 1
    Last Post: 08-20-2006, 01:40 AM
  5. pages break in the 66rd line , 132, etc...
    By ...Patrick in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-30-2006, 01:40 PM
  6. Replies: 4
    Last Post: 04-10-2006, 03:55 PM
  7. How do you format a row to break accross pages in Excel?
    By DD in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-04-2005, 05:06 PM

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