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) Is this what you are looking for? =$A2+B$1 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
use of drag-fill handle in a crosstab
On Jul 11, 1:44*pm, smartin wrote:
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 Many thanks, it works, great help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
fill handle and cell drag-and-drop | Excel Discussion (Misc queries) | |||
Fill Handle doesn't display - Allow cell drag and Drop option is c | 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) |