Change Cell Size in Pixels or Inches in Excel & Google Sheets

This tutorial demonstrates how to change cell size in pixels or inches in Excel and Google Sheets.

 

changecellsize intro

 

Change Ruler Units From Pixels to Inches

Sometimes you’ll need to change cells’ sizes in inches – rather than pixels – to accurately match your data or template. One way to do that is to use the Format feature.

  1. To change the ruler units from the default to inches, in the Ribbon go to Files and click on the Options.

 

change cell size pixels inches 1

 

  1. The Excel Options window opens. (1) From the right-side menu, choose Advanced and then on the left, scroll to the Display section. In it, (2) click on the box next to Ruler units and from the list, (3) choose Inches. (4) Click OK.

 

change cell size pixels inches 2

 

Change Cell Size by Formatting

Whether you’re using pixels or inches, changing a cell’s size works the same way

  1. In the Ribbon, go to View > Page Layout.

 

change cell size pixels inches 20

 

  1. To change the cell width, select the cells you want to resize, and then in the Ribbon go to Home > Format > Column Width.

 

change cell size pixels inches 21

 

  1. In the Column width box, enter the new size in inches (here, 1.5 inches) and click OK.

 

change cell size pixels inches 22

 

This changes the width of the cell.

 

change cell size pixels inches 23

 

  1. To change the height of the cells, select the cells you want to resize, and then in the Ribbon go to Home > Format > Row Height.

 

change cell size pixels inches 24 new

 

  1. In the Row height box, enter the new size in inches (here, 1 inch) and press OK.

 

change cell size pixels inches 25

 

This changes the height of the cells.

 

change cell size pixels inches 26

 

Change Cell Size by Dragging

Another way to change cells sizes in inches or pixels is by dragging.

  1. Change the view from Normal to Page Layout. In the Ribbon go to View > Page Layout.

 

change cell size pixels inches 20

 

  1. To change the width of the cells, just place the cursor on the boundary on the right side of the column heading, When it changes to a double-headed arrow, drag it to the right to widen the cells or to the left to narrow them. You can see the width of selected cells in inches and pixels displayed in the box above the double-headed arrow. It allows you to measure exactly how much you want to change the width of the cells.

 

change cell size pixels inches 27

 

This changes the width of the cell.

 

change cell size pixels inches 28

 

  1. To change the height of the cells, place the cursor on the boundary on the bottom side of the row heading. When the cursor changes to a double-headed arrow, just drag it up to make cells shorter or drag it down to make cells taller. While dragging, a similar box displays the height of the selected cells in inches and pixels, so you can measure exactly how much you want to change the height of the cells.

 

change cell size pixels inches 29

 

This changes the height of the cell.

 

change cell size pixels inches 30

 

Change Back to Default Size

Cell Height

In Excel, the default cell height is 15. To change back to that height, follow these steps:

  1. To change back to default cell height, in the Ribbon go to View > Normal.

 

change cell size pixels inches 31

 

  1. Then, select the cells whose height you want to change back to the default size, then in the Ribbon, go to Home > Format > Row Height.

 

change cell size pixels inches 37

 

  1. In the Row height box enter 15 and click OK.

 

change cell size pixels inches 35

 

After that, the height of the selected cells goes back to the default size.

 

change cell size pixels inches 36

 

Cell Width

In Excel, the default cell width is 8.43. To change the cell width back to the default, follow these steps:

  1. First, select the cells whose widths you want to change back to their default size, and then in the Ribbon, go to Home > Format > Column Width.

 

change cell size pixels inches 38

 

  1. In the Column width box enter 8.43 and click OK.

 

change cell size pixels inches 33

 

As a result, the width of the selected cells goes back to the default size.

 

change cell size pixels inches 34

 

Note: You can use VBA code to revert to default cell sizes in Excel.

Change Cell Size in Google Sheets

To change the height and width of cells in the Google Sheets, follow these steps:

  1. To change the width of cells, select the column you want to resize, right-click it, and from the drop-down list, choose Resize column.

 

change cell size pixels inches 42

 

  1. In the dialog box, enter the new width (here, 200 pixels) in pixels and press OK.

 

change cell size pixels inches 43

As a result, the width of the column changes.

change cell size pixels inches 44

 

  1. To change cell height, select the row you want to resize, right-click it, and from the list, choose Resize row.

 

change cell size pixels inches 45

 

  1. In the dialog box, enter the height in pixels(here, 50 pixels) and click OK.

 

change cell size pixels inches 46

This changes the cells’ height.
change cell size pixels inches 47

 

Change to Default Cell Size in Google Sheets

In Google Sheets, the default cell width is 100 pixels, and the default cell height is 21 pixels.

  1. To change back to the default cell width, first select the column you want to resize, right-click it, and from the list, choose Resize column.

 

change cell size pixels inches 50

 

  1. In the dialog box, enter the value 100 and click OK.

 

change cell size pixels inches 51

 

As a result, the width of the selected column changes back to the default size.

 

change cell size pixels inches 52

 

  1. To change back to the default cell height, select the row to resize, right-click it, and from the list, choose Resize row.

 

change cell size pixels inches 53

 

  1. In the dialog box enter 21 and press OK.

 

change cell size pixels inches 54

 

After that, the height of the selected row changes back to the default size.

 

change cell size pixels inches 55