ExcelBanter - excel 2003 spreadsheet scrolling

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - excel 2003 spreadsheet scrolling (https://www.excelbanter.com/excel-discussion-misc-queries/221072-excel-2003-spreadsheet-scrolling.html)

george42b

excel 2003 spreadsheet scrolling

I have numbers in col A and B in rows 1-10.In col C1, I enter =A1+B1 and the
correct # shows in cell C1.When I scroll down the same # shows in the lower
cols
but the formula in each cell is correct. For example cell C6 shows =A6+B6
Help, please

Mike H

excel 2003 spreadsheet scrolling

Try

Tools|Options - Calculation tab and select automatic.

Mike

"george42b" wrote:

I have numbers in col A and B in rows 1-10.In col C1, I enter =A1+B1 and the
correct # shows in cell C1.When I scroll down the same # shows in the lower
cols
but the formula in each cell is correct. For example cell C6 shows =A6+B6
Help, please

All times are GMT +1. The time now is 03:12 PM.