• Skip to main content

masteryourtech.com

Mobile phones, software, consumer electronic how-to guides

  • iPhone
  • Excel
  • Powerpoint
  • Word
  • Google Drive
You are here: Home / Excel / How to Set Excel Column Width in Inches

How to Set Excel Column Width in Inches

posted on March 20, 2019

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.

excel click the view tab

Step 3: Click the Page Layout button in the Workbook Views section of the ribbon.

click the page layout button

Step 4: Click the column letter of the column that you want to resize.

choose the letter of the column to resize

Step 5: Right-click the column letter, then choose the Column width option.

how to change column width in excel

Step 6: Enter the desired column width in inches, then click the OK button.

how to set the excel column width in inches

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.

Share this:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)

Related

Filed Under: Excel

Search

  • Contact Us
  • Privacy Policy
  • Terms and Conditions

Copyright © 2022 MasterYourTech.com

 

Loading Comments...
 

You must be logged in to post a comment.