+ Reply to Thread
Results 1 to 2 of 2

Adding formula to Entire Column

  1. #1
    Registered User
    Join Date
    06-28-2007
    Posts
    63

    Adding formula to Entire Column

    I am working a spread sheet that has two columns. Column A has prices, Column B calculates the change in prices of column A. So each cell in column B contains a forumla that calculates the change in price between the previous price in column A and the current price.

    I need to calculate a large number or prices, so Is there a way to automatically, enter the formula into all of the cells in column B and make sure that that formula adjusts so each cell in B is calculating the change in price of the corresponding adjacent A cell?

    Thanks!
    Link removed by Mod

  2. #2
    Valued Forum Contributor
    Join Date
    09-23-2005
    Location
    Bristol, UK
    MS-Off Ver
    2007
    Posts
    664
    Hi,

    Select your cell with the formula in - then put the mouse in the bottom right hand corner so that the cursor turns to a black cross, then drag the mouse down to the end of your range.

    HTH,

    SamuelT

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1