use of drag-fill handle in a crosstab
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 |__|__|__|__|__|__|__|_ |
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) A B C D E F G _____________________ 1 |__|__|__|__|__|__|__|_ 2 |__|__|__|__|__|__|__|_ 3 |__|__|__|__|__|__|__|_ 4 |__|__|__|__|__|__|__|_ 5 |__|__|__|__|__|__|__|_ 6 |__|__|__|__|__|__|__|_ 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" = ? |
All times are GMT +1. The time now is 12:43 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com