Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel courses - Locking a column

microsoft excel courses - Locking a column

ResolvedVersion Standard

Thu 6 Sep 2007, 10:19 Delegate Laura said...

Laura has attended:
Access Introduction course
Excel Intermediate course

Locking a column

How do I hide and lock one or more columns without locking the whole sheet. I know with hide that the person can then simply unhide so I need a way to lock the columns and make them untouchable?

Fri 14 Sep 2007, 10:02 Trainer Richard said...

RE: Locking a column

Hi Laura

Once you have hidden the column, simpy put a password on the sheet

TOOLS > PROTECTION > PROTECT SHEET
add a password
verify password

When you do this, the other user will not be able to make a modification to the sheet, unless they have your password.

Regards

Richard

Training courses

98.6 % recommend us

More live stats...

Training information:

Excel tip:

Saving your Excel Spreadsheet as a CSV File

In situations where you need to save your Excel spreadsheet as a CSV file, follow these simple steps.

Click the File tab and click Save As.
Enter a name in the File name field.
Click the drop-down arrow next to the Save as type field to select the file type. Scroll down the list and select CSV (comma delimited) (*.CSV)
Click Save

The data will now be saved to a separate CSV file which can be used in different applications.

View all Excel hints and tips