My sheet is unprotected, but I can't format cells.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I can't format my cells. It is number cells which I want to round out. The
sheet is unprotected.
 
Paul,

Is it shared? Look at Tools - Share workbook. "Allow changes by more than
one user...." should not be checked.
 
I could change format on an unprotected worksheet in a shared workbook (xl2002).

But I don't have a guess.

To the Original Poster:

What did you try (rightclicking Format|cells), Format|Cells), hitting the
increase/decimal icon?

And what happened when you did what you did??
 
You must log in or register to reply here.

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

Copy data from unlocked cells 3
Protection on Worksheets 5
Code to format cells on several worksheets 2
Excel - unprotect certain cells in protected sheet/workbook 3
Unprotecting worksheets 2
Protect Cells 10
Can't move between cells. (Not the scroll lock) 1
unprotect worksheet when...... 1

Back
Top