How to auto fit column width in Excel 2019

Posted By quikStarts

This guide is part of the Microsoft Excel 2019 series

1. How to add a background image in Excel 2019
2. How to add a column to a spreadsheet in Excel 2019
3. How to add a printer to the toolbar in Excel 2019
4. How to add a URL to a spreadsheet in Excel 2019
5. How to auto fit column width in Excel 2019
6. How to change the colors of tabs in Excel 2019
7. How to convert a column into a row in Excel 2019
8. How to copy a worksheet in Excel 2019
9. How to create a drop down menu in Excel 2019
10. How to create a pie chart in Excel 2019

Make: Microsoft

Model / Product: Excel

Version: 2019

Objective / Info: Learn how to auto fit a column width in the 2019 version of Excel.

Open Excel by double left clicking the icon on the desktop or start menu, then open the document that you want to work on.

Row 1 has been populated with a long sentence. Notice that the sentence overlaps columns B through F. Once we use the auto fit column width feature, the column will automatically adjust to display all of the contents in a single column.

Select column A by left clicking on it.

While column A is selected, move your mouse to the right hand side of the screen and click on "Format".

Select the "AutoFit Column Width" option from the drop down menu.

The column should now have adjusted itself to fit perfectly around any content in the column.

This task should be complete. Review the steps if you had any issues and try again. Submit questions or request for more guides in the questions section below.