I cannot tell you how many times I have been asked what this means in an Excel worksheet.
It is, of course, the result of values that are longer than the column in Excel can accommodate.
Perhaps you are aware that you can double-click the right border of the column’s header cell to automatically adjust the width of your column. Excel will increase the column width to accommodate the largest entry in your column.
What you may not be aware of, is that you can adjust the width of multiple columns at once.
Follow the steps below to find out how:
- Select the columns by dragging across the column headers.
- Hover your cursor over the right-border of any of the selected columns until the double-headed arrow appears.
- Double-click a column header border.
Do you know of any quick little tricks such as this one? If you do, please let me know so we can share your knowledge with everyone.