Assuming that you are on cell A1 & have long text in it, following code will make the column Autofit and then increase the width by 5 characters To AutoFit the Column Width Select the number of columns according to your choice, then press 'AltH' then press 'O', and then 'I' To AutoFit the Row Height Select the number of rows according to your choice, then press 'AltH', then press 'O', and then 'A'Methods Methods adjust Indent (amount) Adjusts the indentation of the range formatting The indent value ranges from 0 to 250 and is measured in characters autofit Columns () Changes the width of the columns of the current range to achieve the best fit, based on the current data in the columns
:max_bytes(150000):strip_icc()/002-change-column-widths-and-row-heights-in-excel-and-google-spreadsheets-d3e0e5cc615c4941bd4f424e7ca096e0.jpg "Change Spreadsheet Column Widths Using The Mouse")
Change Spreadsheet Column Widths Using The Mouse
