Tags: copy, copying, decrease, excel, fields, heading, increase, microsoft, msdn, number, numbers, software, square, static, stay

How to make number of "static" fields stay the same when copying?

On Microsoft » Microsoft Excel

1,846 words with 2 Comments; publish: Thu, 22 May 2008 18:17:00 GMT; (30693.75, « »)

The heading says the most of my problem really.

When I copy just one square og many the numbers will increase o

decrease whether I copy them down or up the sheet.

I want most of the numbers to increase, but there are some stati

information on page 2 that I don't want to increase. Then the formul

will go wrong when it hits nothing or a strange value.

Are there som way of telling excel wich are to be "static" and not

--

MrHauge

----

MrHaugen's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3619

View this thread: http://www.excelforum.com/showthread.php?threadid=56019

All Comments

Leave a comment...

  • 2 Comments
    • "MrHaugen" <MrHaugen.2askl8_1152639360.5303.excel.questionfor.info.excelforum-nospam.com> wrote in

      message news:MrHaugen.2askl8_1152639360.5303.excel.questionfor.info.excelforum-nospam.com...

      > The heading says the most of my problem really.

      > When I copy just one square og many the numbers will increase or

      > decrease whether I copy them down or up the sheet.

      > I want most of the numbers to increase, but there are some static

      > information on page 2 that I don't want to increase. Then the formula

      > will go wrong when it hits nothing or a strange value.

      > Are there som way of telling excel wich are to be "static" and not?

      Look in help for the difference between absolute, relative, & mixed

      addressing.

      --

      David Biddulph

      #1; Thu, 22 May 2008 18:18:00 GMT