+ Reply to Thread
Results 1 to 15 of 15

Resize a table to fit my pages

  1. #1
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Office 365 64-Bit, 2108, build 14326.21018
    Posts
    3,952

    Resize a table to fit my pages

    I've attached my problem. File was originally a poorly formatted PDF (incorrect margins I couldn't fix). I went online and converted it to an RTF, then saved it to Word to reduce the file size. The PDF was designed to print on 11X17 paper, but I'd rather print it on Legal or Letter, getting the best fit. But I still can't get it to accept my margins. When I try to change them it says the print won't fit, but I can't figure out how to resize the darn thing. Any help on this would be appreciated.
    Attached Files Attached Files
    I know I'm not stupid, but I suspect I'm a lot stupider than I think I am

  2. #2
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,405

    Re: Resize a table to fit my pages

    I've no idea what's causing it either. I tried adjusting the margin sizes for every section individually, using the ruler as the dialogue box wouldn't let me in most cases, but that didn't help.
    However, I've managed to copy the tables and text to a new document in Legal size for you. There's a page break after each table instead of the continuous section breaks in your original. You'll have to adjust the column widths a bit to get the tables to fit properly (and the row heights if you want them on one page each), but at least the paper size is better now.
    Hope that helps.
    Attached Files Attached Files
    Regards,
    Aardigspook

    I recently started a new job so am a bit busy and may not reply quickly. Sorry - it's not personal - I will reply eventually.
    If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark this Thread as Solved'.
    If you use commas as your decimal separator (1,23 instead of 1.23) then please replace commas with semi-colons in your formulae.
    You don't need to give me rep if I helped, but a thank-you is nice.

  3. #3
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Office 365 64-Bit, 2108, build 14326.21018
    Posts
    3,952

    Re: Resize a table to fit my pages

    I appreciate your work on it, but more than that I wanted to learn how to do it myself (I've noticed that about problems; they always come back).

  4. #4
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: Resize a table to fit my pages

    Your page margins are set to a variety of sizes for the different Sections, and some of those margins are insufficient for most printers. If you select the entire document (e.g. Ctrl-A), then set the column count to 1, you can then use 0.25in margins - which are sufficient for most printers - throughout.

    If you also set the preferred width for each table to 100%, they'll adjust to fit whatever margins (and paper sizes) you use.
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

  5. #5
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Office 365 64-Bit, 2108, build 14326.21018
    Posts
    3,952

    Re: Resize a table to fit my pages

    When I try to set it to one column I get the popup saying"Settings you chose for the left and right margins, column spacing, or paragraph indents are too large for the page width in some sections".

    However, AFTER taking your suggestion on "Table width 100%" I was able to reset the margins. The problem then is that the tables don't fit on the pages correctly.

    What I'd really like to do is resize the table like you would resize a picture; grab a corner and take in to the desired size within my margins. Any ideas?

  6. #6
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: Resize a table to fit my pages

    Quote Originally Posted by jomili View Post
    However, AFTER taking your suggestion on "Table width 100%" I was able to reset the margins. The problem then is that the tables don't fit on the pages correctly.

    What I'd really like to do is resize the table like you would resize a picture; grab a corner and take in to the desired size within my margins. Any ideas?
    You haven't said what the correct size vis-à-vis your margins would be. You could, of course, set the table width to, say, 80% and then even tell Word to center the tables on the page.

  7. #7
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Office 365 64-Bit, 2108, build 14326.21018
    Posts
    3,952

    Re: Resize a table to fit my pages

    it's not just table width, it's table height, text size, etc. It's made to fit on an 11x17 sheet, and I can't get it to resize down to fit on standard paper sizes. Resetting the table width doesn't do it

  8. #8
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: Resize a table to fit my pages

    Obviously, if you're going to change the page size and aspect ratio, you'll have a fair bit of work to do to re-scale everything. Since the tables were originally in PDF format, why don't you just print the PDF from Adobe Acrobat and tell that app to re-scale the printout to suit your paper size?

  9. #9
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Office 365 64-Bit, 2108, build 14326.21018
    Posts
    3,952

    Re: Resize a table to fit my pages

    that's what I tried at first, and couldn't figure out how to accomplish that.

  10. #10
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,405

    Re: Resize a table to fit my pages


  11. #11
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Office 365 64-Bit, 2108, build 14326.21018
    Posts
    3,952

    Re: Resize a table to fit my pages

    Aardigspook,
    The link you pointed me to looks like it would work well, but my application (I'm at work) is different. The pictures below show my issue. When I open the PDF, it's in portrait mode, so I have to switch to Landscape. When I do, it has huge margins, so my printed page is hard to read (too small). when I choose "choose paper source by PDF page size" it looks good, but wants to print on 17X11 inch paper. I want the view for the 17x11, but on 8.5x11, which would mean the margins should shrink proportionally, which they don't.
    Attached Images Attached Images

  12. #12
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,405

    Re: Resize a table to fit my pages

    If you have Legal paper does that maybe work better? The proportions are more similar (17x11 = 1.55:1, legal 14x8.5 = 1.65:1, letter 11x8.5 = 1.29:1).

  13. #13
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Office 365 64-Bit, 2108, build 14326.21018
    Posts
    3,952

    Re: Resize a table to fit my pages

    Out of all my options legal seems to be the best. If I could shrink the margins 8.5*11 would be just right, can't figure out how to do that.

  14. #14
    Valued Forum Contributor
    Join Date
    12-01-2016
    Location
    Planet Earth
    MS-Off Ver
    95 - 2016
    Posts
    343

    Re: Resize a table to fit my pages

    After analyzing your document, the best solution I found was inserting (copying & pasting) the tables into Excel. Here I was able to fix field merging issues and margin errors. see attachment for a few examples
    Attached Files Attached Files

  15. #15
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: Resize a table to fit my pages

    You could, of course, use the 8.5*11 paper in landscape mode as per the 2nd image in post #11 but with a custom scale...

+ 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] Resize table to my used range
    By jomili in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-21-2016, 01:22 PM
  2. [SOLVED] copy table row.height resize row
    By daboho in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-02-2016, 02:21 PM
  3. Macro to Resize a Table
    By brent_milne in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-12-2015, 11:37 AM
  4. UserInterFaceOnly and resize of table
    By wibble98 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-14-2014, 10:08 AM
  5. [SOLVED] Resize table to same row count as a piovt table
    By djon5020 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-13-2014, 01:43 AM
  6. Add row to end of table and resize table automatically
    By cdthimann in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-02-2013, 03:30 AM
  7. Resize Print Area/Pages Macro
    By DHallam in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-07-2006, 10:40 AM

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