Hello! I'm setting up a bunch of data entry worksheets that are by default in the "Page Layout" view in Excel, which shows multiple pages next to each other. We work in just the first column of pages usually, and all pages with no data (second column onward) are hidden. For the data entry, it is useful to extend tables onto the page just to the right, which is in the second column of pages.
My issue is that sometimes adding data to one of these pages causes all of the pages above it in the column to become active, so there are a bunch of blank pages when the document is completed and printed/turned into PDF. I say sometimes because this doesn't happen in all documents. Some documents keep those pages hidden, so it just prints the extra pages and not those blank ones.
Is there some setting I'm missing to hide those pages, or is there something manual I can do to hide these? If it were consistent across all of my workbooks, I'd understand, but it's... not. Using VBA is probably not an option, but if there's something elegant I can put in, I'm willing to try.
Thanks in advance!
My issue is that sometimes adding data to one of these pages causes all of the pages above it in the column to become active, so there are a bunch of blank pages when the document is completed and printed/turned into PDF. I say sometimes because this doesn't happen in all documents. Some documents keep those pages hidden, so it just prints the extra pages and not those blank ones.
Is there some setting I'm missing to hide those pages, or is there something manual I can do to hide these? If it were consistent across all of my workbooks, I'd understand, but it's... not. Using VBA is probably not an option, but if there's something elegant I can put in, I'm willing to try.
Thanks in advance!
