corsasport.co.uk
  Not logged in [Login - Register]  
You Are Not Registered Or Not Logged In  

Corsa Sport » Message Board » Off Day » Geek Day » Excel Question (re: locking spreadsheet but keeping some cells unlocked)


New Topic
New Poll 		  Subscribe | Add to Favourites

You are not logged in and may not post or reply to messages. Please log in or create a new account or mail us about fixing an existing one - register@corsasport.co.uk

There are also many more features available when you are logged in such as private messages, buddy list, location services, post search and more.


Author Excel Question (re: locking spreadsheet but keeping some cells unlocked)
Shane
Member
Registered: 10th Jan 04
User status: Offline
9th Nov 07 at 10:53   View User's Profile U2U Member Reply With Quote
i need to lock a spreadsheet but keep some cells unlocked so some data can be edited but others cant
Edd
Member
Registered: 8th Nov 04
Location: Glasgow
User status: Offline
9th Nov 07 at 10:54   View User's Profile U2U Member Reply With Quote
tools protection protect sheet pick what you want to lock
Shane
Member
Registered: 10th Jan 04
User status: Offline
9th Nov 07 at 11:09   View User's Profile U2U Member Reply With Quote
still cant find how to lock some cells and not others
AdZ9
Member
Registered: 14th Apr 06
User status: Offline
9th Nov 07 at 12:10   View User's Profile U2U Member Reply With Quote
padlocks


(i made a funny)
pow
Premium Member

Avatar

Registered: 11th Sep 06
Location: Hazlemere, Buckinghamshire
User status: Offline
9th Nov 07 at 23:56   View Garage View User's Profile U2U Member Reply With Quote
Highlight cells you want to be able to use, right click, underprotection, untick protect cells.

Now protect sheet, and VOLIA!

 
New Topic
New Poll

  Related Threads Author Forum Replies Views Last Post
Excel help Munchie General Chat 7 183
24th Oct 03 at 15:42
by Jason		  
excel help Darren General Chat 3 905
28th Jan 05 at 15:04
by VegasPhil		  
Computer Question seanreay1986 General Chat 3 587
1st Mar 05 at 22:53
by seanreay1986		  
Excel help Mark Petty Geek Day 7 272
18th Jul 05 at 17:41
by Mark Petty		  
Excel- counting the amount of cells have a certain word? willay Geek Day 1 147
1st May 07 at 20:39
by Dom		  

Corsa Sport » Message Board » Off Day » Geek Day » Excel Question (re: locking spreadsheet but keeping some cells unlocked) 29 database queries in 0.0132432 seconds