Main Page 
PC Review
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Charting
Blocking deletions
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Charting
Blocking deletions
 |
Blocking deletions |
|
|
Thread Tools | Rate Thread |
01-07-2003, 06:58 PM
|
#1 |
|
Guest
Posts: n/a
|
Blocking deletions
If I press the space bar when over a protected cell it
still disappears, how do I fix this? ALSO.. how can I copy and paste a worksheet complete with cell sizes, formulae and protections? PLEASE HELP! |
|
|
01-07-2003, 10:13 PM
|
#2 |
|
Guest
Posts: n/a
|
Re: Blocking deletions
If the worksheet is protected (Tools>Protection>Protect Sheet), you
won't be able to type anything in a locked cell. To copy a complete worksheet: 1. Right-click on the sheet tab 2. Choose Move or Copy 3. Select a location for the copy 4. Check the 'Create a copy' box 5. Click OK Droid wrote: > If I press the space bar when over a protected cell it > still disappears, how do I fix this? > > ALSO.. how can I copy and paste a worksheet complete with > cell sizes, formulae and protections? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
|
|
|
|
| Thread Tools | |
| Rate This Thread | |
|
|
