Excel offers two well-known ways to adjust your columns' widths. First, you could click and drag or double-click the boundary ...

Filters are another way to achieve the same aim in Excel. Here is how to use filters to delete blank rows: Click the Filter dropdown arrow in a column of your dataset where some rows are blank.