| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Locking Cells
I would like to hide and lock the cells that comprise subtotals in my data.
What is the easiest way to just display the subtotal rows and hide the rows that make up the subtotals and lock them so that the recipient can't open them? Thanks in advance for your assistance. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Locking Cells
I think I would convert those subtotals to values and delete the detail rows.
Then save that workbook with a new name. Then share that workbook that has the subtotals as values. SJT wrote: I would like to hide and lock the cells that comprise subtotals in my data. What is the easiest way to just display the subtotal rows and hide the rows that make up the subtotals and lock them so that the recipient can't open them? Thanks in advance for your assistance. -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Locking Cells
Thanks.
"Dave Peterson" wrote: I think I would convert those subtotals to values and delete the detail rows. Then save that workbook with a new name. Then share that workbook that has the subtotals as values. SJT wrote: I would like to hide and lock the cells that comprise subtotals in my data. What is the easiest way to just display the subtotal rows and hide the rows that make up the subtotals and lock them so that the recipient can't open them? Thanks in advance for your assistance. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking Groups of cells between workbooks | Excel Discussion (Misc queries) | |||
| Locking all cells accross when sorting columns | New Users to Excel | |||
| locking formula in cells in without locking whole sheet | Excel Discussion (Misc queries) | |||
| Locking linked cells | Excel Worksheet Functions | |||
| Locking certain cells | Excel Worksheet Functions | |||
Linear Mode
