If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 How do I create a formula repeated on the adjacentt columns?
 Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

## How do I create a formula repeated on the adjacentt columns?

#1
October 1st 07, 09:54 PM posted to microsoft.public.excel.newusers
 Excelless external usenet poster Posts: 2
How do I create a formula repeated on the adjacentt columns?

I am trying to make the same operation for each column - the only difference
is in the rows, e.g.
C3=A3*B*
C4=A4*B4, etc.

I don't want to have to re-enter a similar formula for each added row.

Thanks.
#2
October 1st 07, 10:09 PM posted to microsoft.public.excel.newusers
 George Gee external usenet poster Posts: 109
How do I create a formula repeated on the adjacentt columns?

Select cell C3.
Move your curser to the fill handle (lower right of cell).
When the curser becomes a black cross, left-click and
drag down as far as you wish.

George Gee

"Excelless" > wrote in message
...
>I am trying to make the same operation for each column - the only
>difference
> is in the rows, e.g.
> C3=A3*B*
> C4=A4*B4, etc.
>
> I don't want to have to re-enter a similar formula for each added row.
>
> Thanks.

#3
October 1st 07, 10:34 PM posted to microsoft.public.excel.newusers
 Excelless external usenet poster Posts: 2
How do I create a formula repeated on the adjacentt columns?

But how do I create the formula itself? This just overwrote all the previous
data cells with the top cell's value - thx.

"Excelless" wrote:

> I am trying to make the same operation for each column - the only difference
> is in the rows, e.g.
> C3=A3*B*
> C4=A4*B4, etc.
>
> I don't want to have to re-enter a similar formula for each added row.
>
> Thanks.

#4
October 1st 07, 10:44 PM posted to microsoft.public.excel.newusers
 George Gee external usenet poster Posts: 109
How do I create a formula repeated on the adjacentt columns?

If you want to multiply A3 by B3, then in C3 type: =A3*B3
and copy down as previously described!

If you require anything other than this, I suggest you try to
explain exactly what it is that you want, in more detail.

Also it would be prudent to use a *copy* of your workbook
to try anything new.

George Gee

"Excelless" > wrote in message
...
>
> But how do I create the formula itself? This just overwrote all the
> previous
> data cells with the top cell's value - thx.
>
> "Excelless" wrote:
>
>> I am trying to make the same operation for each column - the only
>> difference
>> is in the rows, e.g.
>> C3=A3*B*
>> C4=A4*B4, etc.
>>
>> I don't want to have to re-enter a similar formula for each added row.
>>
>> Thanks.

#5
October 2nd 07, 12:55 AM posted to microsoft.public.excel.newusers
 Gord Dibben external usenet poster Posts: 22,909
How do I create a formula repeated on the adjacentt columns?

Tools>Options>Calculation.

Make sure you are set for "Automatic".

Also be sure you don't have absolute references in the first cell.

C3 should have =A3*B3 which will increment to =A4*B4 as you copy down.

You may have =\$A\$3*\$B\$3 which fixes the references to just those two cells.

Remove the \$ signs from C3 formula and try again with the copy down.

Don't forget the = sign

Gord Dibben MS Excel MVP

On Mon, 1 Oct 2007 14:34:00 -0700, Excelless
> wrote:

>
>But how do I create the formula itself? This just overwrote all the previous
>data cells with the top cell's value - thx.
>
>"Excelless" wrote:
>
>> I am trying to make the same operation for each column - the only difference
>> is in the rows, e.g.
>> C3=A3*B*
>> C4=A4*B4, etc.
>>
>> I don't want to have to re-enter a similar formula for each added row.
>>
>> Thanks.

 Thread Tools Display Modes Linear Mode

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off
 Forum Jump User Control Panel Private Messages Subscriptions Who's Online Search Forums Forums Home Excel Newsgroups     Excel Discussion (Misc queries)     Setting up and Configuration of Excel     New Users to Excel     Excel Worksheet Functions     Links and Linking in Excel     Charts and Charting in Excel     Excel Programming About ExcelBanter     About this forum

 Similar Threads Thread Thread Starter Forum Replies Last Post Merging adjacent repeated columns with a macro [email protected] Excel Discussion (Misc queries) 2 April 3rd 07 07:44 PM how do I create a formula in excel with using 2 columns of info? Sloth Excel Worksheet Functions 0 August 17th 06 08:35 PM Printing text in a repeated cell/row that is longer than repeated Valerie Dyet Excel Discussion (Misc queries) 1 February 13th 06 03:27 AM Repeated Columns Don't look same on all pages... Al Franz New Users to Excel 1 February 24th 05 02:59 PM repeated transpose from rows to columns with unequal groups kraymond Excel Discussion (Misc queries) 3 December 20th 04 02:39 PM

All times are GMT +1. The time now is 11:27 PM.