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...
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)
Bookmarks