excel 提取符号前数字_如何同时消除Excel中的所有数字符号（＃）错误？

excel 提取符号前数字

When you are busy working in Microsoft Excel, the last thing you need is to have to continuously fix or remove errors. With that in mind, today’s SuperUser Q&A post helps a reader quickly and easily remove pesky number sign errors from his Microsoft Excel sheets.

当您在Microsoft Excel中忙于工作时，您需要做的最后一件事就是必须不断修复或删除错误。 考虑到这一点，今天的SuperUser Q＆A帖子可帮助读者快速轻松地从Microsoft Excel工作表中消除讨厌的数字符号错误。

Today’s Question & Answer session comes to us courtesy of SuperUser—a subdivision of Stack Exchange, a community-driven grouping of Q&A web sites.

今天的“问答”环节由SuperUser提供，它是Stack Exchange的一个分支，该社区是由社区驱动的Q＆A网站分组。

问题 (The Question)

SuperUser reader M.Hesse wants to know how to get rid of all the number sign (#) errors in Microsoft Excel at the same time:

超级用户阅读器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时，我通常通过双击有问题的列标题来解决#####错误。 但是，当有多个列同时显示错误时，这可能会变得有些乏味。 有更快的方法解决此问题吗？

How do you get rid of all the number sign errors in Microsoft Excel at the same time?

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

答案 (The Answer)

SuperUser contributors Justin, Raystafarian, and boflynn have the answer for us. First up, Justin:

超级用户贡献者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

步骤1.选择多列

Either select all columns by clicking on the arrow in the upper-left corner:

通过单击左上角的箭头来选择所有列：

Or click and drag to select a smaller range of columns:

或单击并拖动以选择较小范围的列：

Step 2. Auto-Size Selected Columns

步骤2.自动调整所选列的大小

Now double-click on the right boundary of any of the selected columns when your cursor changes to the column-resizing double arrow:

现在，当光标变为列大小调整双箭头时，双击任何选定列的右边界：

Followed by the answer from Raystafarian:

随后是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.

是的，在功能区上，转到“ 主页” ，“ 单元格” ，然后单击“ 格式” 。 到达那里后，您可以选择自动调整行高和/或列宽 。

With our final answer from boflynn:

通过boflynn的最终答复：

For keyboard ninjas, here is a technique that does not require a mouse:

对于键盘忍者，这是不需要鼠标的技术：

1. Select All – Control + A or Control + Shift + 8.

   全选– Control + A或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.

   自动调整列–按住Alt ，然后依次按O，C，A 。 按下O后可以放开Alt 。

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:

此功能称为Office Access Keys ，它是功能区前的一种保留。 如果您已记住旧菜单，则可以继续以这种方式访问​​它们。 在这种情况下，导航为：

1. Format (O)

   格式( O )

2. Column (C)

   列( C )

3. AutoFit (A)

   自动调整( A )

---

---

Have something to add to the explanation? Sound off in the comments. Want to read more answers from other tech-savvy Stack Exchange users? Check out the full discussion thread here.

有什么补充说明吗？ 在评论中听起来不错。 是否想从其他精通Stack Exchange的用户那里获得更多答案？ 在此处查看完整的讨论线程 。

翻译自: https://www.howtogeek.com/220140/how-do-you-get-rid-of-all-the-number-sign-errors-in-excel-at-the-same-time/

excel 提取符号前数字