For All Your Training Needs       
                                                               Home ] Up ] Site Map ] Search ]

Home
Classes
Services
Trainer Profile
Client Quotes
Tips & Tricks
Contact Us


Microsoft Excel
Add Rows and Columns to Spreadsheets

Description

You can easily insert or delete rows or columns to spreadsheets by using the keyboard shortcut described below.

Select Rows or Columns

  • Select any row or rows by clicking the row numbers on the left edge of the spreadsheet

    • New rows will be inserted above the selected row or rows

  • Or, select any column or columns by clicking the column letters on the top of the spreadsheet

    • New columns will be inserted to the left of the selected column or columns

Insert Rows or Columns

  • On your keyboard, press the CTRL key at the same time as the Plus Sign (+) key on the numeric keypad

  • If you selected more than one row or column, then multiple rows or columns will be inserted

Delete Rows or Columns

  • On your keyboard, press the CTRL key at the same time as the Minus Sign (-) on the numeric keypad

  • If you selected more than one row or column, then multiple rows or columns will be deleted


                                     Select Rows and Columns


Send mail to Complete Training Management with questions or comments about this web site.
Copyright © 2002 Complete Training Management
Last modified: December 03, 2008