If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Protect & Hide Sheet
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? 4. In addition to above, how can I limit the length of characters allowed in a cell not to exceed 40 characters. Thanks, |
#2
|
|||
|
|||
Protect & Hide Sheet
For number 4. in EXCEL 2007 try the following:-
- click in the cell that you wish to restrict (I 9 for example) - Data - Data Tools group - Data Validation - Data Validation The Data Validation window should now launch. - Settings tab - Allow: Text length - Data: between - Minimum: 0 - Maximum: 40 OK You should now find that you cannot enter more than 40 text characters in the selected cell(s). If my comments have helped please hit Yes. Thanks. "Panchi" wrote: 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? 4. In addition to above, how can I limit the length of characters allowed in a cell not to exceed 40 characters. Thanks, . |
#3
|
|||
|
|||
Protect & Hide Sheet
Hi Panchi, for number 3, please see my other posting (with regard to number
4) and just play with the settings until it gives you what you want. If my comments have helped please hit yes. Thanks. "Panchi" wrote: 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? 4. In addition to above, how can I limit the length of characters allowed in a cell not to exceed 40 characters. Thanks, . |
#4
|
|||
|
|||
Protect & Hide Sheet
Sorry forgot to mention that I am using Excel 2003. "trip_to_tokyo" wrote in message ... Hi Panchi, for number 3, please see my other posting (with regard to number 4) and just play with the settings until it gives you what you want. If my comments have helped please hit yes. Thanks. "Panchi" wrote: 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? 4. In addition to above, how can I limit the length of characters allowed in a cell not to exceed 40 characters. Thanks, . |
#5
|
|||
|
|||
Protect & Hide Sheet
It's a bit late now! (only joking - no prob).
"Panchi" wrote: Sorry forgot to mention that I am using Excel 2003. "trip_to_tokyo" wrote in message ... Hi Panchi, for number 3, please see my other posting (with regard to number 4) and just play with the settings until it gives you what you want. If my comments have helped please hit yes. Thanks. "Panchi" wrote: 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? 4. In addition to above, how can I limit the length of characters allowed in a cell not to exceed 40 characters. Thanks, . . |
Thread Tools | |
Display Modes | |
|
|