C
corrie
The spreadsheet that I am building is for giving price quotes for serve
builds. I need to use grouping and outline to be able to shrink eac
section down to just subtotals (subtotal of server components
back-ups, and software). This is no problem, the problem is howeve
that the functions that are used to calculate everything need to be i
locked cells. As soon as I lock the formula cells, and protect th
sheet, I can't use the outline buttons on the side to shrink or expand
I tried changing the protecting to include formatting,inserting an
deleting columns and rows, but it still won't let me use them.
I would appreciate any suggestions... thanks
builds. I need to use grouping and outline to be able to shrink eac
section down to just subtotals (subtotal of server components
back-ups, and software). This is no problem, the problem is howeve
that the functions that are used to calculate everything need to be i
locked cells. As soon as I lock the formula cells, and protect th
sheet, I can't use the outline buttons on the side to shrink or expand
I tried changing the protecting to include formatting,inserting an
deleting columns and rows, but it still won't let me use them.
I would appreciate any suggestions... thanks