Get rid of all ##### errors at once in excel [duplicate]

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:

1. Select all - Control+A or Control+Shift+8
2. 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:

• Format
• Column
• AutoFit

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.