how do I use autofill if part of the formula refers to one cell and all other
other calculations down the row refer to that same cell? eg
Cell D1 is =C1/C10*100
Cell D2 is =C2/C10*100
Cell D3 is =C3/C10*100
--
old grey whiskers
how do I use autofill if part of the formula refers to one cell and all other
other calculations down the row refer to that same cell? eg
Cell D1 is =C1/C10*100
Cell D2 is =C2/C10*100
Cell D3 is =C3/C10*100
--
old grey whiskers
Enter this in D1 and just copy down:
=C1/C$10*100
The $ "locks" the row number.
Likewise, if you were to drag copy across:
=C1/$C10*100
The $ "locks" the column letter.
You can "mix and match" in any combination depending on your needs.
Biff
"old grey whiskers" <[email protected]> wrote in
message news:[email protected]...
> how do I use autofill if part of the formula refers to one cell and all
> other
> other calculations down the row refer to that same cell? eg
> Cell D1 is =C1/C10*100
> Cell D2 is =C2/C10*100
> Cell D3 is =C3/C10*100
> --
> old grey whiskers
ripper , I knew it could't be that difficult to do. thankyou
--
old grey whiskers
"Biff" wrote:
> Enter this in D1 and just copy down:
>
> =C1/C$10*100
>
> The $ "locks" the row number.
>
> Likewise, if you were to drag copy across:
>
> =C1/$C10*100
>
> The $ "locks" the column letter.
>
> You can "mix and match" in any combination depending on your needs.
>
> Biff
>
> "old grey whiskers" <[email protected]> wrote in
> message news:[email protected]...
> > how do I use autofill if part of the formula refers to one cell and all
> > other
> > other calculations down the row refer to that same cell? eg
> > Cell D1 is =C1/C10*100
> > Cell D2 is =C2/C10*100
> > Cell D3 is =C3/C10*100
> > --
> > old grey whiskers
>
>
>
You're welcome!
Biff
"old grey whiskers" <[email protected]> wrote in
message news:[email protected]...
> ripper , I knew it could't be that difficult to do. thankyou
> --
> old grey whiskers
>
>
> "Biff" wrote:
>
>> Enter this in D1 and just copy down:
>>
>> =C1/C$10*100
>>
>> The $ "locks" the row number.
>>
>> Likewise, if you were to drag copy across:
>>
>> =C1/$C10*100
>>
>> The $ "locks" the column letter.
>>
>> You can "mix and match" in any combination depending on your needs.
>>
>> Biff
>>
>> "old grey whiskers" <[email protected]> wrote in
>> message news:[email protected]...
>> > how do I use autofill if part of the formula refers to one cell and all
>> > other
>> > other calculations down the row refer to that same cell? eg
>> > Cell D1 is =C1/C10*100
>> > Cell D2 is =C2/C10*100
>> > Cell D3 is =C3/C10*100
>> > --
>> > old grey whiskers
>>
>>
>>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks