Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Outlining on a protected spreadsheet
I have created an extensive spreadsheet for a construction developer
including budget and payment columns for 3 years, each year containing 4 Qtrs and each Qtr containing 3 months. There is data to be inputted for each months payments, etc and Qtr and YTD totals are totaled in separate columns. I have set up my spreadsheet with outlining for the Qtrs and YTD so they expand and collapse for easy viewing. It works great. However when I lock the cells with formulas, etc and then protect the worksheets I can no longer expand the outline columns. Help!! This is critical!!/p |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to SUM in a protected spreadsheet | Excel Worksheet Functions | |||
Enable outlining in a protected worksheet | Excel Discussion (Misc queries) | |||
Can just the formatting alone in a spreadsheet be protected? | Excel Discussion (Misc queries) | |||
Tab Stop with a protected Spreadsheet | Excel Worksheet Functions | |||
Outlining in Protected Sheet - Attention DP | Excel Discussion (Misc queries) |