Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old August 9th 07, 04:04 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2007
Posts: 30
Default How to apply the same formula to an entire column

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?

  #2   Report Post  
Old August 9th 07, 04:11 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 3,268
Default How to apply the same formula to an entire column

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?



  #3   Report Post  
Old August 9th 07, 04:12 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 964
Default How to apply the same formula to an entire column

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?

  #4   Report Post  
Old August 9th 07, 04:24 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2007
Posts: 30
Default How to apply the same formula to an entire column

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?




  #5   Report Post  
Old August 9th 07, 04:26 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2007
Posts: 30
Default How to apply the same formula to an entire column

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?



  #6   Report Post  
Old August 9th 07, 04:34 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 4,393
Default How to apply the same formula to an entire column

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?





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I apply formula to entire column Stephan Excel Discussion (Misc queries) 2 October 1st 06 06:04 PM
How do I apply my function to the entire column? jsthngn Excel Discussion (Misc queries) 1 January 23rd 06 04:21 PM
I want to apply a formula to an entire column. kitcox Excel Discussion (Misc queries) 3 November 28th 05 02:48 AM
How do I apply a function to an entire column? didja New Users to Excel 1 November 23rd 05 06:04 AM
how to apply one function to an entire column of numbers guatdoc Excel Worksheet Functions 1 November 9th 05 05:26 AM


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

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017