The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » MS Excel

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

MS Excel

Resolved · High Priority · Version 2007

ReplyWed 21 Apr 2010, 11:46Delegate Fahim said...

MS Excel

Hi I was wondering how can i control data in a cell/column.
For example i have added data in in column d and i dont want anyone to make changes to that column.

How can this be done?

thanks you very much

Regards

Fahim

For upcoming training course dates see: Pricing & availability

ReplyThu 22 Apr 2010, 10:49Trainer Stephen said...

RE: MS Excel

Hi Fahim

Thanks for your question.

This is fairly simple. You can protect your worksheet. This then stops the user from changing data in any locked cell. By default all cells are locked, so you first need to unlock the cells that the user can change and then protect the worksheet.

Unlocking Cells

Select the cells the user can edit
In the number format combo in the number group (Home tab) select "More Number Formats".
In the resulting dialog box select Protection tab and untick locked.

Protecting the sheet

On the review tab click on "Protect Sheet"
Enter a password to unproptect the sheet, click OK, confirm the password and click OK again.

Your data will then be protected

Regards

Stephen

Wed 28 Apr 2010: Automatically marked as resolved.

Excel articles

· How To Use The New Excel Web App
· How Excel Training Can Improve Your Company's Sales Process
· Learn How To Use Index And Match Functions In Excel
· Prepare for your MOS Certification with MS Excel Courses
· How To Use Conditional Formatting In Excel

Please browse our web site to find out more about
excel-xp-training and other Microsoft training courses.

Excel tip:

Shortcut for deleting all comments in a spreadsheet

If you have entered multiple comments into a spreadsheet and wish to delete them all at once, you can achieve this by:

1. Holding down Ctrl, then Shift, then O - this will select all cells containing comments in the worksheet you are looking at.

2. Right-clicking on one of the selected cells, and selecting Delete Comment from the menu that appears.

3. Clicking anywhere else in the spreadsheet to deselect comments - all comments should have disappeared from the spreadsheet.

View all Excel hints and tips

Can I use the Average function in a 3d formula? I get error messages.

» Forum post: Excel

Rate this page:

Currently 2.15/5
1
2
3
4
5

2.2/5 (213 votes cast)

Add to:

Follow @beststl on Twitter

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. info
All prices offered for business users and exclude VAT. E&OE · Terms and Conditions