How to adjust the width of many columns or rows simultaneously in Excel

Excel tip: Adjust the width of a range of columns or rows

Before:

 

Select the range of columns (or rows) you want to arrange:

 



Place the mouse pointer on the grille in between two columns (or rows)

And double click to adjust the column width with the content of the column

Or click and drag to adjust the size of columns you want



 

Created by DoMyExcel.com

Customized Excel Solutions starting at $29!