Excel Page end problems between Windows and Mac

%3CLINGO-SUB%20id%3D%22lingo-sub-1811517%22%20slang%3D%22en-US%22%3EExcel%20Page%20end%20problems%20between%20Windows%20and%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1811517%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20got%20a%20problem%20with%20page%20breaks.%20My%20colleagues%20are%20working%20in%20Excel%20on%20a%20windows%20computer.%20When%20they%20open%20the%20document%20the%20page%20layout%20is%20OK.%20When%20I%20open%20the%20file%20on%20Excel%20for%20Mac%20(Iatest%20version)%20I%20have%20page%20endings%20on%20a%20different%20postion.%20Page%20breaks%20are%20inserted%20(solid%20blue%20lines).%20So%20instead%20of%20having%20everything%20on%20a%20page%20its%20spread%20over%202%20pages.%20I%20can%20solve%20this%20but%20once%20saved%20my%20colleagues%20have%20this%20issue%20when%20opening%20it.%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20way%20to%20solve%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethx%20IK%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1811517%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1811670%22%20slang%3D%22de-DE%22%3ESubject%3A%20Excel%20Page%20end%20problems%20between%20Windows%20and%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1811670%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F843307%22%20target%3D%22_blank%22%3E%40iRemark%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22text-wrap%20tlid-copy-target%22%3E%3CDIV%20class%3D%22result-shield-container%20tlid-copy-target%22%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EExcel%20for%20Windows%20and%20Excel%20for%20Mac%20are%20not%20identical%2C%20the%20column%20widths%20of%20the%20two%20programs%20are%20inherently%20different%20and%20different%20units%20are%20used%20to%20calculate%20the%20column%20width.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EThe%20column%20width%20in%20Excel%20for%20Windows%20depends%20on%20the%20standard%20font.%3C%2FSPAN%3E%20%3CSPAN%3EIf%20you%20use%20Calibri%2011%20as%20the%20standard%20font%20and%20have%20a%20column%20width%20of%2010%2C%20this%20means%20that%2010%20characters%20of%20the%20Calibri%2011%20font%20fit%20into%20one%20cell.%20Changing%20the%20standard%20font%20also%20changes%20the%20width%20of%20the%20columns.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EA%20column%20width%20of%20e.g.%3C%2FSPAN%3E%20%3CSPAN%3E10%20in%20Excel%20for%20Windows%20does%20not%20match%20a%20column%20width%20of%2010%20in%20Excel%20for%20Mac.%3C%2FSPAN%3E%20%3CSPAN%3EYou%20therefore%20have%20to%20convert%20the%20column%20width%20and%20adjust%20it%20on%20the%20Mac.%3C%2FSPAN%3E%20%3CSPAN%3EAlso%20make%20sure%20that%20you%20have%20set%20a%20font%20in%20Excel%20for%20Windows%20that%20is%20also%20available%20on%20the%20Mac.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%20class%3D%22tlid-result-transliteration-container%20result-transliteration-container%20transliteration-container%22%3E%3CDIV%20class%3D%22tlid-transliteration-content%20transliteration-content%20full%22%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FDIV%3E%3CP%3E%3CFONT%20size%3D%223%22%3EAnswer%3A%3C%2FFONT%3E%3CBR%20%2F%3E%3CFONT%20size%3D%223%22%3E%3CA%20href%3D%22https%3A%2F%2Fanswers.microsoft.com%2Fde-de%2Fmsoffice%2Fforum%2Fall%2Fanzeige-unterschied-zwischen-excel-win-und-excel%2Fb5a4d675-c093-440e-9bcc-ce71a4217341%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fanswers.microsoft.com%2Fde-de%2Fmsoffice%2Fforum%2Fall%2Fanzeige-unterschied-zwischen-excel-win-und-excel%2Fb5a4d675-c093-440e-9bcc-ce71a4217341%3C%2FA%3E%3C%2FFONT%3E%3C%2FP%3E%3CH1%20id%3D%22toc-hId-581847212%22%20id%3D%22toc-hId-581847212%22%3E%3CFONT%20size%3D%223%22%3EColumn%20Width%20Unit%20of%20Measure%20in%20Excel%20Versions%3C%2FFONT%3E%3C%2FH1%3E%3CP%3E%3CA%20href%3D%22http%3A%2F%2Fexcelsemipro.com%2F2010%2F10%2Fcolumn-width-unit-of-measure-in-excel-versions%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%3CFONT%20size%3D%223%22%3Ehttp%3A%2F%2Fexcelsemipro.com%2F2010%2F10%2Fcolumn-width-unit-of-measure-in-excel-versions%2F%3C%2FFONT%3E%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWish%20you%20a%20nice%20day.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%222%22%3E*%20Kindly%20Mark%20and%20Vote%20this%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20community%20members%20reading%20here.%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi,

 

I've got a problem with page breaks. My colleagues are working in Excel on a windows computer. When they open the document the page layout is OK. When I open the file on Excel for Mac (Iatest version) I have page endings on a different postion. Page breaks are inserted (solid blue lines). So instead of having everything on a page its spread over 2 pages. I can solve this but once saved my colleagues have this issue when opening it. 

Any way to solve this?

 

thx IK

3 Replies
Highlighted

@iRemark 

Excel for Windows and Excel for Mac are not identical, the column widths of the two programs are inherently different and different units are used to calculate the column width.

The column width in Excel for Windows depends on the standard font. If you use Calibri 11 as the standard font and have a column width of 10, this means that 10 characters of the Calibri 11 font fit into one cell. Changing the standard font also changes the width of the columns.

A column width of e.g. 10 in Excel for Windows does not match a column width of 10 in Excel for Mac. You therefore have to convert the column width and adjust it on the Mac. Also make sure that you have set a font in Excel for Windows that is also available on the Mac.
 

Answer:
https://answers.microsoft.com/de-de/msoffice/forum/all/anzeige-unterschied-zwischen-excel-win-und-ex...

Column Width Unit of Measure in Excel Versions

http://excelsemipro.com/2010/10/column-width-unit-of-measure-in-excel-versions/

 

I would be happy to know if I could help.

 

Wish you a nice day.

 

Nikolino

I know I don't know anything (Socrates)

 

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.

Highlighted

@Nikolino Thx for your quick answer. I now can stop searching for a solution...

 

Quite disappointing that this can't be solved. We work with 8-10 Mac's and approx. 15 windows stations and need to work in the same documents. We thought Excel = Excel....

 

but thx anyway.

Highlighted

@iRemark 

Here are a few file formats with which you could possibly save so that it can be read by mac on windows and vice versa. Maybe it will help you to find a temporary solution.

 

File formats supported in Excel for Mac

https://support.microsoft.com/en-us/office/file-formats-supported-in-excel-for-mac-f9970726-bb98-489...

 

Thank you for your understanding and patience

 

Wish you a nice day.

 

Nikolino

I know I don't know anything (Socrates)