• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part 3. Using Excel > Task 8 How to Set Column Width and Row Height

Task 8 How to Set Column Width and Row Height

In a new worksheet, all the columns and rows are the same size. However, it's quite common to exceed your column width when entering data. If it's a text entry, the text flows over into the cell to the right, until you enter data in that cell. Then, the wide entry is cut off at the cell border. (It's partially hidden.) If it's a number entry, it won't flow over. Instead it appears in scientific notation (1.23154E+10) or as ######## in the cell. You can quickly adjust the column width or row height in your worksheets. You can drag a row or column to a new size, or you can specify an exact size.

  1. Drag a New Column Width

    To adjust the column width, point at the right border of the heading for the column you want to widen. The mouse pointer becomes a two-headed arrow. Hold down the left mouse button and drag the border in either direction to adjust the width. A ScreenTip lets you know the width measurement. Release the mouse button when the column is the width you want.



  2. Resize Multiple Columns

    To make several columns the same width, select all the columns by dragging over their headings, and then adjust the width for any one of the columns while all the columns are selected. All the selected columns will adjust to the same width.



  3. Open the Column Width Dialog Box

    To enter an exact value for the width of a column, select the column and choose Format, Column, Width. The Column Width dialog box opens.



  4. Specify an Exact Size

    Type a measurement (in numbers of characters of the standard font width) for the column width and click OK.



  5. Drag a New Row Height

    You can adjust the height of a row in the same way you adjust the width of a column. Point to the bottom border of the heading for the row you want to adjust. The mouse pointer becomes a two-headed arrow. Drag the border in either direction to adjust the row height. A ScreenTip lets you know the measurement. Release the mouse button when the row is the height you want.



  6. Open the Row Height Dialog Box

    You can also specify an exact value for the row height. Select the row or rows to which you want to apply a new measurement and choose Format, Row, Height. Type a new value (in points—there are 72 points to an inch) and click OK to apply the change.




PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint