Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |__|__|__|__|__|__|__|_ |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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" = ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
use of drag-fill handle in a crosstab | Excel Discussion (Misc queries) | |||
fill handle and cell drag-and-drop | Excel Discussion (Misc queries) | |||
if you drag the fill handle will it decrement the series | Excel Discussion (Misc queries) | |||
if you drag the fill handle will it decrement the series | Excel Discussion (Misc queries) | |||
What is keyboard shortcut equivalent to drag the fill handle | Excel Discussion (Misc queries) |