View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Lisab Lisab is offline
external usenet poster
 
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?