use of drag-fill handle in a crosstab
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
|