Protecting specific cells in a worksheet.

G

Guest

How can I protect certain cells in a worksheet which contain text, and then
allow users to use specific cells without having to create a shared worksheet
and password?
 
G

Guest

If you rightclick on all the cells, go to format cells, protection and unlock
them, then selectively lock the cells you want to protect, and finally
protect the sheet under the tools bar, that should do it.

Beverly
 
G

GerryK

Highlight cells for people to use by Format... Cells...
Protection... uncheck the cell(s) to let people work in
them.
Protect the sheet next with Tools... Protection.
 

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

Using countif on non-consecutive cells 5
Protecting Cells In A Worksheet 1
Using Group and Outline with Protected Cells 1
Worksheet Protection 3
Protecting Excel Formulas 2
Tab Key 1
Locking cells but keeping Grouping Function available 1
How to SUM in a protected spreadsheet 3

Top