Help!

How to apply the same formula to an entire column

 
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> New Users RSS
Next:  can't modify pivot in older version  
Author Message
Lisab
External


Since: Jun 28, 2007
Posts: 6



PostPosted: Thu Aug 09, 2007 12:04 pm    Post subject: How to apply the same formula to an entire column
Archived from groups: microsoft>public>excel>newusers (more info?)

I have a sheet that has over 6,000 rows (data transfered from an access table)

I have added a column

In the new column I want the formula to be =A3=B3 which will result in True
or False and in the next row it want it to be =A4=B4 then the next row should
be =A5=B5 and so on

How do I apply this formula to the entire column without having to go from
row to row inputting the same formula?
Back to top
Peo Sjoblom
External


Since: Sep 15, 2003
Posts: 2970



PostPosted: Thu Aug 09, 2007 12:11 pm    Post subject: Re: How to apply the same formula to an entire column [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Make sure you use an adjacent column which I believe you do, so in C3 put

=A3=B3

press enter, select C3 again, move the cursor with the mouse to the lower
right corner of C3, and when the thick cross changes into a thin cross
double click and you will automatically copy down the formula to the end of
the data in columns A and B



--
Regards,

Peo Sjoblom



"Lisab" wrote in message

>I have a sheet that has over 6,000 rows (data transfered from an access
>table)
>
> I have added a column
>
> In the new column I want the formula to be =A3=B3 which will result in
> True
> or False and in the next row it want it to be =A4=B4 then the next row
> should
> be =A5=B5 and so on
>
> How do I apply this formula to the entire column without having to go from
> row to row inputting the same formula?
Back to top
Elkar
External


Since: Mar 07, 2006
Posts: 605



PostPosted: Thu Aug 09, 2007 12:12 pm    Post subject: RE: How to apply the same formula to an entire column [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Just copy and paste.

Enter your formula in the first row. Then Copy that formula. Select your
range of cells to copy to. Then Paste. Excel will automatically increment
the cell references in the formula.

HTH,
Elkar


"Lisab" wrote:

> I have a sheet that has over 6,000 rows (data transfered from an access table)
>
> I have added a column
>
> In the new column I want the formula to be =A3=B3 which will result in True
> or False and in the next row it want it to be =A4=B4 then the next row should
> be =A5=B5 and so on
>
> How do I apply this formula to the entire column without having to go from
> row to row inputting the same formula?
Back to top
Lisab
External


Since: Jun 28, 2007
Posts: 6



PostPosted: Thu Aug 09, 2007 12:24 pm    Post subject: Re: How to apply the same formula to an entire column [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Thanks!

"Peo Sjoblom" wrote:

> Make sure you use an adjacent column which I believe you do, so in C3 put
>
> =A3=B3
>
> press enter, select C3 again, move the cursor with the mouse to the lower
> right corner of C3, and when the thick cross changes into a thin cross
> double click and you will automatically copy down the formula to the end of
> the data in columns A and B
>
>
>
> --
> Regards,
>
> Peo Sjoblom
>
>
>
> "Lisab" wrote in message
>
> >I have a sheet that has over 6,000 rows (data transfered from an access
> >table)
> >
> > I have added a column
> >
> > In the new column I want the formula to be =A3=B3 which will result in
> > True
> > or False and in the next row it want it to be =A4=B4 then the next row
> > should
> > be =A5=B5 and so on
> >
> > How do I apply this formula to the entire column without having to go from
> > row to row inputting the same formula?
>
>
>
Back to top
Lisab
External


Since: Jun 28, 2007
Posts: 6



PostPosted: Thu Aug 09, 2007 12:26 pm    Post subject: RE: How to apply the same formula to an entire column [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

This works too, Thanks! Now I know two ways to do it.

"Elkar" wrote:

> Just copy and paste.
>
> Enter your formula in the first row. Then Copy that formula. Select your
> range of cells to copy to. Then Paste. Excel will automatically increment
> the cell references in the formula.
>
> HTH,
> Elkar
>
>
> "Lisab" wrote:
>
> > I have a sheet that has over 6,000 rows (data transfered from an access table)
> >
> > I have added a column
> >
> > In the new column I want the formula to be =A3=B3 which will result in True
> > or False and in the next row it want it to be =A4=B4 then the next row should
> > be =A5=B5 and so on
> >
> > How do I apply this formula to the entire column without having to go from
> > row to row inputting the same formula?
Back to top
Bernard Liengme
External


Since: Jan 27, 2004
Posts: 2613



PostPosted: Thu Aug 09, 2007 4:34 pm    Post subject: Re: How to apply the same formula to an entire column [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Want a third way:
Select the range of cells, type the formula, use CTRL+ENTER rather than
simple Enter.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Lisab" wrote in message

> This works too, Thanks! Now I know two ways to do it.
>
> "Elkar" wrote:
>
>> Just copy and paste.
>>
>> Enter your formula in the first row. Then Copy that formula. Select
>> your
>> range of cells to copy to. Then Paste. Excel will automatically
>> increment
>> the cell references in the formula.
>>
>> HTH,
>> Elkar
>>
>>
>> "Lisab" wrote:
>>
>> > I have a sheet that has over 6,000 rows (data transfered from an access
>> > table)
>> >
>> > I have added a column
>> >
>> > In the new column I want the formula to be =A3=B3 which will result in
>> > True
>> > or False and in the next row it want it to be =A4=B4 then the next row
>> > should
>> > be =A5=B5 and so on
>> >
>> > How do I apply this formula to the entire column without having to go
>> > from
>> > row to row inputting the same formula?
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> New Users All times are: Eastern Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum