When you are busy working in Microsoft Excel, the last point you need is to have to continuously repair or eliminate mistakes. Keeping that in mind, today’s SuperUser Q&A blog post helps a visitor promptly and quickly eliminate pesky number indicator mistakes from his Microsoft Excel sheets.
Today’s Question & Answer session involves us courtesy of SuperUser– a subdivision of Stack Exchange, a community-driven group of Q&An internet site.
The Question
SuperUser reader M.Hesse wants to know how to do away with all the number indicator (#) errors in Microsoft Excel at the same time:
When using Microsoft Excel, I generally fix ##### mistakes by double-clicking the annoying column headers. This can end up being a little bit laborious, nonetheless, when there are numerous columns displaying the errors at the same time. Is there a quicker means to settle this?
Exactly how do you eliminate all the number indication mistakes in Microsoft Excel at the exact same time?
The Answer
SuperUser contributors Justin, Raystafarian, and boflynn have the response for us. First off, Justin:
You can auto-size numerous columns at the exact same time by double-clicking, much like you perform with a solitary column.
Action 1. Select Multiple Columns
Either pick all columns by clicking the arrow in the upper-left edge:
Or click as well as drag to select a smaller variety of columns:
Step 2. Auto-Size Selected Columns
Now double-click on the ideal limit of any of the picked columns when your arrow modifications to the column-resizing double arrow:
Followed by the response from Raystafarian:
Yes, on the bow most likely to Home, Cells, as well as click Format. Once there, you can choose to AutoFit either the Row Height and/or Column Width.
With our final solution from boflynn:
For keyboard ninjas, below is a technique that does not require a computer mouse:
This attribute, called Office Access Keys, is a holdover from the pre-ribbon days. If you have remembered the old menus, you can continue to access them in this manner. In this situation, the navigating was:
Have something to add to the explanation? Sound off in the comments. Wish to find out more responses from other tech-savvy Stack Exchange users? Check out the full discussion string right here.