[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: