Spreadsheet Masters

[ptonsparky]

How did I do this?

22	0.227272727		0.004892368		0.108	4.892
1800	0.002777778		0.001785714		3.214	1.786
400	0.0125		0.003571429		1.429	3.571
400

This is a section of spreadsheet I made to determine the current flow on a thermistor. Right or wrong, that's not the question.
The SS is filling in the formulas for me. ?? In the row under the 1st 400 there are no values or formula. If I type in any number in that blank row, it fills in the formula and calculates the results in the other columns. Skipping that line and entering a value, the 2nd 400, gives me nothing.

22	0.227272727		0.004892368		0.108	4.892
1800	0.002777778		0.001785714		3.214	1.786
400	0.0125		0.003571429		1.429	3.571
500	0.01		0.003333333		1.667	3.333
400

Deleting the second 400 and entering it again would fill in, etc.

I want know how? What function or setting is it?
FWIW, the laptop did not shut down properly and Excel saved the SS that was active at that time giving me the option to open it back up and continue.

 

[eric9822]

Sounds like a table. Here is a link to an Overview of Excel Tables.
https://support.office.com/en-us/ar...l-tables-7ab0bb7d-3a9e-4b56-a3c9-6c94334e492c

 

[Strathead]

How did I do this?

22	0.227272727		0.004892368		0.108	4.892
1800	0.002777778		0.001785714		3.214	1.786
400	0.0125		0.003571429		1.429	3.571
400

This is a section of spreadsheet I made to determine the current flow on a thermistor. Right or wrong, that's not the question.
The SS is filling in the formulas for me. ?? In the row under the 1st 400 there are no values or formula. If I type in any number in that blank row, it fills in the formula and calculates the results in the other columns. Skipping that line and entering a value, the 2nd 400, gives me nothing.

22	0.227272727		0.004892368		0.108	4.892
1800	0.002777778		0.001785714		3.214	1.786
400	0.0125		0.003571429		1.429	3.571
500	0.01		0.003333333		1.667	3.333
400

Deleting the second 400 and entering it again would fill in, etc.

I want know how? What function or setting is it?
FWIW, the laptop did not shut down properly and Excel saved the SS that was active at that time giving me the option to open it back up and continue.

Not sure i understand what you are saying, but the second 400 in the first example has a cell between it and the first 400 then the 500 value is typed in that missing cell.

 

[ptonsparky]

Not sure i understand what you are saying, but the second 400 in the first example has a cell between it and the first 400 then the 500 value is typed in that missing cell.

Yes. There are no formula of any kind in the cell between the two 400s, or any in the cells to the right. Entering 500 brings in all the appropriate formulas with the results.

I believe eric gave me the answer. I have not tried to duplicate the process on purpose yet. Excel must have made the connection when it shutdown improperly and then reopened.

:blink:

 

[Dzboyce]

Yes Excel will do that. I’ve had it do that for me before. I don’t know the exact conditions, but you get enough consecutive lines with the same formulas in the columms, it will replicate the formulas when you add a line and enter the data.

 

[gadfly56]

Yes Excel will do that. I’ve had it do that for me before. I don’t know the exact conditions, but you get enough consecutive lines with the same formulas in the columms, it will replicate the formulas when you add a line and enter the data.

I believe that if you insert a row between two rows with basically the same formulas, that row will also have the same format. If you insert a row under a row with formulas, it will not. You may be able to change this behavior in the Options settings. Also, to extend the formulas, you highlight the cells with formulas and then drag the lower right corner of the selection and it should copy/past the formulas however far down you go.

 

[GoldDigger]

I believe that if you insert a row between two rows with basically the same formulas, that row will also have the same format. If you insert a row under a row with formulas, it will not. You may be able to change this behavior in the Options settings. Also, to extend the formulas, you highlight the cells with formulas and then drag the lower right corner of the selection and it should copy/past the formulas however far down you go.

Yes, a workaround would be to edit a working row to have zero as the entry value, then copy that where needed instead of adding a row.

 

[ptonsparky]

Learning all sorts of stuff.

Thanks.

 

[Dennis Alwon]

You guys are good. I cannot answer without knowing the formulas. I use a lot of =IF() formulas. I had one on a spreadsheet that had 3 if statements inside the parenthesis.

Spreadsheets are fun but unless you use them a lot you tend to forget the tricks. I do anyway. Smart$ was excellent at this stuff