restrict access to a column of a spreadsheet

  • Thread starter Thread starter James
  • Start date Start date
Yes.

Select all columns and Format>Cells>Protection. Select the "Locked" option.

Select the one column and Format>Cells>Protection. De-select the "locked"
option.

Tools>Protection>Protect Worksheet.


Gord Dibben MS Excel MVP
 

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

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Can I restrict a text column to a specific number of characters? 4
Restrictions on Addresses 9
excel sorting 1
Adding more options in a drop down list 4
How do I stop cell contents from spilling into the next cell? 4
Can I have a list of reserved words in excel column name? 1
Restrictions in format 1

Back
Top