Magic Formula Appearance

P

PT

Excel 2003 Win XP Home

I use a simple worksheet which consist of five columns into which I add four
figures of numeric data across a new successive row each day. The fifth
column includes a sum formula to sum the entries on that row's four columns.

Here's the mystery. When I enter the fourth of the data figures on a row,
the sum magically appears in the fifth column. I've checked and the sum
cell is blank prior to my entering the data figures. Somehow, Excel has
figured out that the new row should contain the same formula as the cell
immediately above.

How does this happen?
 
G

Gord Dibben

Tools>Options>Edit> Extend data range formats and formulas.

If three or more cells adjacent to the cell have a format or a formula Excel
extends it.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Microsoft Excel Formulas 2
Sum variable range of column entries in offset cell 2
User Form Formula ? 2
FORMULA CHANGES 2
Delete a formula but leave the data. 2
Trying to create a formula for adding and subtracting columns. 4
Need help creating a sum based on variable data. 1
How to sum of two max figures out of five and four figures 3

Top