Have all sheets A4 and columns A4 to look neat and consistent

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

• Margins - Normal
• Size - A4
• Print titles - off
• Gridlines - off
• Headings - off

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.