Select the column letters within the range. We can select multiple columns by click and dragging if the cells are next to each other or by holding Ctrl (Windows) or Cmd ⌘ (Mac) to click the other column labels which will select them.
In our example the cells in Columns C, E and F are unnecessarily big for the data. We will select the first column which is C then by holding Ctrl (Windows) or Cmd ⌘ (Mac) we will click columns E and F to select them.
2. Right Click and Click “Resize the selected columns”
Hover the mouse over the last selected column and right click to display the menu. From this menu select Resize the selected columns.
3. Set the Desired Column Width
A pop up box will now display. Make sure the option for Enter new column width in pixels is selected and enter your custom column width in the box below this.
In our example we will set a column width of 80 pixels.
4. Select OK to see the Results
Click OK and the column width will be applied.
Make Rows in a Selected Range the Same Size
1. Select the Rows of the Selected Range
Select the row labels of the cells within the range. To select multiple columns click and drag if the rows are next to each other. If the rows are not hold down Ctrl (Windows) or Cmd ⌘ (Mac) and click each row individually.
2. Right click and Click Resize rows
Right click anywhere in the highlighted area and select Resize rows X - X where X marks the selected row numbers. In our example we will select Resize rows 1-9
3. Set the Desired Row Height
A pop up box will now display. Make sure the option for Specify row height is selected and enter your desired height in pixels. We will enter the default amount of 21.
4. Select OK and see the Results
Click OK and the row height will be applied to the size set.