In Excel, I usually solve
##### errors by double-clicking offending column headers. However, this can get a bit tedious when there are multiple error columns. Is there a quicker way to solve this?
You can autosize multiple columns at the same time by double clicking, just like you do with a single column.
Step 1. Select multiple columns:
Either select all columns by clicking in the arrow in the upper-left corner:
Or click and drag to select a smaller range of columns:
Step 2. Autosize selected columns:
Now double click on the right boundary of any of the selected columns, when your cursor changes to the column-resizing double arrow.
Yes, on the ribbon go to Home - Cells and click Format
Under there, you can choose Autofit either Row Height or Column Width.
For the keyboard warriors, here's a technique that doesn't require the mouse:
- Select all - Control+A or Control+Shift+8
- AutoFit columns - Hold Alt, then press in sequence O, C, A. You can let go of Alt after you press O.
This feature, called Office Access Keys is a holdover from the pre-ribbon days. If you had memorized the old menus, you can continue to access them this way.
In this case, the navigation was:
In addition to narrow columns, the hashes can also be displayed when a cell containing a large text is formatted as Text. In Excel 2003 (and before?), this happens when the cell contains 256 to 1024 characters.
Changing the category from Text to General helps.