How to AutoFit All Columns in Excel 2013

Last updated: January 24, 2017

Learning how to autofit in Excel 2013 can be very useful for any Excel user that gets frustrated when their columns are only displaying part of their data. This can make your data very difficult to read, and can even lead to mistakes if someone is reading your spreadsheet and evaluating its contents based on what they see, rather than the full pieces of data contained within the cells.

This issue can be fixed by resizing the columns so that they are large enough to display all of the data in the cells, but this can be time consuming when you are dealing with a large number of columns. Fortunately Excel 2013 has an option that will allow you to automatically resize all of your columns to fit the largest piece of data in that column.


Automatically Make All Columns the Correct Width in Excel 2013

The steps in this tutorial will show you how to automatically make all of your columns large enough to fit the largest piece of data in the column. If your columns contain different sized data, then it is very likely that each column will have a different width.


Step 1: Open your spreadsheet in Excel 2013.


Step 2: Click the button at the top-left corner of the spreadsheet, between A and 1.

select all of the columns



Step 3: Click the Home tab at the top of the window.

click the home tab



Step 4: Click the Format button in the Cells section of the navigational ribbon, then click the AutoFit Column Width option.

click the autofit column width option



You can also autofit in Excel 2013 by selecting a column (or columns) then double-clicking on the right border of the column heading. You would position your mouse as shown in the image below, then double-click. The mouse cursor will switch to the vertical line with an arrow coming out of either side that you see indicated below.

how to autofit in excel 2013


Both of the methods shown above can be applied to rows as well, if you need to autofit rows in Excel 2013, too. You can autofit in Excel with any number of rows or columns that you wish. For example, I have four columns selected in the image above, but the same method of double-clicking the column header border would work if I had only selected one column instead.

If you would like to set multiple Excel columns to the same width (not the same as autofit. You manually enter a value for the column width with this method), then you can learn how with this article. newsletter

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.