Excel Cell Width Wont Work, Please help.

Copper Contributor

Hi Lovely Community :)

I am having the biggest issue with Excel and it is driving me Mad.

What should be simple is not. Why?

I am trying to make my cell height and width 5mm i.e. square but it will not let me it keeps reverting to 4.87mm.

I go to view, page layout, then home and put in the cell height and width and it will not for the life of me let me put 5mm but keeps reverting to that same annoying 4.87mm.

Why? What is the issue here? Is there a trick I don't know about? Is there a work around to this?

Please help, I need this for a specific work purpose and it has to be 5mm square.

Thanks team I know one of you will be able to help :)

5 Replies
Does your cells have a content/value? if it does, try enabling the 'Wrap Text'.

@Rr_ Thanks for your reply. No this is a blank workbook, just to have as a work pad with squares with lines like a grid.

I have decided to give up and do this design in word as a table where it is not giving me grief!

@KC_xo 

Excel can't set the wight exactly in mm. It operates with points (=1/72 of the inch) and pixels (number of dots per inch). In behind that's rounded, if ask for 5mm it will be rounded to nearest number of points. I don't remember exact algorithm, las time I seen it was about 10 years ago. You may google for the relationship between mm, points and pixels.

@Sergei Baklan Thanks for your reply.

You can change it to mm in the advance setting. But that isn't the issue at hand its getting it to change the cell widths to the 5mm. But this is not possible in my opinion.

@KC_xo 

No this is a blank workbook, just to have as a work pad with squares with lines like a grid.

I have decided to give up and do this design in word as a table where it is not giving me grief!

 

That--doing it in Word--is what I came in to suggest. So I'm glad you came to that on your own.

 

I can understand why you may have started with Excel, but given that you weren't really seeking to use Excel for the things Excel does well (calculations, databases, etc), it helps to realize that the rows and columns aren't there for their own sakes.