Jan 29 2022 05:25 AM
Hi there
I need assistance with formatting a document. I have tried searching online but could not find an answer. I'm going to try my best to explain what I am struggling with.
I have an Excel document with multiple sheets. Inside each sheet is cost estimates. All sheets have the same descriptions as the cells (column description). When I try and export as PDF and scroll down the document, each sheets columns are at different points. This means the document looks inconsistent and messy.
Is there a way I can "set" the column width and keep them locked so that I can apply them to all the sheets and make them look consistent when you export to PDF and scroll down the document?
I have tried:
Page layout
They come out nice in A4, but every sheet has the same columns and "headings" in each cell, however, the sizes differ. When I right-click and change column size, it keeps formatting over again.
Jan 29 2022 05:46 AM