Using Column Width and Row Height

When Excel creates a blank worksheet, all rows are the same default height, all columns the same width. You can change the width of columns, or the height of rows, to improve the appearance of a worksheet or to eliminate wasted space so that you can get more information on a single page. You can also hide rows or columns by reducing their height or width to zero. The data they contain will still be still there, but it will be hidden. 

To change the width of a cell or column, choose Column from the Format menu, then choose Width from the submenu. You can enter the new width of 

You can also change the column width by using the mouse pointer. Place the cursor on the separator bar between column headings, on the right of the column whose width you want to change. The cursor changes to a double-headed arrow  

Click the mouse button and drag to the right or left to change column width. The column width is displayed in an InfoBox as you drag the separator bar. 

Excel Tip. To adjust several columns at a time to the same width, select the columns, then perform the column width adjustment with the mouse pointer on any of the selected columns. When you release the mouse button, all the columns will have the adjusted width. You can also get a best fit simply by double-clicking on the row or column separator. To adjust several rows or columns at once, select the columns, then double-click on any row or column separator. 

---