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

Copper Contributor

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. 

 

 

Screenshot 2022-01-29 at 15.15.49 (2).png

 

1 Reply
la fonction somme ne calcule pas correctement. pouvez vous m'aider svp.