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

%3CLINGO-SUB%20id%3D%22lingo-sub-3085689%22%20slang%3D%22en-US%22%3EHave%20all%20sheets%20A4%20and%20columns%20A4%20to%20look%20neat%20and%20consistent%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3085689%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20assistance%20with%20formatting%20a%20document.%20I%20have%20tried%20searching%20online%20but%20could%20not%20find%20an%20answer.%20I'm%20going%20to%20try%20my%20best%20to%20explain%20what%20I%20am%20struggling%20with.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20an%20Excel%20document%20with%20multiple%20sheets.%20Inside%20each%20sheet%20is%20cost%20estimates.%20All%20sheets%20have%20the%20same%20descriptions%20as%20the%20cells%20(column%20description).%26nbsp%3B%20When%20I%20try%20and%20export%20as%20PDF%20and%20scroll%20down%20the%20document%2C%20each%20sheets%20columns%20are%20at%20different%20points.%20This%20means%20the%20document%20looks%20inconsistent%20and%20messy.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20I%20can%20%22set%22%20the%20column%20width%20and%20keep%20them%20locked%20so%20that%20I%20can%20apply%20them%20to%20all%20the%20sheets%20and%20make%20them%20look%20consistent%20when%20you%20export%20to%20PDF%20and%20scroll%20down%20the%20document%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20tried%3A%3C%2FP%3E%3CP%3EPage%20layout%3C%2FP%3E%3CUL%3E%3CLI%3EMargins%20-%20Normal%3C%2FLI%3E%3CLI%3ESize%20-%20A4%3C%2FLI%3E%3CLI%3EPrint%20titles%20-%20off%3C%2FLI%3E%3CLI%3EGridlines%20-%20off%3C%2FLI%3E%3CLI%3EHeadings%20-%20off%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThey%20come%20out%20nice%20in%20A4%2C%20but%20every%20sheet%20has%20the%20same%20columns%20and%20%22headings%22%20in%20each%20cell%2C%20however%2C%20the%20sizes%20differ.%20When%20I%20right-click%20and%20change%20column%20size%2C%20it%20keeps%20formatting%20over%20again.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-left%22%20image-alt%3D%22Screenshot%202022-01-29%20at%2015.15.49%20(2).png%22%20style%3D%22width%3A%20981px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F343566iFFE0B0CD71D4E6B5%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%202022-01-29%20at%2015.15.49%20(2).png%22%20alt%3D%22Screenshot%202022-01-29%20at%2015.15.49%20(2).png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3085689%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3085774%22%20slang%3D%22fr-FR%22%3ERe%3A%20Have%20all%20sheets%20A4%20and%20columns%20A4%20to%20look%20neat%20and%20consistent%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3085774%22%20slang%3D%22fr-FR%22%3Ethe%20sum%20function%20does%20not%20calculate%20correctly.%20can%20you%20help%20me%20please.%3C%2FLINGO-BODY%3E
New 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.