Why does excel change the column widths when printed or viewed in page layout workbook view?

Question

I need my excel document cells to be square in normal view and when printed, but excel changes the width of the columns when printed or when viewed in the page layout view.

Normal View:

Page Layout View:

I can change the width in the page layout view to make the cells square when printed, but this messes up the width of the normal view. Is there any way to fix this issue?

Answer 1

I'm using excel to make some grid paper. I thought that it would be nice if the normal view and page layout view were similar because I was also going to make an automatic punnet square later on. Due to that, it would be nice to have the cells be square in normal view and when printed. If it's not possible, I can just deal with it. It's not completely necessary for it to be square in normal view, as long as it prints square (which it does when I adjust it in page layout view).

Answer 2

I found this about squares and Excel so it might help you. Pre-view print looks square, but I haven't actually printed a sheet to check to see it printed.

Set Excel Cell as A Square (excelmagicworld.com)