+ Reply to Thread
Results 1 to 2 of 2

Amend the print/export area of a excel table

  1. #1
    Registered User
    Join Date
    01-06-2020
    Location
    London
    MS-Off Ver
    2019
    Posts
    2

    Lightbulb Amend the print/export area of a excel table

    I am using a tool called Miro which I can connect to excel sheets via OneDrive to show visuals I have created (in an effort to create a quick and dirty style dashboard).

    The benefit of doing this is the visuals can be refreshed based on amends made in OneDrive.

    I am pulling in certain graphs but when it imports into the software it comes through in a A4 style size (e.g. a large section of white space below).

    Screenshot 2020-01-08 at 09.24.03.png

    Screenshot 2020-01-08 at 09.24.15.png

    Is there a way in excel to define the area which will only be printed/exported.

    NOTE - I have tried using 'Print Selection', Putting the excel sheet in Page Layout and amending the borders and I am still getting similar results.

    The closest I have gotten to is putting the sheet in landscape and reducing the borders as much as possible

    Thanks

  2. #2
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019
    Posts
    3,775

    Re: Amend the print/export area of a excel table

    Hi,

    You can move the Chart to a new Chart Sheet and then print.
    Cheers!
    Deep Dave

    www.NeedForExcel.com

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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