I just want to create a sheet with cell width of 15mm and height of 10mm, I've made sure the cell size is set to millimetres and highlighted the row/column and set width as 15 and 10 but it will not make the cells the right size, could someone tell me what I'm doing wrong?
If you are in Normal view these numbers (as 10 and 15) are always in points. In Page Layout view you may specify in inches, cm and mm (e.g. as "10 mm"). And/or specify default units for Page Layout in File->Options->Advances->Display->Ruler Units