Resizing Columns In Excel

Excel will do that for you ! Position the mouse at the right-hand edge of the column header. You’ll know  the right spot when the cursor changes to a left-right arrow. Now double-click in that exact spot.  The column is just big enough for its widest text.

You can do multiple columns at once, too. Select a contiguous group of columns by clicking one column header and dragging sideways until they’re all selected. Or select a mix-and-match group by clicking one column header and then Ctrl-clicking the rest. Now double-click the divider at the right-hand edge of any of the selected columns and they’ll all automatically adjust to the perfect width. Of course, if your lines are really long, you may want to use the Text Wrap option instead or as well.