Multiplication table sizing

[Matt B.]

I am creating a large multiplication table (40 X 40) for an upcoming
inventory for my company. I am having trouble sizing the format to make it
readable. The cells and values are way too small to be readable. How do i fit
it all to one page and still make it readable by normal eyes?

 

[Matt S]

Would it work to change the size of the font, then select all columns and
rows, and make them bigger. Then on the print page box, fit to one page.

 

[Gord Dibben]

There is only so much you can fit on a page.

You cannot fit 2 litres into a 1 litre container.

Larger paper size would help.


Gord Dibben MS Excel MVP

 

[Matt B.]

I changed the size of the font and the cells. The cells got bigger, and
expanded, but the font did not change. There was just more empty box space. I
tried fit to page, etc......tried formatting for 3 hours and could not
succeed.