Prev: VLookup
Next: Excel 2010 beta autosum includes other sums in range!
From: Michael Weinhardt - MSFT on 1 Mar 2010 03:17
Hi,

[for Excel 2007]

I have a worksheet with one data table. The cells in the data row that have
formulas are locked - to avoid changing the formula and to remove them from
the tab order. All other cells in the worksheet are unlocked.

When I protect the worksheet, and make sure to check the options that allow
me to insert rows, I am still not allowed to insert new data table rows. For
example, pressing TAB at the end of one data row will not automatically
create a new row and shift the focus to the first cell in the new row.
Unprotecting the worksheet gives me the desired row insertion but without the
cell protection.

How can I configure the data table to lock certain cells in each data row
*and* retain the automatic row insertion I've come to know and love? :)

Oh, and is this possible *without* code?

Thanks!
Michael
 | 
Pages: 1
Prev: VLookup
Next: Excel 2010 beta autosum includes other sums in range!