protecting cells
Contact Us About Resources Consent preferences Sign in

TrustPilot

starstarstarstarstar Excellent

Request Callback We will call you back  0207 987 3777 Call for assistance Your Basket Basket is empty
Callback Sign in Basket
Menu

Call us on 0207 987 3777 or Search our website

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Protecting Cells

Protecting Cells

resolvedResolved · Low Priority · Version 2010

Jay has attended:
Excel Intermediate course
Excel Advanced course

Protecting Cells

If I wanted to just protect cells that have a formula in what's the best way to do this covering the whole sheet?

Also how do I protect the worksheet where a notification comes up if its trying to be edited in any part of the sheet?

RE: Protecting Cells

Hi

To protect only formulas start by unlocking all the non-formula cells.
1. Select all cells, Format Cells, Protection
uncheck the Locked cells option

2. Now select the formulas by
F5
Special
Formulas
Format Cells, Protection
Check the Locked cells option

3. Finally select Review, Protect Sheet
Enter a password if you wish

The Worksheet is now protected. If you try to edit any of the formula cells there will be a prompt.

See the Excel Intermediate reference guide for more info on protecting cells.

Cheers
Doug
Best STL

RE: Protecting Cells

Hi,

i can still type over the formulas though? i want it so just know one can type over them?

regards

Jay

RE: Protecting Cells

Hi,

i can still type over the formulas though? i want it so just know one can type over them?

regards

Jay

RE: Protecting Cells

also say i want to lock everything that is not blank and be able to write in the blanks and when i write in the blanks then they lock so you cant edit?
best way to do this regards Jay

RE: Protecting Cells

If you want to type into the blank cells then unlock them first before protecting the sheet.
Start by unlocking all cells including blank ones.
Then select the formulas and lock them with Format, Cells, Protection.

Cheers
Doug

Wed 16 Jul 2014: Automatically marked as resolved.


 

Excel articles

Please browse our web site to find out more about
excel computer training london and other training courses.

Excel tip:

Convert a column into row quickly in Excel 2010

Occasionally you might enter data into Excel vertically and then when you finish realize that actually it would look more clearer if it was represented in a horizontal format. If you follow these simple steps below, you can quickly change the data from going vertically to horizontally and vice versa.

First, select the column you want to convert into a row or a row into a column. Then right click and select Copy. Go to the sheet where you want to past this row as a column and select “Paste Special”. Remember to check the check-box “Transpose” and select “OK”.

View all Excel hints and tips


Request Callback

We will call you back

0207 987 3777

Call for assistance

Security verified Microsoft Partner

Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE

2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom

Terms & Conditions Privacy & Cookie Policy Consent preferences

Server loaded in 0.08 secs.