Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 18th 15, 10:28 AM
Junior Member
 
First recorded activity by ExcelBanter: Jun 2015
Posts: 1
Default Protecting Cells

Hi all, I'm trying to do something relatively simple seeming in Excel but Help doesn't seem to be of much help. I need to know how to protect or lock a cell but everytime I try the protect sheet function under the Review tab, it seems to protect the whole thing sheet - this seems to be the case no matter what options are ticked or unticked on the Protect Sheet dialogue box.

  #2   Report Post  
Old June 19th 15, 02:36 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2015
Posts: 1
Default Protecting Cells

On Thursday, June 18, 2015 at 5:49:03 AM UTC-4, Dreamskaype wrote:
Hi all, I'm trying to do something relatively simple seeming in Excel
but Help doesn't seem to be of much help. I need to know how to protect
or lock a cell but everytime I try the protect sheet function under the
Review tab, it seems to protect the whole thing sheet - this seems to be
the case no matter what options are ticked or unticked on the Protect
Sheet dialogue box.




--
Dreamskaype


Lock or unlock specific areas of a protected worksheet


When you protect a worksheet, all cells are locked by default, which means that they cannot be edited. To enable cells to be edited while leaving only some cells locked, you can unlock the cells and then lock only specific cells and ranges before you protect the worksheet. You can also enable specific users to edit specific ranges in a protected worksheet.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
PROTECTING CELLS LOCKING CELLS Excel Discussion (Misc queries) 2 April 20th 10 06:42 PM
Protecting Cells P. Zicari Excel Discussion (Misc queries) 0 October 24th 07 12:22 AM
Protecting cells fred Excel Discussion (Misc queries) 2 April 30th 07 06:26 PM
Protecting Cells Katie Excel Worksheet Functions 0 September 16th 05 03:36 PM
Protecting Cells teresa Excel Programming 2 February 24th 05 05:35 PM


All times are GMT +1. The time now is 06:36 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017