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


  1. flashist
    Posts : 54
    Windows 7 / Vista
       New #1

    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 Computer
    Quote Quote

  3. strollin
    Posts : 3,371
    W10 Pro desktop, W11 laptop, W11 Pro tablet (all 64-bit)
       New #2

    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 Computer
    Quote Quote

  4. Irene
    Posts : 3,009
    Windows 7 Home Premium 64bit
       New #3

    Strollin is 'absolutely' correct.
    .
    Switch between relative, absolute, and mixed references - Excel - Office.com
      My Computer
    Quote Quote

 

  Related Discussions
i have excel file, with the following formulas Cell G2 formula =SUM(D2:F2) Cell G3 formula =SUM(G2, D3:F3) Cell G4 formula =SUM(G3, D4:F4) Cell G5 formula =SUM(G4, D5:F5) i want the result of G5 (and the rest of G cells) cells to be invisible unless there is some value in D5 to F5 cells ...
Format cells in excel 2007
in Microsoft Office

I have a spreadsheet made in excel 2007. In one of the cells is a number with three zeros in front of it and one zero at the end. However it always drops the zeros and shows only the other numbers. I select the cell and click on "format cells", but there is nothing I see that will show all the...
when i open two or more excel files and work on them its working fine but after finished work on them whenever i close them i have to close them one by one because close group , minimize group , etc. remain disabled on right click to excel files.
This is literally driving me nuts. I've created a workbook with about 15 worksheets and prior to sending to the customer I want to lock the cells so that they can't be changed without a password. So, I first select the cells I don't want to be altered and lock them. Then I go to "protect...
Excel un password cells
in Microsoft Office

Hi I have a excel sheet that some cells are password protected i have no idea what the password is any ideas how i can find the password or any software that will find it, so i can change the cell contents. Thanks
Our Sites
Site Links
About 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 20:03.
Find Us