Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Scrolling in Excel Spreadsheet suddenly DISABLED | Excel Discussion (Misc queries) | |||
how do I stop the excel spreadsheet from scrolling to the right | Excel Discussion (Misc queries) | |||
Live Scrolling/Real-Time /Smooth Scrolling doesn't work for me in Excel 2003 | Excel Discussion (Misc queries) | |||
tab scrolling buttons - excel 2003 | Excel Worksheet Functions | |||
strange scrolling in Excel 2003 | Excel Discussion (Misc queries) |