Deleting, Adding Rows and Columns and Locking a Cell in Excel *I. Locking and Unlocking a cell or sheet: Sometimes one might want a cell locked if developing a form. This would be done so the user could not type into it and alter the form's original perpose and composition. Perhaps you have a cell for first and last name. But you want the person to write in their first and last name under the assigned cells, not into the original cell containing the words "first", and "last." You must turn on "protect sheet" for this feature to work. In this case do the following: 1. Move the cursor into the cell to be locked. 2. Press alt plus h. 3. Press the letter l for "lock cell." You are returned back in to the worksheet. 4. Press alt plus the letter h followed by tapping the letter p. 5. Press the letter p. 6. You are asked for a password to unprotect the sheet. Type one and tap enter. 7. You are asked to comfirm the password. Type it again and press enter. 8. In order to unprotect the sheet to unlock the cells or add data do the following: a. Press alt plus h. b. Press the letter o. c. Press the letter p. d. Type in the passwor for that worksheet followed by tapping enter. *Deleting Cells: 1. With the worksheet open, and the cursor in the cell to delete, do the following: 2. Press alt plus the letter h. 3. Press the letter d for "delete." 4. Press the letter d again to delete the current cells or a selected range of cells. *III. Deleteing Rows: 1. With the worksheet open, and the cursor in the row to delete or selected range of rows chosen, do the following: 2. Press alt plus h. 3. Press the letter d. 4. Press the letter r. And the selected range of rows or current row is deleted. *IV. Deleting columns: 1. With the worksheet open, and the cursor in the column to delete or selected range of columns chosen, do the following: 2. Press alt plus h. 3. Press the letter d. 4. Press the letter c and the current column or selected range of columns are deleted. *V. Adding cells: 1. Place the cursor where you wish to add a cell. 2. Press alt plus h. 3. Press the letter i. 4. Press the letter I again to add a cell. *VI. Adding a Row: 1. Place the cursor where you wish to add a column. 2. Press alt pus the letter h. 3. Press the letter i. 4. Press the letter r. Dan Thompson dthompson5@xxxxxxxxx this message has been scanned with microsoft security essentials _______________________________________________ Danstips mailing list Danstips@xxxxxxxxxxxxxxx http://jacobsexton.com/mailman/listinfo/danstips_jacobsexton.com Robert Acosta, President Helping Hands for the Blind Email: boacosta@xxxxxxxxxxx Web Site: www.helpinghands4theblind.org You can assist Helping Hands for the Blind by donating your used computers to us. If you have a blind friend in need of a computer, please mail us at the above address.