Results 1 to 6 of 6
  1. #1
    New Lounger
    Join Date
    Oct 2004
    Location
    Peterborough, Cambridgeshire, England
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re-Sizing Table (Excel 2000)

    I have a table of data (football scores, in fact). I am happy with a format and font of this table - but I want to down size this table to 136mm (wide) by 210mm (depth) to fit into a book / document I am working on. Is there a way to do this without altering the margins?
    Thanks-ever-so-much!
    L.E.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Re-Sizing Table (Excel 2000)

    Why not work with a "picture" of the shape, it might be easier?

    Hold the shift while selecting copy and choose: copy picture

    You can paste the picture, select format picture from the right-click menu, in the size tab you can set its size.

    Steve

  3. #3
    New Lounger
    Join Date
    Oct 2004
    Location
    Peterborough, Cambridgeshire, England
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Re-Sizing Table (Excel 2000)

    Thanks very much for your help, I have tried your suggestion, but get the following message: "The picture is too large and will be truncated".. Is there any other way that you know of? Thanks again, Lucy

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Re-Sizing Table (Excel 2000)

    Change the column and/or row sizes to make the table the appropriate size?

    Steve

  5. #5
    New Lounger
    Join Date
    Oct 2004
    Location
    Peterborough, Cambridgeshire, England
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Re-Sizing Table (Excel 2000)

    OK, I shall have another look.
    Thanks so much for your time,
    hope you have a good Christmas!
    L.E.

  6. #6
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Re-Sizing Table (Excel 2000)

    Select the cells and change the font size to a smaller size. Now, change the row heights and column widths until it fits.

    If you are wanting to print in a size that will fit, you can go to Page Setup on the file menu and adjust the scaling until it prints in a size that will fit.
    Legare Coleman

Posting Permissions

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