The flexibility of the Excel application means that you can configure just about any setting for your spreadsheet that you might want to change.
One of these settings is the width of your columns and the height of your rows. Unfortunately this setting is defined by a unit of measurement called “points” when you are changing the setting in the Normal view. This isn’t very useful if you are defining your field widths to meet specific sizes. Fortunately by changing the view in Excel you can also change the unit of measurement that is used, which allows you to set the column width in inches.
How to Use Inches to Set the Width of Columns in Excel
The steps in this article were performed in the Excel for Office 365 version of the application, but will work in other versions of the program, too.
Step 1: Open your spreadsheet in Excel.
Step 2: Select the View tab at the top of the window.
Step 3: Click the Page Layout button in the Workbook Views section of the ribbon.
Step 4: Click the column letter of the column that you want to resize.
Step 5: Right-click the column letter, then choose the Column width option.
Step 6: Enter the desired column width in inches, then click the OK button.
Do you often work with spreadsheet data that includes a lot of negative numbers? Find out how to make those negative numbers red so that they are easier to identify in the spreadsheet.