Compiling Only One Column From Fixed Width Txt File And Including File Name Excel Vba Stack Overflow Set Cell Size in Cm #1 click FILE tab, click Options menu from the popup menu list And the Excel Options window will open #2 click Advanced tab in the left section of Excel Options window, move to the Display section in the right of window #3 set the Rule units as Centimeters under DisplaySelect a column and right click on it and select Column width (Kolombreedte) and magically you now have the ability to set the column width in your desired unit of measurement For Row height select a row and follow the same procedure Column width in excel in cm