+ 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, MS 365
    Posts
    3,873

    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

+ 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. Replies: 18
    Last Post: 04-11-2015, 12:48 PM
  2. Replies: 9
    Last Post: 04-17-2014, 11:55 AM
  3. Replies: 1
    Last Post: 02-12-2013, 12:16 PM
  4. How to combine table rows to one print area?
    By vladimirdes in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-01-2011, 07:13 PM
  5. Replies: 8
    Last Post: 05-23-2007, 06:39 AM
  6. Replies: 4
    Last Post: 02-17-2006, 08:36 AM
  7. [SOLVED] Pivot Table macro to set print area and print details of drill down data
    By Steve Haskins in forum Excel General
    Replies: 2
    Last Post: 12-28-2005, 01:10 PM

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