use of drag-fill handle in a crosstab

[Mehrdad]

How one can keep same-row cell (or same-column cell) constant in a formula
while he/she uses drag-fill handle?
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 |__|__|__|__|__|__|__|_

[smartin]

Mehrdad wrote:
> How one can keep same-row cell (or same-column cell) constant in a formula
> while he/she uses drag-fill handle?
> 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)

Is this what you are looking for?
=$A2+B$1

[Mehrdad]

How one can keep same-row cell (or same-column cell) constant in a formula
while he/she uses drag-fill handle?
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

[smartin]

Let's use a smaller example.

A B C
________
1 |__|__|__|
2 |__|_x|_J|
3 |__|_K|_L|

You have given formula "x" =A2+B1
Please write what you want for the formulas below:

"J" = ?
"K" = ?
"L" = ?

[Mehrdad]

Many thanks, it works, great help.