Options Advanced Display Ruler units (inches / cm / mm but not a pixels ) (or look in Page Layout) eg For Arial 10 (set in Normal style) = 75 pixels for Courier New 10 it will be 85 pixels Description of how column widths are determined in Excel or you can set pixels directly pixelsjpg where 85 = points 3 Drag the boundary below the row heading (rows) or the boundary to the right (columns) As you drag the line down (rows) or right (columns), the cell size will increase As you drag the line up (rows) or to the left (columns), the cell size will decrease To select multiple rows or columns, press and hold Ctrl (PC) or ⌘ Cmd (macOS) as youChange cell size to inches/cm/mm with setting Rule Units 1 Enable Excel, and click File or Office button > Options > Advanced See screenshot 2 Then go to right part and scroll down to the Display section, and select the unit you want to set the cell size from Ruler units list See 3 Click How To Change The Row Height Or Column Width To Inches Excel