Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / April 2007

Tip: Looking for answers? Try searching our database.

how i can protect few rows or few coloumn?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
vlook fomula - 17 Apr 2007 12:04 GMT
my question is " how i can protect a spacific area of a worksheet? either few
cells, rows or few coloumns?
RFJ - 17 Apr 2007 12:16 GMT
Highlight the cells you want to protect, right click the mouse button and
choose Format/Protection. Your options are there.

From the main menu*, you then have the option of protecting the whole
workbook or worksheet. That enables the protection you put on in the format
command

In OL2007 it is Review/ and your options are on the ribbon bar.

> my question is " how i can protect a spacific area of a worksheet? either
> few
> cells, rows or few coloumns?
vlook fomula - 17 Apr 2007 12:34 GMT
Dear Sir,
i applied your given instructions (choose Format/Protection. Your options
are there.)
i could not get any sucess and there. secondly i can protect hole worksheet
now but i cant get sucess to protect specific area of a sheet. kidly do the
need full?

> Highlight the cells you want to protect, right click the mouse button and
> choose Format/Protection. Your options are there.
[quoted text clipped - 8 lines]
> > few
> > cells, rows or few coloumns?
RFJ - 17 Apr 2007 13:30 GMT
It is a 2-stage process, it is just a question of getting the hang of it.

Use the format/protection command and make sure you have the settings
correct for all the worksheet - that in itself hasn't enabled anything -
just set the criteria for the cells.

Then you need to enable it. On XP it is Tools/Protection/Protect sheet,
etc. - there you have all the options in terms of what you will allow/not
allow users to do.

You also have the option of hiding columns and rows before you apply the
protection and that then locks them out of view once protection is enabled.

It /will/ work unless I've missed something. Have you thought about trying
it out on a simple worksheet to see how it works in practice. (It isn't the
easiest feature to see working until you get the hang of it.)

Rob

> Dear Sir,
> i applied your given instructions (choose Format/Protection. Your options
[quoted text clipped - 19 lines]
>> > few
>> > cells, rows or few coloumns?
DS-NTE - 17 Apr 2007 13:37 GMT
By default all cells are locked whwn you protect a sheet, you have to do it
this way:
Select all the cells you dont want to protect then choose Format/Protection,
uncheck "Locked", then protect your sheet.

hth

> Dear Sir,
> i applied your given instructions (choose Format/Protection. Your options
[quoted text clipped - 19 lines]
>> > few
>> > cells, rows or few coloumns?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.