How to protect & hide Sheet

  • Thread starter Thread starter Panchi
  • Start date Start date
P

Panchi

Hi..

I have a few questions :

1. I have a sheet which has data in rows. How can I have the row highlighted
in red if a particular cell A3 is blank for example whereas cell A1 has the
required data in it?

2. Is it possible to protect only 1 sheet of a workbook? I have mutliple
sheets in a workbook which has to be updated and mailed but I don't wan't
the recepient to see any data on a particular sheet only. I can hide the
sheet but anyone can open that sheet be unhiding that sheet.

3. I have a shared worksheet where alot of people update the sheet as
required. How can I have a cell formatted so that only 8 digits can be
entered?

Thanks,
Panchi
 
Hi Panchi.......

1- The feature that will help you do what you want here is called
Conditional Formatting. To access it, select the cell of interest and do
Format > Conditional Formatting and follow the Menus.

2- Yes, it is possible to protect a single sheet in a multi-sheet workbook,
but that alone does not prevent a user from viewing it. Excel is not
designed to be a secure environment. You simply cannot secure any
information therein that an Excel Gure cannot access. If you have
confidential information you do not wish to share, you must take other steps
to preserve it's security......for one, DON'T send it to anybody!

3- To limit a cell entry to 8 digits, use Data > Validation > Allow: Text
length > Data: less than or equal to > Maximum: 8 > OK

Hth
Vaya con Dios,
Chuck, CABGx3
 
see below
Panchi said:
Hi..

I have a few questions :

1. I have a sheet which has data in rows. How can I have the row
highlighted
in red if a particular cell A3 is blank for example whereas cell A1 has
the
required data in it?
Click to expand...

select the whole row
go to ,,format,, conditional formatting,,
select "formula is" in the dropdown box that says "value is"
enter =$A$3=""
click the format button and select in the pattern tab the red colour.

2. Is it possible to protect only 1 sheet of a workbook? I have mutliple
sheets in a workbook which has to be updated and mailed but I don't wan't
the recepient to see any data on a particular sheet only. I can hide the
sheet but anyone can open that sheet be unhiding that sheet.
Click to expand...
yes
for others not to see anything?
make sure that they can not select any cells ---de-select the top ticks in
the list while protecting the sheet.
format all cell text to be white.
3. I have a shared worksheet where alot of people update the sheet as
required. How can I have a cell formatted so that only 8 digits can be
entered?
Click to expand...

select data
data validation
allow the text length to be equal to 8

Greettings from New Zealand
 
Thanks all for the response.


Bill Kuunders said:
see below


select the whole row
go to ,,format,, conditional formatting,,
select "formula is" in the dropdown box that says "value is"
enter =$A$3=""
click the format button and select in the pattern tab the red colour.


yes
for others not to see anything?
make sure that they can not select any cells ---de-select the top ticks in
the list while protecting the sheet.
format all cell text to be white.


select data
data validation
allow the text length to be equal to 8

Greettings from New Zealand
Click to expand...
 
Back
Top