Question

Ever see a spreadsheet that has a lot of ######## so you can't see the numbers in a specific cell? This means your number is longer than the visible width of the cell.  How do you widen the cell so you can see all of the numbers by pointing and clicking? How do you do this for a whole set of columns that are too narrow?

Answer 1

Answer: Excel spreadsheets show a progression of number or pound signs like ##### in a cell when the section isn't sufficiently large to show the data. It likewise occurs on the off chance that you have a cell organized to show something else than what you need the spreadsheet to show. All adaptations of Excel do this, and most equations in Excel are the equivalent paying little mind to the form utilized.

Excessively Small of a Cell

Excel permits clients to oversee alternatives to adjust its format to suit your necessities. If at least one spreadsheet cells are excessively thin, you can resize them. On the off chance that you resize a cell that contains numbers, it might show ##### on the off chance that you make it excessively limited. This happens just on the off chance that it sits to one side of another cell that contains content. This can likewise happen if you duplicate a number into a cell too tight to even think about displaying the number.

Numbers Gone Missing

Even though number signs may show up in a cell, Excel still realizes the cell's genuine worth and showcases it in the spreadsheet's equation bar. If numerous cells in the spreadsheet contain number signs, click them separately and note their qualities in that bar. Hold the cursor over a cell to show a spring up device tip that shows the cell's genuine numerical worth.

Broaden the Cells

Cause the issue to disappear by tapping the section's correct edge in the header zone, holding down the left mouse button, and hauling your cursor to one side until the cell's number shows up. You could likewise choose the cells you'd prefer to resize, click "Home" and then snap the strip's "Configuration" tab. Snap the "AutoFit Column Width" menu alternative and Excel resizes the cells so their substance fits inside them and the number signs vanish.

At the point when the Problem Occurs

On the off chance that you type customary content into cells, you won't have this issue because Excel doesn't supplant the content with number signs. You normally won't see number signs when you first sort a huge number into a cell that is too thin because Excel makes the cell more extensive to fit the worth. Number signs show up when you glue an enormous number from another cell or make a current cell's width littler.

Rows and Columns: To rapidly alter the line tallness or segment width, utilize a double-tap easy route.

To autofit the column tallness for the tallest section in each line

• Select at least one rows
• In the Row catches at the left half of the sheet, highlight the line at the base of one of the chose rows
• Double-tap to alter the stature of all the chose rows.

To autofit the segment width for the amplest passage in every section

• Select at least one columns
• In the segment catches at the head of the sheet, highlight the line at the correct side of one of the chose columns
• Double-tap to change the width of all the chose columns.

-------------------------------------------------------------------------------------------------------------------------

"If you liked the answer please give an Up-vote, this will be quite encouraging for me, thank you!"