Filling sliding accross and along columns

  • Thread starter Thread starter Kaci Tizi Ouzou
  • Start date Start date
K

Kaci Tizi Ouzou

Hi all,

Can anybody tell me how can I slide a formula contsinaing a constant
across lines and along columns.

Here is an example

a11 a12 a13
a21 a22 a23
a31 a32 a33

What I would like to have is

a11 a12 a13
a21/a11 a22/a11 a23/a11 : For this I use =CELL/$CELL$XX and slide
across
a31/a11 a32/a11 a33/a11 : Seems like sliding the previous formula
along

columns is not working.

Cheers
 
kaci,

just a suggestion for you to play around with and figure the solutio
our for yourself.

for the divisor, try $A$1, $A1, A$1 in order to anchor the cell, th
column, the row respectively.

mac
 
If you are talking about autofilling the formula across

The $ represents what will be locked in place

If you use A$15 the column is not locked but the row is

If you use $A15 the column is now locked but the row isn't

if you use $A$15 both row and column are locked

if you use A15 neither is locked

Does that help?
 
Back
Top