Highlight the row you would like to change the column width for. Double-click on the right side of the column.
Zoom Saved
2
The column will then automatically adjust to the size needed by the text in the column.
Zoom Saved
Manually Adjust a Single Column Width
3
Click on the side of the column, hold down the edge of the cell and you can then drag to expand or shrink the width of the column.
Zoom Saved
4
This example dragged the column to the right to expand the "Inventory" column.
Zoom Saved
5
Dragging the right hand side of the column back towards the left minimized that single column and did not impact the size of any other columns.
Zoom Saved
Formatting All Columns and Rows in a Sheet
6
In the "Home" tab, click "Format"
Zoom Saved
7
From this drop down, you can adjust the column width for a single column or all columns in the sheet.
Zoom Saved
8
If you select column width, a pop up will ask you how large you would like to make the column. If you do not highlight multiple rows or the entire sheet, Excel will default to only adjusting the column where your cursor is currently located.
Zoom Saved
9
If you select multiple columns or the entire sheet, Excel will alter those columns. If you do not need to have each column the same size and would instead prefer the text in each column fit correctly, select "Autofit Column Width".
Zoom Saved
Adjusting Row Height
10
To ensure all rows are formatted the same way, start by highlighting the entire sheet or selecting the rows you would like to be formatted; then click "format".
Zoom Saved
11
From the formula bar, you can either select "row height" which will ask for a size number, or select "autofit row height". For this example, we will select "row height".
Zoom Saved
12
You can enter a size for how long you would like each row to be. Excel will then adjust all rows that you have selected. Once the rows are sized how you would like them, click "ok".
Zoom Saved
13
You can now see the rows have been adjusted to the same size you selected.
Zoom Saved
Change Default Row Height in Your Excel
14
If you change the size of your row height often, you can alter the default row size. Start by selecting "format".
Zoom Saved
15
Click "Default Width..."
Zoom Saved
Was this Scribe helpful? Save this document for future reference.
Save for Later
Have something to say?Create an account to leave messages for the author to see!Create an account
Feedback
This Scribe is in tip-top shape!Leave feedback if there are any issues with this Scribe