Select Page

Let’s Have Data Fun with Excel: Column and Row Width

by | Oct 27, 2020 | Uncategorized | 0 comments

Has it ever happened to you, where you open an excel file and you notice the column names are cut off and you can’t see all the information you want to look at? 

One thing you can do, to widen the column width is select the column. Then go on the menu, under ‘Cells’, click ‘Format’ and click ‘AutoFit Column Width’.

That will widen the column to the largest or longest name in your column.

A faster way of doing that is, selecting your column that you need to widen and double left-click at the end of the column, in between the columns.

It will also automatically widen the column to the widest field.

As you might suspect, you can also do that with the row height.

We can’t quite see what’s going on in row 8.

We select the row, go to ‘Format’, ‘AutoFit Row Height’. 

Now we can see the info in row 8.

You can also use the double click method. Just find the row that you need to make larger.

You double click underneath the row. And it will grow the maximum size of the cells in that row. 

I’m Peter Koebel the owner of Data Sciencing Consultants. If you need assistance with your Excel spreadsheets, you can contact us at 204-770-6437, peter.koebel@datasciencing.com, or visit our website https://datasciencing.com.

You can also view my companion video for this Excel tip here: https://www.youtube.com/watch?v=U1Ck79hW1TY

Looking for more fun with data? You might enjoy some of our other posts!

Survivorship Bias in Business

Survivorship Bias in Business

What is your company doing to not get duped by the survivorship bias trap? I’ll give you a classic example of survivorship bias. You might recognize this picture if you’ve studied survivorship bias, statistics, or data visualization. In World War 2 the U.S. Military...