I personally prefer the double-click method as it’s faster and efficient, but in case you’re not double-click person, you can also use the ‘Fit to Data’ optionĪlso, note that all the methods that we have covered in this tutorial also work when you have to resize and autofit rows in Google Sheets.These steps show how to convert your current section or selected text into multiple columns. So these are two simple ways you can use to Auto-fit column width in Google Sheets.