The traditional way to approach this challenge is to follow these steps: The workbook has only a single worksheet, and she needs to protect columns E and J so they cannot be changed, unless the user knows a particular password.
Subscribe to get more articles like this oneĭid you find this article helpful? If you would like to receive new articles, join our email list.Mary Lou wonders if there is a way she can password protect certain columns in a shared workbook.
When you scroll down in the table, the column headings should be locked at the top of the table automatically. Ideally, your table should always have headers. Table headers display default names if you do not select the My table has headers check box.