Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Excel: How do I make some cells remain the same when pulling it down?


11 Oct 2012   #1

Windows 7 / Vista
 
 
Excel: How do I make some cells remain the same when pulling it down?

Been having some problems with excel getting it to behave like Iwanted, tried google around but so clueless as to what to call things that it makes it hard. What I want is for a cell formula to do as I want when I pull on the lower-right corner down. Normally it the adds 1 to every cell address, but I need some of them to remain the same while others change. More exact:

I'm trying to make excelsheet where one collum is supposed to have the formula:

=F3*Dx/D3

x goes from 3 to eternity, while F3 and D3 should remain static while doing that drag thing. I remember there was a way to mark F3 and D3 so they don't change, but can't remember how.

So F4 has F3*D4/D3, F5 has F3*D5/D3 and so fourth.

My System SpecsSystem Spec
.

11 Oct 2012   #2

Win 7 Ultimate (64-bit), Win 8.1.1 (64-bit)
 
 

You want to change your formula so it looks like this: =$F$3*Dx/$D$3
This will cause the Dx reference to update as you copy the formula from cell to cell but the formula will always use the cells F3 and D3. Putting the $ in front of the cell value tells Excel not to change that, it's called an absolute reference. You can use $F$3 which locks the column and row, or $F3 which locks the column only while F$3 would lock the row only.
My System SpecsSystem Spec
12 Oct 2012   #3

Windows 7 Home Premium 64bit
 
 

My System SpecsSystem Spec
.


Reply

 Excel: How do I make some cells remain the same when pulling it down?




Thread Tools



Similar help and support threads for2: Excel: How do I make some cells remain the same when pulling it down?
Thread Forum
How do I make an Excel Spreadsheet my desktop wallpaper Themes and Styles
Solved Close Group remain disabled in Excel 2007 Microsoft Office
In Excel 2007 why doesn't locking and protecting cells work? Microsoft Office
make excel automatically insert a new row when you hit enter? Microsoft Office
Quickly fill blank cells in Excel. Microsoft Office
How can I make my Excel 2000 invoice template work? Microsoft Office
Excel un password cells Microsoft Office

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 06:24 AM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33