If you do not want to delete the whole row, delete information from specific cells instead. WARNING: When you delete a row, everything in the row is deleted. Select a cell to the right of where you want to add a new column.Ī new column is added left of the selected cell. Select a cell below where you want to add a new row.Ī new row is added above the selected cell. The process is similar for both rows and columns. To make this task easier, you can add new rows and columns or delete existing rows and columns. You will often need to delete old information or add new information. When working with worksheets, you will often need to make changes to the original worksheets. ).įrom the Format menu, select Column » AutoFit Selection. To select a column to be adjusted, click the Column ID (A, B, C. Using AutoFit to Adjust Column Width: Menu Option The column width adjusts so the largest (widest) item is displayed in full. When the pointer turns into to a double-arrow, double click. Using AutoFit to Adjust Column Width: Mouse Option ).įrom the Format menu, select Row » AutoFit. To select a row to be adjusted, click the Row ID (1, 2, 3. Using AutoFit to Adjust Row Height: Menu Option The row height adjusts so the largest (tallest) item is displayed in full. When the pointer turns into a double-arrow, double click. Using AutoFit to Adjust Row Height: Mouse Option To adjust the column width or the row height, Excel can determine the best 'fit' based on the information in the column or row. When the column reaches the desired width, release the mouse button.HINT: For a narrower column, drag left for a wider column, drag right.Ī box appears next to the pointer, indicating the current column width as you drag it. ), point to the border right of the column to be adjusted. Using this option, you can only adjust the width of one column at a time.Īlong the column ID (A, B, C. In the Column width text box, type the desired width. Macintosh: To adjust multiple non-contiguous columns, press + select cells from each column to be adjusted.įrom the Format menu, select Column » Width. Windows: To adjust multiple non-contiguous columns, press + select cells from each column to be adjusted. To adjust a single column, select any cell from the column to be adjusted. When the row reaches the desired height, release the mouse button. HINT: For a shorter row, drag up for a taller row, drag down.Ī box appears next to the pointer, indicating the current row height as you drag it. When the pointer turns into a double-arrow, click and drag. ), point to the border below the row to be adjusted. Using this option, you can only adjust the height of one row at a time.Īlong the row ID (1, 2, 3. In the Row height text box, type the desired height. Macintosh: To adjust multiple non-contiguous rows, press + select cells from each row to be adjusted.įrom the Format menu, select Row » Height. Windows: To adjust multiple non-contiguous rows, press + select cells from each row to be adjusted. To adjust a single row, select any cell from the row to be adjusted. If you need to have two settings, you will have to move some of your information. Since columns and rows extend through the worksheet, the setting applies to the entire column or row. Adjusting the column width or row height is easy to do and can be done using the menu or the mouse option. In addition, Excel may widen the column or increase the row height to fit the cell content. Depending on what you are doing, this may be perfect, too big, or too small. When you start working on a worksheet, all columns are eight characters wide and row heights are set to fit the content of the cell with a maximum of 12 points. This article is based on legacy software.Įxcel allows you to adjust your worksheets to achieve the desired look. (Archives) Excel 2003/2004: Working with Rows and Columns

Expand cells to fit text excel