lisagravy Posted September 17, 2019 Share Posted September 17, 2019 I have a reeeeeeally long worksheet generated from a load of data in my drawing. I want to display the whole thing on a sheet, but because there is so much information it doesn't fit on the page, and as such I want to split the worksheet (probably a couple of times, and ideally with the headers repeating!) so that I can fit all the info on one page neatly. I also want to still be able to recalculate the worksheet. Is this possible? Quote Link to comment
Boh Posted September 17, 2019 Share Posted September 17, 2019 Unless you split it into 3 seperate worksheets and play with the criteria so nothing is repeated then I think the only other options are to either place the worksheet on a design layer and create viewports of seperate portions or simply scale the worksheet to fit your page. Quote Link to comment
Jim Smith Posted September 19, 2019 Share Posted September 19, 2019 (edited) What we do is is what to is to what Boh notes; that is put the Worksheet on a Design Layer at 1:1 scaled & then make several Viewports taking care not to miss or duplicate cell rows. To ensure this we often add a blank cell row with the note "Continued...." Edited September 19, 2019 by Jim Smith 1 Quote Link to comment
trashcan Posted August 25, 2021 Share Posted August 25, 2021 Just looking at this! Wish I could crop without doing the workaround, but glad to know it's possible. 1 Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.