1 / 17

Excel 2010 Formatting Columns and Rows

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.

lharrison
Download Presentation

Excel 2010 Formatting Columns and Rows

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Excel 2010Formatting Columns and Rows In this lesson you will learn how to insert, delete, and resize Columns and Rows. Excel 2010

  2. To Delete Rows STEP 1: Select the rows you want to delete. Excel 2010

  3. To Delete Rows STEP 2: Click the Delete command on the Home tab. Excel 2010

  4. To Delete Rows STEP 3: The rows are deleted from your worksheet. Excel 2010

  5. To Delete Columns STEP 1: Select the column(s) you want to delete. Excel 2010

  6. To Delete Columns STEP 2: Click the Delete command on the Home tab. Excel 2010

  7. To Delete Columns STEP 3: The columns are deleted from your worksheet. Excel 2010

  8. To Insert Rows STEP 1: Select the rowbelow where you want the new row to appear. Excel 2010

  9. To Insert Rows STEP 2: Click the Insert command on the Home tab. Excel 2010

  10. To Insert Rows STEP 3: The new row appears in your worksheet. Excel 2010

  11. 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

  12. To Insert Columns STEP 2: Click the Insert command on the Home tab. Excel 2010

  13. To Insert Columns STEP 3: The new column appears in your worksheet. Excel 2010

  14. 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

  15. 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

  16. 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

  17. 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

More Related