+ Reply to Thread
Results 1 to 5 of 5

Shapes do not print when some rows are hidden

  1. #1
    Registered User
    Join Date
    07-13-2014
    Location
    USA
    MS-Off Ver
    2010
    Posts
    13

    Shapes do not print when some rows are hidden

    I have a worksheet with some shapes. When printing this sheet, shapes on visible rows do not print. If I unhide the rows, the shapes print. I have attached the file. Rows 51 to 246 are hidden on this sheet.

    Any help will be appreciated.
    sjmxls
    Attached Files Attached Files

  2. #2
    Forum Guru Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,249

    Re: Shapes do not print when some rows are hidden

    Change your print area to exclude the hidden rows.
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

  3. #3
    Registered User
    Join Date
    07-13-2014
    Location
    USA
    MS-Off Ver
    2010
    Posts
    13

    Re: Shapes do not print when some rows are hidden

    Quote Originally Posted by Olly View Post
    Change your print area to exclude the hidden rows.
    Thank you for the response. However it did not work.
    Also, I noticed, if I change the print scaling to 100% normal size, the shapes print regardless of setting print area. However, I need to print to single sheet.
    Last edited by sjmxls2; 07-14-2014 at 11:03 AM.

  4. #4
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,635

    Re: Shapes do not print when some rows are hidden

    clear print area
    put scaling to fit 1 sheet wide

    if you un-hide the hidden rows your scaling will put it all on my sheet
    Attached Files Attached Files
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  5. #5
    Registered User
    Join Date
    07-13-2014
    Location
    USA
    MS-Off Ver
    2010
    Posts
    13

    Re: Shapes do not print when some rows are hidden

    Thank you.

+ 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. Hidden shapes
    By Cessh in forum Excel General
    Replies: 4
    Last Post: 05-07-2014, 01:25 PM
  2. [SOLVED] How to hide shapes along with the hidden columns.
    By jonelamora in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-25-2014, 02:54 AM
  3. Shapes are shifting when I Print/Print preview
    By 31RHCP in forum Excel General
    Replies: 0
    Last Post: 08-24-2010, 01:48 PM
  4. Replies: 2
    Last Post: 07-20-2006, 02:51 PM
  5. deleting hidden rows so i can print only the rows showing??????
    By jenn in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-06-2005, 12:05 PM

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