How one can keep same-row cell (or same-column cell) constant in a formula
while he/she uses drag-fill handle across rows and columns of a table?
There is a formula in B2: =A2+B1. We want to use drag-fill to fill:
- row 2 while keeping A2 the same, and,
- column B while keeping B2 the same
(changing A2 to $A$2 is not helpful)

A B C D E F G
_____________________
1 |__|__|__|__|__|__|__|_
2 |__|__|__|__|__|__|__|_
3 |__|__|__|__|__|__|__|_
4 |__|__|__|__|__|__|__|_
5 |__|__|__|__|__|__|__|_
6 |__|__|__|__|__|__|__|_

This is a required functionality doing what-if and scenarios analysis.

See if this does what you want:

=$A2+B$1

--
Biff
Microsoft Excel MVP


"Mehrdad" wrote in message
...
How one can keep same-row cell (or same-column cell) constant in a formula
while he/she uses drag-fill handle across rows and columns of a table?
There is a formula in B2: =A2+B1. We want to use drag-fill to fill:
- row 2 while keeping A2 the same, and,
- column B while keeping B2 the same
(changing A2 to $A$2 is not helpful)

A B C D E F G
_____________________
1 |__|__|__|__|__|__|__|_
2 |__|__|__|__|__|__|__|_
3 |__|__|__|__|__|__|__|_
4 |__|__|__|__|__|__|__|_
5 |__|__|__|__|__|__|__|_
6 |__|__|__|__|__|__|__|_

This is a required functionality doing what-if and scenarios analysis.

Mehrdad wrote:
How one can keep same-row cell (or same-column cell) constant in a formula
while he/she uses drag-fill handle across rows and columns of a table?
There is a formula in B2: =A2+B1. We want to use drag-fill to fill:
- row 2 while keeping A2 the same, and,
- column B while keeping B2 the same
(changing A2 to $A$2 is not helpful)

A B C D E F G
_____________________
1 |__|__|__|__|__|__|__|_
2 |__|__|__|__|__|__|__|_
3 |__|__|__|__|__|__|__|_
4 |__|__|__|__|__|__|__|_
5 |__|__|__|__|__|__|__|_
6 |__|__|__|__|__|__|__|_

This is a required functionality doing what-if and scenarios analysis.

I direct you to a duplicate thread in MPE.misc, where you have not
responded to two of my suggestions.

Here is a link in case you lost track of it:

http://groups.google.com/group/micro...9df7551aae9a6#

Please do not multi-post.