If your workbook contains numbers, dates or other information and you see that the cell contains symbols that is similar to ###### then this means the width of the cell is less and is not able to hold the data. To avoid the symbols, just increase the column width. There are many ways to adjust the column width. Take a look at them:
1. Manually adjusting the column width – To manually adjust the column width, place the mouse cursor at the intersection between the column headers and then drag to suit. For example, if you need to increase the width of column B, place the mouse cursor between column B and C. When you see the double headed arrow, keep the left mouse button in the pressed state and drag towards right or left.
2. Adjust to a specific setting – To adjust to a specific setting, right-click on the column header and click Column Width … to open the Column Width dialog box. Input a value for the column width and then click OK.
3. Automatically adjust the column width – There are two ways by which you can adjust the column width automatically.
a. Adjust the width based on the cell value that has the largest width value – If you have tens to thousands of rows of data then in order to adjust the column width, place the mouse cursor at the intersection between the column headers and then double click. This will automatically adjust the column width.
b. Adjust the width based on a particular cell width – Click on a cell and then from the Home tab, in the Cells section click Format and finally click Autofit Column Width.
Tuesday, February 23, 2010
Subscribe to:
Post Comments (Atom)
