restrict access to a column of a spreadsheet

  • Thread starter Thread starter James
  • Start date Start date
J

James

Hello,

Is it possible to restrict access to only one column of a spreadsheet?
 
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
 
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

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
Hide columns to all but one user? 7

Back
Top