software

When I add new lines to expand a worksheet, existing formulas do not extend
to the new lines. I have the Tools/Options/Edit 'Extend List Formats amp;
Formulas' box checked. Should this happen automatically?

gt;Should this happen automatically?

Yes it should. But it doesn't happen when you insert the row, but rather it
happens after you enter the data in the new row.

--
Jim
quot;BillyVquot; gt; wrote in message
...
gt; When I add new lines to expand a worksheet, existing formulas do not
gt; extend
gt; to the new lines. I have the Tools/Options/Edit 'Extend List Formats amp;
gt; Formulas' box checked. Should this happen automatically?
Thanks very much. I've actually had that happen in the past after I entered
data, and didn't know why. But I am working on a new spreadsheet, and
nothing I try seems to extend the formulas, even entering data - I'm still
stumped.

Billquot;Jim Rechquot; wrote:

gt; gt;Should this happen automatically?
gt;
gt; Yes it should. But it doesn't happen when you insert the row, but rather it
gt; happens after you enter the data in the new row.
gt;
gt; --
gt; Jim
gt; quot;BillyVquot; gt; wrote in message
gt; ...
gt; gt; When I add new lines to expand a worksheet, existing formulas do not
gt; gt; extend
gt; gt; to the new lines. I have the Tools/Options/Edit 'Extend List Formats amp;
gt; gt; Formulas' box checked. Should this happen automatically?
gt;
gt;
gt;

gt;gt;I'm still stumped.

Me too. I guess I'd have to see the worksheet or a snippet of it that has
the problem. MS did document how auto extend works if you want to sleuth
further:

support.microsoft.com/kb/231002/

--
Jim
quot;BillyVquot; gt; wrote in message
...
| Thanks very much. I've actually had that happen in the past after I
entered
| data, and didn't know why. But I am working on a new spreadsheet, and
| nothing I try seems to extend the formulas, even entering data - I'm still
| stumped.
|
| Bill
|
|
| quot;Jim Rechquot; wrote:
|
| gt; gt;Should this happen automatically?
| gt;
| gt; Yes it should. But it doesn't happen when you insert the row, but
rather it
| gt; happens after you enter the data in the new row.
| gt;
| gt; --
| gt; Jim
| gt; quot;BillyVquot; gt; wrote in message
| gt; ...
| gt; gt; When I add new lines to expand a worksheet, existing formulas do not
| gt; gt; extend
| gt; gt; to the new lines. I have the Tools/Options/Edit 'Extend List Formats
amp;
| gt; gt; Formulas' box checked. Should this happen automatically?
| gt;
| gt;
| gt;
Thanks again - I'll give that a try.
quot;Jim Rechquot; wrote:

gt; gt;gt;I'm still stumped.
gt;
gt; Me too. I guess I'd have to see the worksheet or a snippet of it that has
gt; the problem. MS did document how auto extend works if you want to sleuth
gt; further:
gt;
gt; support.microsoft.com/kb/231002/
gt;
gt; --
gt; Jim
gt; quot;BillyVquot; gt; wrote in message
gt; ...
gt; | Thanks very much. I've actually had that happen in the past after I
gt; entered
gt; | data, and didn't know why. But I am working on a new spreadsheet, and
gt; | nothing I try seems to extend the formulas, even entering data - I'm still
gt; | stumped.
gt; |
gt; | Bill
gt; |
gt; |
gt; | quot;Jim Rechquot; wrote:
gt; |
gt; | gt; gt;Should this happen automatically?
gt; | gt;
gt; | gt; Yes it should. But it doesn't happen when you insert the row, but
gt; rather it
gt; | gt; happens after you enter the data in the new row.
gt; | gt;
gt; | gt; --
gt; | gt; Jim
gt; | gt; quot;BillyVquot; gt; wrote in message
gt; | gt; ...
gt; | gt; gt; When I add new lines to expand a worksheet, existing formulas do not
gt; | gt; gt; extend
gt; | gt; gt; to the new lines. I have the Tools/Options/Edit 'Extend List Formats
gt; amp;
gt; | gt; gt; Formulas' box checked. Should this happen automatically?
gt; | gt;
gt; | gt;
gt; | gt;
gt;
gt;
gt;

That support side helped a lot - thanks for the tip. I found a couple of
other things there too. My worksheet is still erratic - works sometimes, and
not other times. The support site suggests it could have to do with the way
the above cells are formatted, which I don't want to change. But at least I
(probably) know why.

Thanks again.
Bill

quot;Jim Rechquot; wrote:

gt; gt;gt;I'm still stumped.
gt;
gt; Me too. I guess I'd have to see the worksheet or a snippet of it that has
gt; the problem. MS did document how auto extend works if you want to sleuth
gt; further:
gt;
gt; support.microsoft.com/kb/231002/
gt;
gt; --
gt; Jim
gt; quot;BillyVquot; gt; wrote in message
gt; ...
gt; | Thanks very much. I've actually had that happen in the past after I
gt; entered
gt; | data, and didn't know why. But I am working on a new spreadsheet, and
gt; | nothing I try seems to extend the formulas, even entering data - I'm still
gt; | stumped.
gt; |
gt; | Bill
gt; |
gt; |
gt; | quot;Jim Rechquot; wrote:
gt; |
gt; | gt; gt;Should this happen automatically?
gt; | gt;
gt; | gt; Yes it should. But it doesn't happen when you insert the row, but
gt; rather it
gt; | gt; happens after you enter the data in the new row.
gt; | gt;
gt; | gt; --
gt; | gt; Jim
gt; | gt; quot;BillyVquot; gt; wrote in message
gt; | gt; ...
gt; | gt; gt; When I add new lines to expand a worksheet, existing formulas do not
gt; | gt; gt; extend
gt; | gt; gt; to the new lines. I have the Tools/Options/Edit 'Extend List Formats
gt; amp;
gt; | gt; gt; Formulas' box checked. Should this happen automatically?
gt; | gt;
gt; | gt;
gt; | gt;
gt;
gt;
gt;