[accesscomp] Dan's tip
- From: "Bob Acosta" <boacosta@xxxxxxxxxxx>
- To: "tektalk discussion" <tektalkdiscussion@xxxxxxxxxxxxxxxxxxx>
- Date: Wed, 29 Aug 2012 19:46:54 -0700
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.
Other related posts:
