This button used to be on column level only to resize highlighted columns.

It’s added on worksheet level mini toolbar. (left click on edge of worksheet). It will resize column width based on both column label row contents and data area contents.

Note: Hidden columns will be ignored.