Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hiding Formulas
I need to protect formulas entered into cells which are summed up into a
subtotal row and grouped/outlined for presentation. As i apply the protect worksheet, I can no longer expand or summarise presentation. Does anyone have a solution as i do not want my formulas to be overriden and need to be able to let users view both summarised and expanded results. worksheet is as follows: Expense Type Jan Feb Mar Apr Marketing 200 250 200 300 promos 40 90 80 100 entertainment 60 60 70 50 advert 100 100 50 150 Office Expenses 300 300 300 300 stationery 100 100 100 100 photocopy 150 150 150 150 postage 50 50 50 50 Salary and Wages 600 650 650 600 Basic Salary 500 500 500 500 Overtime 50 100 100 50 travelling 50 50 50 50 The figures are calculated from a list on another sheet within the workbook where data are usually entered without requiring any protection. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hiding Formulas | Excel Worksheet Functions | |||
Hiding formulas | Excel Discussion (Misc queries) | |||
Hiding formulas | Excel Worksheet Functions | |||
Protecting and Hiding formulas | New Users to Excel | |||
Hiding formulas in Excel 2000 | Excel Discussion (Misc queries) |