Discover the various methods to hide, show, and change the dimensions of rows and columns in Excel. This inclusive guide primarily focuses on operations related to columns, but they are also applicable to rows unless otherwise specified.
In this blog, we’ll explore the various ways to hide and show rows and columns in Excel, as well as change the height or width. The bulk of the discussion will address columns, but it applies to rows as well (unless otherwise noted).
You can change column width by dragging the column separator (the little line between columns) left or right. To change the width of column D, you drag the separator between D and E left (narrower) or right (wider):
In the following figure, the column separator between D and E is clicked (notice the cursor shape), the mouse is held down, and dragged to the right:
If you drag it to the left enough it will narrow or hide the column (when the width becomes 0 it’s hidden):
Or:
When you let go of the mouse there’s a double-line indicating that column D is missing (this shape varies with the version of Excel used):
But when headings are not shown (from the View tab you can turn them off), there’s no indication a column is missing. Here, it looks like cell D3 is selected, but in fact it’s E3 because column D is hidden:
Another way to hide the column is select any cell in the column, say D1, then on the Home tab, in the Cells group, there’s a Format dropdown which has access to the Column Width:
When you issue the command, you get a dialog with the current width, like this:
And you can type in any number from 0 to 255. When you type 0, the column is hidden.
You can also hide a column via Home/Format/Hide & Unhide/Hide Columns.
There’s also a shortcut to hide a column. Whichever column is selected will become hidden when you press Ctrl/0 (a row will hide when you press Ctrl/9). Ctrl/shift/9 will unhide the column (Ctrl/shift/0 will unhide the row.)
All of the above applies to more than one column as well. If you select A1:E1 and use any of the methods, all 5 columns will hide.
Okay, how about unhiding? Again, there are several ways. It’s not as easy to select a hidden column, however! So you can type the cell address into the name box to get the cursor into the column, or, you can press the F5 key (Go To), and type in the cell address. Here, D1 was entered into the name box:
And then cell D1 became selected. You can unhide this with the column width command we saw above, change the 0 which will be there to 8.43, or any number, etc. This is not literally unhiding – it’s resetting the column width to a number. Unhiding will restore the width to what it was before it was hidden! You can unhide it by Home/Format/Hide & Unhide/Unhide Columns:
You can also select the columns before and after the hidden column and unhide them (only the hidden ones will be affected). Here, C thru E is selected:
And finally (for this article), you can carefully position the cursor a little to the right of the D-column separator (in this example) so it looks something like this:
Then drag to the right which will reveal column D as well!
Lastly, for this article, suppose you have text like this:
And you want to widen column C so it all fits in it. You can drag the column separator between C and D to the right and visually adjust it, or you can double-click the column separator which does a “best-fit” for the longest cell in that column, or you can select a few cells (vertically or horizontally) or the entire column, and use Home/Format/AutoFit Column Width:
Enjoy!
.JPG)