![excel make all columns fit text excel make all columns fit text](https://online-excel-training.auditexcel.co.za/wp-content/uploads/2017/07/Writing-Paragraphs-5-768x311.png)
Sometimes, Autofit refuses to work when there are merged cells in your Excel. Here I am listing some possible reasons why autofit may not be working on your Excel: When there are merged cells There could be many reasons for it not working, and in many cases, it sometimes works and sometimes doesn’t. While Autofit works well in most cases, sometimes, you may find that this feature doesn’t work. For example, if you’re using the shortcut ALT + H + O + I, press the ALT key, then the H key, and so on (in succession).
#Excel make all columns fit text how to#
Here is how to use these keyboard shortcuts: To Autofill column width: ALT + H + O + I If you’re not a fan of using the mouse and would prefer a keyboard shortcut instead, this method is for you.īelow are the keyboard shortcuts that will autofit the cells: To do that you first need to select the rows that you need to autofit and then select the ‘Autofit Row Height’ option.ĪutoFit Rows and Columns Using a Keyboard Shortcut You can also use the same steps to also autofit row height. The above steps would instantly expand the column to adjust the text in the cells. Click on the ‘Autofit Column Width’ option.This will show additional options in the drop-down In the Cells group, click on the ‘Format’ option.
![excel make all columns fit text excel make all columns fit text](https://cdn.extendoffice.com/images/stories/doc-excel/doc-put-multiple-lines-to-a-cell/doc-put-multiple-lines-to-a-cell-1.png)
Suppose you have a dataset as shown below where you want to autofit Column A. You just have to place the cursor at the bottom edge of the selected row and double-click AutoFit Rows and Columns Using Excel RibbonĪnother quick way to autofit cells in Excel is by using the option in the ribbon. While I have shown you the example automatically fitting text to columns (which is more commonly needed), the same can also be done with rows. Note that for this to work, you need to select the entire columns and not the cells in the worksheet.
![excel make all columns fit text excel make all columns fit text](https://support.content.office.net/en-us/media/cfccd85a-4fd7-4bbf-9506-38156895ff21.png)
Suppose you have a dataset as shown below where the text spills to the other column as the column width is less. AutoFit Rows and Columns Using Mouse Double-Click In most cases, I use the mouse double-click method as I find it the most convenient. There are a couple of ways to Autofit in Excel:Īll these methods work fine and you can choose whichever works best for you. How to AutoFit in Excel (Adjust Rows and Columns to Fit Text) You can use the ‘AutoFit Row Height’ feature in that case. In those cases, you won’t need to do any row height adjustment.īut sometimes, you may get a dataset from someone or as a download, where row height has already been fixed and needs adjustment. In most cases, you would notice that Excel automatically adjusts the row height when you enter more than one line in the same cell.