How to Set a Fixed Height & Width in Excel

By Shawn McClain

Updated September 28, 2017

In an Excel 2010 spreadsheet, the cell height and width determine the overall size of each column and row of cells. Although you can click and drag each column or row to size it individually, Excel also lets you input a fixed width and height for the columns and rows. The column width value is determined by how many characters of the standard font can fit into the cell and is set at a default value of 8.43. The row height is done on a point system, with one point equal to one-seventy-second of an inch, and the default value is 12.75.

Open the Microsoft Excel 2010 file with which you want to work.

Click and hold the mouse button on the row number or column letter that you want to adjust to a fixed height and width. Then drag the mouse to select the adjacent rows or columns. You can then press "Ctrl" and click to select nonadjacent columns or rows. If you want to change the height and width of the cells for the entire spreadsheet, just click the box to the left of "A" and just above "1."

Click the "Home" tab at the top of the screen. Locate the Cells area of the Ribbon and click on the "Format" button found there.

Choose "Row Height" from the menu, and a small window appears. Type the value for your desired row height and click "OK."

Click the "Format" button again and choose "Column Width" from the menu. Enter your desired column width into the small window that appears and click "OK." Your column width and row height are now set.


If you want to lock the cell width and row height, you have to select "Protect Sheet" from the Format menu. Place a checkmark next to everything except "Format Columns" and "Format Rows," then click "OK." Anyone who access the sheet will not be able to change the cell height or width without first turning off this protection.