is there a way to "fill" a series of cells but keep one number in formula fixed?

**oompa_l** · 06-11-2008, 06:59 PM

HI

I keep encountering a problem where I have a column of values on which I want to perform a calculation and one of the numbers in the equation I would like to remain fixed, or refer to one cell throughout the series. I find that as I drag the fill cursor to copy the formula down throughout all the values in the column not only does the cell reference that I want to change but the fixed cell reference also changes...I don't know if that reads clearly but I can't figure out how else to explain it...

any ideas?

**davesexcel** · 06-11-2008, 07:47 PM

Hi,
Try the $ signs ie:
=$A$1+A2
so when you drag the formula down it will look like this
=$A$1+A3
=$A$1+A4
=$A$1+A5
=$A$1+A6
=$A$1+A7
=$A$1+A8

**ratcat** · 06-11-2008, 09:41 PM

Here more info

http://www.awardsites.com/tutorials/...ell_ref-01.htm

**davesexcel** · 06-11-2008, 10:24 PM

Originally Posted by ratcat

Here more info

http://www.awardsites.com/tutorials/...ell_ref-01.htm

What is your link supposed to do??

**ratcat** · 06-12-2008, 03:01 AM

Originally Posted by davesexcel

What is your link supposed to do??

To show the differences between the Relative and Absolute Cell references and also to show there is more than one combination of a absolute cell references(displayed further down the page).

Feel free to ask me to edit the post if you feel that the link is misleading, your more than welcome to edit it yourself.

I hope this clears the air

Cheers

**oompa_l** · 06-12-2008, 12:39 PM

YES! finally, it works exactly how I wanted...

is there a way to "fill" a series of cells but keep one number in formula fixed?

LinkBack

Thread Tools

Rate This Thread

Display

is there a way to "fill" a series of cells but keep one number in formula fixed?

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions