Sign in or start a free trial to avail of this feature.
7. Adjusting Columns and Rows
To make your datasets more readable, it's often necessary to change column width and row height. Let's do this with a few straightforward keyboard shortcuts.
Adjusting Column Widths (00:22)
The default common widths in Excel are often too narrow. The best way to deal with this is using the autofit column command. To use this column, you select a column, and use the shortcut Alt, O, C, A. This extends the column width so you can see the text in full. You can also use this command on multiple columns at once, to autofit all the columns in your data set in one command.
Alternatively, you can manually select the width of a column. To do this, select the column, press Alt, O, C, W, and select the desired width.
Adjusting Row Heights (02:26)
Row heights can be adjusted automatically or manually. To autofit row heights, you select the rows to be adjusted, and use the command Alt, O, R, A. To adjust row heights manually, select the rows, use the shortcut Right Mouse Button, R, and enter the desired row height.
You don’t often need to autofit row heights, but manually adjusting them can make data more readable.
In the previous lesson, we learned how to add, edit, and remove rows and columns from our dataset. As a result we now have a clean set of sales entries but not necessarily a very readable one. In this lesson we're going to make our dataset more readable by learning how to adjust column width and row height. Our biggest problem is that it's hard to read the column headings because the column widths are too narrow. This is a common problem in Excel and you might often see datasets where a user has manually dragged the width of a column by hovering the mouse between two columns like this, holding the mouse and dragging. A much better way of completing this task is to use the autofit column command. And of course, we have a shortcut for this. Alt + O C A. I'm going to demonstrate this by first undoing the change I made earlier with Control + Z, then navigating to the E column, selecting it with Control + Space bar and then performing Alt + O C A.
And you can see that this automatically extends the column so that the full heading, Order quantity, can be seen.
We can even perform Alt + O C A on multiple columns at the same time. Let's scroll to column H and select it with Control + Space bar, and then holding Control and Shift and the left arrow let's select the remaining columns in the dataset.
Then perform Alt + O C A. And this order fits all the columns in our dataset. Alt + O C A is a great time-saving shortcut. When I first access a datasheet, I will always autofit every column before performing any other task. For large datasets with dozens of columns you can imagine how much time this simple command can save you as opposed to manually adjusting each column width. When formatting columns I tend to just use Alt + O C A. But sometimes you might want to manually choose the width of a column. To do this, simply select the column, in this case the Address column.
And then press Alt + O C W.
I'll type in 60. Press okay. And you can see how this widens the column. I'll undo with Control + Z.
Now that we know how to adjust column width, let's move to row height. Rows typically don't create the same autofit problems that columns do, because most datasets do not have text on multiple lines. However if you do run into this problem, the shortcut Alt + O R A will autofit row height.
While you might not use autofit commands for rows you may often want to manually chance the row height to make data more readable. In this example let's increase the height of each data row by a couple of points and see the effect. First let's select the top row with Shift + Space bar. Then we'll select all the rows in the dataset by holding Control + Shift and pressing the down arrow key.
We'll then press the right mouse button, and then R to select row height. And we'll adjust the row height to 18.
By pressing the undo and redo command you can see how increasing the row height can make your data much more readable.
As with most commands in Excel, it's tempting to use the mouse to adjust row and column dimensions. But hopefully this lesson has shown you how easy it is to autofit columns and increase row height using a few simple shortcut commands.