+ Reply to Thread
Results 1 to 2 of 2

Copy Cell or Column without advancing formula reference?

  1. #1
    sgluntz
    Guest

    Copy Cell or Column without advancing formula reference?

    I have a spreadsheet with formulas referring to another worksheet. I need to
    copy the columns however, each time I do, the formulas advance to another
    cell. Which is an incorrect reference, skewing my results.

  2. #2
    Duke Carey
    Guest

    RE: Copy Cell or Column without advancing formula reference?

    You need to modify the formulas to use absolute references. Edit each of the
    cell addresses in the formula and put $ (dollar signs) in front of the column
    letters.

    "sgluntz" wrote:

    > I have a spreadsheet with formulas referring to another worksheet. I need to
    > copy the columns however, each time I do, the formulas advance to another
    > cell. Which is an incorrect reference, skewing my results.


+ 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