Hello, I designed an employee expense report form in Excel 2003 using the list function. The form looks like a table, with 6 columns and 20 rows, and the user lists expenses in the last 3 columns. In the 20th row of the table/list, there’s an asterisk/insert row. This is handy if the user needs to add more than 20 line items.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o
> </o>
Underneath the list, I have Sum formulas for the last 3 columns i.e. =SUM(D1:D20).
<o> </o>
The problem is that I want to lock these formula cells, but seems to affects the list’s functionality. The asterisk on the insert row disappears and the list can no longer grow. If I unprotect the formula cells, the insert row reappears. How can I have both the locked cells and the list’s insert row?
Thank you!
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o> </o>Underneath the list, I have Sum formulas for the last 3 columns i.e. =SUM(D1:D20).
<o
> </o>The problem is that I want to lock these formula cells, but seems to affects the list’s functionality. The asterisk on the insert row disappears and the list can no longer grow. If I unprotect the formula cells, the insert row reappears. How can I have both the locked cells and the list’s insert row?
Thank you!
