Home

Excel worksheet formatting differently on different machines

%3CLINGO-SUB%20id%3D%22lingo-sub-841646%22%20slang%3D%22en-US%22%3EExcel%20worksheet%20formatting%20differently%20on%20different%20machines%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-841646%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EI%20created%20this%20pricing%20template%20for%20my%20company%20and%2C%20one%20of%20the%20requirements%20was%20to%20be%20able%20to%20produce%20a%20proposal%20on%20the%20last%20page%20with%20the%20inputted%20info.%20I%20formatted%20it%20so%20it%20fits%20nicely%20on%20my%20machine%2C%20but%20when%20my%20co-workers%20download%20it%20off%20of%20one%20drive%20and%20they%20navigate%20to%20the%20page%20on%20the%20worksheet%20that%20the%20proposal%20is%20on%20it%20looks%20different.%20I%20leave%20two%20columns%20on%20the%20L%20and%20R%20hand%20side%20of%20the%20pages%20as%20a%20buffer%20but%20they%20seem%20to%20disappear%20or%20additional%20columns%20are%20added.%20The%20rows%20are%20also%20different.%20If%20on%20my%20worksheet%20the%20rows%20for%20the%20page%20are%2043-81%20theirs%20will%20be%20like%2043-83.%20I%20don't%20understand%20what%20setting%20is%20different.%20I%20checked%20that%20the%20rows%20heights%20and%20column%20widths%20are%20all%20the%20same%20throughout%20the%20diff%20machines.%20I%20attached%20photos%20and%20labeled%20them%20accordingly%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E1%20the%20first%20photo%20is%20on%20my%20co-workers%20mac%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E2%20the%20second%20is%20on%20my%20windows%20machine%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E3%20the%20third%20is%20on%20my%20coworkers%20windows%20machine%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20471px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F130520i5736FFCBC671DBDD%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22PRICING%20TEST%20MAC.png%22%20title%3D%22PRICING%20TEST%20MAC.png%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20722px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F130519i2AB243E4DFE7B9E6%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22pic2.PNG%22%20title%3D%22pic2.PNG%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20534px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F130521i3E9012735C2F65C4%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22pic1.PNG%22%20title%3D%22pic1.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-841646%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-844946%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20worksheet%20formatting%20differently%20on%20different%20machines%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-844946%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F404873%22%20target%3D%22_blank%22%3E%40Jookster1%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Ehave%20all%20the%20screenshots%20been%20taken%20in%20Page%20Layout%20view%3F%20It's%20not%20quite%20clear.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20any%20case%2C%20how%20much%20content%20fits%20on%20one%20page%20is%20VERY%20MUCH%20dependent%20on%20the%20printer%20that%20each%20computer%20is%20using.%20Different%20printers%20have%20different%20capabilities.%20Some%20can%20print%20closer%20to%20the%20paper%20edge%20than%20others.%20I%20suggest%20you%20look%20at%20the%20Page%20Break%20Preview%20on%20all%20computers%20and%20compare%20where%20the%20dashed%20blue%20lines%20are.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20need%20the%20content%20to%20be%20x%20pages%2C%20you%20may%20need%20to%20set%20manual%20page%20breaks%20and%20also%20use%20the%20print%20setting%20to%20scale%20(reduce%20the%20size)%2C%20so%20the%20content%20fits%20on%20x%20pages%20wide%20by%20y%20pages%20tall.%20Fill%20in%20the%20respective%20x%20and%20y%20after%20looking%20at%20the%20Page%20Break%20Preview.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Jookster1
Occasional Visitor

I created this pricing template for my company and, one of the requirements was to be able to produce a proposal on the last page with the inputted info. I formatted it so it fits nicely on my machine, but when my co-workers download it off of one drive and they navigate to the page on the worksheet that the proposal is on it looks different. I leave two columns on the L and R hand side of the pages as a buffer but they seem to disappear or additional columns are added. The rows are also different. If on my worksheet the rows for the page are 43-81 theirs will be like 43-83. I don't understand what setting is different. I checked that the rows heights and column widths are all the same throughout the diff machines. I attached photos and labeled them accordingly

1 the first photo is on my co-workers mac

2 the second is on my windows machine

3 the third is on my coworkers windows machine

PRICING TEST MAC.pngpic2.PNGpic1.PNG

 

 

1 Reply

Hello @Jookster1 ,

 

have all the screenshots been taken in Page Layout view? It's not quite clear. 

 

In any case, how much content fits on one page is VERY MUCH dependent on the printer that each computer is using. Different printers have different capabilities. Some can print closer to the paper edge than others. I suggest you look at the Page Break Preview on all computers and compare where the dashed blue lines are. 

 

If you need the content to be x pages, you may need to set manual page breaks and also use the print setting to scale (reduce the size), so the content fits on x pages wide by y pages tall. Fill in the respective x and y after looking at the Page Break Preview.

 

 

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies