LinkBack URL
About LinkBacks
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
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
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...
Thank you for the response. However it did not work.Originally Posted by Olly
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.
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
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.
Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks