Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I apply formula to entire column | Excel Discussion (Misc queries) | |||
How do I apply my function to the entire column? | Excel Discussion (Misc queries) | |||
I want to apply a formula to an entire column. | Excel Discussion (Misc queries) | |||
How do I apply a function to an entire column? | New Users to Excel | |||
how to apply one function to an entire column of numbers | Excel Worksheet Functions |