当您忙于使用microsoftexcel时，最不需要的就是不断地修复或删除错误。有鉴于此，今天的超级用户问答帖子可以帮助读者快速轻松地从他的microsoftexcel表格中删除讨厌的数字符号错误。

今天的问答环节是由SuperUser提供的，SuperUser是Stack Exchange的一个分支，是一个由社区驱动的问答网站分组。

问题

超级用户读者M.Hesse想知道如何同时消除Microsoft Excel中的所有数字符号（#）错误：

When using Microsoft Excel, I usually solve ##### errors by double-clicking the offending column headers. This can become a bit tedious, however, when there are multiple columns displaying the errors at the same time. Is there a quicker way to resolve this?

如何同时消除Microsoft Excel中的所有数字符号错误？

答案

超级用户贡献者Justin、Raystafarian和boflynn为我们提供了答案。首先，贾斯汀：

You can auto-size 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 on the arrow in the upper-left corner:

Or click and drag to select a **aller range of columns:

Step 2. Auto-Size 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:

接下来是Raystafarian的回答：

Yes, on the ribbon go to Home, Cells, and click Format. Once there, you can choose to AutoFit either the Row Height and/or Column Width.

博弗林给出了我们的最终答案：

For keyboard ninjas, here is a technique that does not require a 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 have memorized the old menus, you can continue to access them this way. In this case, the navigation was:

1. Format (O)
2. Column (C)
3. AutoFit (A)

有什么要补充的解释吗？在评论中发出声音。想从其他精通技术的Stack Exchange用户那里了解更多答案吗？在这里查看完整的讨论主题。