Software & Apps MS Office Change Column Widths and Row Heights in Excel and Google Spreadsheets How do I widen a column in excel? by Ted French Writer Former Lifewire writer Ted French is a Microsoft Certified Professional who teaches and writes about spreadsheets and spreadsheet programs. our editorial process Ted French Updated on September 11, 2020 MS Office Excel Word Powerpoint Outlook Tweet Share Email There are a couple of ways of widening columns in Excel and Google Sheets. Use the mouse to change column widths or row heights individually or use the tools in the ribbon (in Excel only) to change column widths or row heights using the ribbon options. Learn both methods to decide which approach best suits your needs. Negative Space / Pexels Instructions in this article apply to Excel for Microsoft 365, Excel 2019, Excel 2016, Excel 2013, Excel 2010, and Google Sheets. Change Column Widths and Row Heights With the Mouse Change Individual Column Widths With the Mouse The steps below cover how to change individual columns widths using the mouse. To widen column A for example: Place the mouse pointer on the boundary line between columns A and B in the column headerThe pointer will change to a double-headed black arrow as shown in the image aboveClick and hold down the left mouse button and drag the double-headed arrow to the right to widen column A or to the left to make the column narrowerRelease the mouse button when the desired width is reached AutoFit Column Widths Using the Mouse Another way to narrow or widen columns with the mouse is to let Excel or Google Spreadsheets auto fit the width of the column to the longest item of data contained in the column. For long data, the column will widen, but if the column contains only short items of data, the column will narrow to fit these items. Example: Change the Width of Column B Using AutoFit Place the mouse pointer on the boundary line between columns B and C in the column header. The pointer will change to a double-headed arrow.Double-click the line. The column will automatically adjust its width to match the longest entry in that column Change All Column Widths in a Worksheet Using the Mouse To adjust all of the column widths Select all of the columns in the current worksheet.Place the mouse pointer on the boundary line between columns A and B in the column headerThe pointer will change to a double-headed arrow.Select the double-headed arrow and drag to the right to widen all columns in the worksheet or to the left to make all columns narrower. Change Row Heights With the Mouse The options and steps to changing row heights in Excel and Google Sheets with the mouse are the same as for changing column widths, except that you place the mouse pointer on the boundary line between two rows in the row header instead of the column header. It is not possible to change the width or height of a single cell. The width must be changed for the entire column or the height for an entire row. Change Column Widths Using Ribbon Options in Excel Change Column Widths Using the Ribbon Options Microsoft Excel has a tool on the ribbon that will change the width of a column to any desired size. Select any cell in the column you want to change. To widen multiple columns highlight a cell in each column. To change the column width for the enter worksheet, choose the Select All button.Select the Home tab of the ribbon Select the Format icon to open the drop-down menu of optionsTo AutoFit the column(s), choose that option in the Cell Size section of the menuTo enter a specific size in character widths, select the Column Width option in the menu to bring up the Column Width dialog boxIn the dialog box enter the desired width in character (default width: 8.11 characters)Select OK to change the column widths and close the dialog box The options and steps to changing row heights in Excel using options in the ribbon are the same as for changing column widths. Resize Columns and Rows in the Google Sheets Menu Google Sheets features a right-click menu function to change the column width. Select the column(s) you want to resize.Right-click anywhere on the selection.Choose Resize Column. A Resize Column window will open.Enter the desired column width in pixels (the default width is 100 pixels).Alternatively, select Fit to Data. Select OK.