| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide cell range in worksheet
Can I hide the data in a cell range ?
I have some data in a cell range for lookup, say, K10:N30 as MyDataList, I don't want to show to a user, can I hide these data ? I think I can put these data on another worksheet and hide that worksheet, but I don't know how to reference this lookup table in the formnula. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Hide cell range in worksheet
This worked on Sheet1 when List1 was on Sheet2
=SUM(Book2!List1) You can also look at hiding columns and/or rows. Another is to Custom Format the number of list cells with ;;; Uncheck the protection for all other cells, and protect the worksheet. (just be aware that protecting a worksheet with or without a password won't keep everyone out. -- steveB Remove "AYN" from email to respond "Man Utd" wrote in message ... Can I hide the data in a cell range ? I have some data in a cell range for lookup, say, K10:N30 as MyDataList, I don't want to show to a user, can I hide these data ? I think I can put these data on another worksheet and hide that worksheet, but I don't know how to reference this lookup table in the formnula. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hide/Unhide worksheets upon entries in a range of the main worksheet | Excel Discussion (Misc queries) | |||
| Is there a way to hide worksheets and/or rows/columns based on information enter into a particular cell of range of cells? | New Users to Excel | |||
| Is there anyway to hide #DIV/0! in an excel worksheet cell. | Excel Programming | |||
| How do I automatically hide columns in a worksheet based on a cell value? | Excel Worksheet Functions | |||
| How do I hide a worksheet in Excel and use a password to un-hide . | Excel Discussion (Misc queries) | |||
Linear Mode
