Download
1 / 17
170 likes | 187 Views
Excel 2010 Formatting Columns and Rows. In this lesson you will learn how to insert , delete , and resize Columns and Rows. To Delete Rows. STEP 1: Select the rows you want to delete. To Delete Rows. STEP 2: Click the Delete command on the Home tab. To Delete Rows.
E N D
Excel 2010Formatting Columns and Rows In this lesson you will learn how to insert, delete, and resize Columns and Rows. Excel 2010
To Delete Rows STEP 1: Select the rows you want to delete. Excel 2010
To Delete Rows STEP 2: Click the Delete command on the Home tab. Excel 2010
To Delete Rows STEP 3: The rows are deleted from your worksheet. Excel 2010
To Delete Columns STEP 1: Select the column(s) you want to delete. Excel 2010
To Delete Columns STEP 2: Click the Delete command on the Home tab. Excel 2010
To Delete Columns STEP 3: The columns are deleted from your worksheet. Excel 2010
To Insert Rows STEP 1: Select the rowbelow where you want the new row to appear. Excel 2010
To Insert Rows STEP 2: Click the Insert command on the Home tab. Excel 2010
To Insert Rows STEP 3: The new row appears in your worksheet. Excel 2010
To Insert Columns STEP 1: Select the column to the right of where you want the new column to appear. Example, if you want to insert a column between A and B, select column B. Excel 2010
To Insert Columns STEP 2: Click the Insert command on the Home tab. Excel 2010
To Insert Columns STEP 3: The new column appears in your worksheet. Excel 2010
To Adjust Column Width STEP 1: Select the columns you want to modify. STEP 2: Click the Format command on the Home tab. The format drop-down menu appears. STEP 3: Select Column Width. Excel 2010
To Adjust Column Width STEP 4: The Column Width dialog box appears. Enter a specific measurement. STEP 5: Click OK. The width of each selected column will be changed in your worksheet. Excel 2010
To Adjust Row Height STEP 1: Select the rows you want to modify. STEP 2: Click the Format command on the Home tab. The format drop-down menu appears. STEP 3:Select Row Height. Excel 2010
To Adjust Row Height STEP 4: The Row Height dialog box appears. Enter a specific measurement STEP 5: Click OK. The selected rows heights will be changed in your spreadsheet. Excel 2010
