Blocking deletions

D

Droid

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!
 
D

Debra Dalgleish

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Disallow movement of embedded PDF 2
Word VBA for deleting Selected Row 0
How to keep formula and be able to input value in cell? 0
Stacked 3D Bar graph 1
Excel Cannot delete empty cells/rows 4
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Excel 2003 Forms (Not User Forms) 1
Copying in sheet with protection with the use of a macro 5

Top