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

  • Thread starter Thread starter MrHaugen
  • Start date Start date
M

MrHaugen

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
 
MrHaugen said:
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?
Click to expand...

Look in help for the difference between absolute, relative, & mixed
addressing.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automatic indexing of numbers 8
"lock" fields so they don't change number while copying formulas? 1
Want to link a cell of numbers with a cell of text & can sort 1
NUmber of Columns 6
Copying Worksheets 2
How to show % increase when accuracy decreases? 2
How to increase the number of files displayed when I click 'file' 3
Save data from Notebook: copying to the USB stick using Linux and the command line 0

Back
Top