+ Reply to Thread
Results 1 to 3 of 3

How to fit to 1 page on excel - remove the borders.

  1. #1
    Registered User
    Join Date
    05-08-2022
    Location
    uk
    MS-Off Ver
    8
    Posts
    2

    Lightbulb How to fit to 1 page on excel - remove the borders.

    Hi,

    I am trying to remove the borders when saving the document as PDF.

    I want to remove the white border completely but keep everything else the same format.

    border.png

    Many Thanks,

    Mon

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: How to fit to 1 page on excel - remove the borders.

    It is not a border, it's the print margin. Go to Page Layout > Margins and set all the margins to 0. However, your data is set up to nicely fit in the center of the sheet. If you zero out the margins, you will have to reformat the sheet to put the data how you want it to appear. Otherwise you will get this.

    printing 0 margin.jpg
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Valued Forum Contributor
    Join Date
    08-31-2007
    Location
    SW Ireland
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2311 Build 16.0.17029.20068) 32-bit
    Posts
    523

    Re: How to fit to 1 page on excel - remove the borders.

    Not sure if it's totally possible but I think that you could try changing the margins (see bottom left of the image for where this is done).
    Excel 365 user. To unblock a downloaded macro-enabled workbook, go to your "Downloads" folder > right click on the workbook name > click 'Properties' > check the 'Unblock' checkbox. You can now open the workbook.

+ 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] Remove Excel's default gray cell borders permanently [Sharing Tips]
    By jubitips in forum Tips and Tutorials
    Replies: 2
    Last Post: 10-31-2023, 12:54 AM
  2. [SOLVED] Remove grey lines/borders around pictures (that were inserted into Excel using a macro)
    By Koloth in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-26-2021, 01:47 AM
  3. Replies: 3
    Last Post: 11-14-2016, 04:37 PM
  4. Auto size and remove borders from Excel charts
    By 2lkopp3n in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-09-2012, 09:57 AM
  5. Page Borders?
    By Turquoise_dax in forum Excel General
    Replies: 1
    Last Post: 06-30-2006, 05:20 PM
  6. AGAIN: Page Borders (Seems like nobody knows...:))
    By Turquoise_dax in forum Excel General
    Replies: 0
    Last Post: 06-29-2006, 11:32 AM
  7. Replies: 1
    Last Post: 03-07-2006, 01: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