| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying formulas by scrolling
When I attempt to copy formulas by scrolling down, I the formula appears to
copy correctly, but the value in each cell remains the same. For example, when I scroll formula A2-A1 and scroll down, the formula increases by 1 in each cell. However, the value appearing in each cell remains the same number--almost as if ignorning the formula! What is going on? THANKS!!! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copying formulas by scrolling
ToolsOptionsCalculation.
Check Automatic. Gord Dibben MS Excel MVP On Fri, 12 Dec 2008 14:43:01 -0800, skluck wrote: When I attempt to copy formulas by scrolling down, I the formula appears to copy correctly, but the value in each cell remains the same. For example, when I scroll formula A2-A1 and scroll down, the formula increases by 1 in each cell. However, the value appearing in each cell remains the same number--almost as if ignorning the formula! What is going on? THANKS!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel- smooth scrolling (instead of 'snap' scrolling) | Setting up and Configuration of Excel | |||
| copying formula without scrolling 9000 rows | Excel Worksheet Functions | |||
| Live Scrolling/Real-Time /Smooth Scrolling doesn't work for me in Excel, even 2007 beta | Excel Discussion (Misc queries) | |||
| copy formulas without scrolling, excel 2003. | New Users to Excel | |||
| Live Scrolling/Real-Time /Smooth Scrolling doesn't work for me in Excel 2003 | Excel Discussion (Misc queries) | |||
Hybrid Mode
