There are a couple different ways to change the size of a cell in Microsoft Excel, but the most common methods will require you to set your column width or row height using a unit of measure call that can be difficult to evaluate. This unit of measure in the number of characters that will be displayed in the cell. This may not be very helpful, however, if you need to set specific cell sizes in your workbook. Fortunately you can make a quick adjustment that will allow you to set your cell sizes in inches instead of the default unit that is used in Excel’s Normal view.
Our guide below will show you the steps to take so that Excel 2013 will let you enter values in inches instead of characters so that you can more easily set your cell sizes with a unit of measurement that is more familiar.
Setting Column Width and Row Height in Inches in Excel 2013
The steps in this article will assume that your Excel version is currently using the local unit of measurement that is preferred in your country. If not, then you can change the unit of measurement in Excel 2013 by clicking the File tab at the top-left of the window, clicking the Options button in the left column, Clicking the Advanced tab, then scrolling down and changing the Ruler Units setting in the Display section to your preferred unit of measurement.
Once the unit of measurement is correct, then you can follow these steps below to learn how to set cell sizes in inches instead of the default “characters” setting that it uses otherwise.
Step 1: Open your workbook in Excel 2013.
Step 2: Click 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 or row number that you wish to set in inches, then click either Column Width or Row Height.
Step 5: Enter the inch value that you would like to use for the column width or row height, then click the OK button.
If your Excel worksheet is not printing well, then you will probably need to change some settings. This article – https://www.solveyourtech.com/three-ways-to-fit-to-one-page-in-excel-2013/ – will show you three different ways that you can quickly adjust your worksheet to print the entire document on one page.
Matthew Burleigh has been writing tech tutorials since 2008. His writing has appeared on dozens of different websites and been read over 50 million times.
After receiving his Bachelor’s and Master’s degrees in Computer Science he spent several years working in IT management for small businesses. However, he now works full time writing content online and creating websites.
His main writing topics include iPhones, Microsoft Office, Google Apps, Android, and Photoshop, but he has also written about many other tech topics as well.
Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.