Excel Gurus!!!!!

[IronFar]

Let's say a cell has the formula =(F8 - F7).

How do I make such a field absolute? I want to copy the cells onto another sheet but can't carry the formula over. It'll screw up.

Thanks

 

[spidey07]

paste special

 

[Zanix]

use $

Edit: in front of both letter and number in the refrence. Total absolute to the max extreme!!

Edit2: Fatjohnny clears it up, but I said it first.

 

[fatjohnny]

Put a $ before anything you wanna kep absolute:

=($F8 - $F7) keeps the F absolute

=($F$8 - $F$7) keeps both the F's and the numbers absolute.

You can figure it out from there.
FJ

 

[ActuaryTm]

To add, use F4 within the cell edit to toggle between the various absolute reference modes (full, row, column).

 

[LordSnailz]

Do you want to copy the values from the formula or the formula from another sheet? If it's the former, use paste special, values.

 

[spidey07]

I also use sheet references often...

=Sheet1!A1

meaning, take the foruma from sheet1, A1. That way you can have tons of sheets and keep all your input/things that are manully changed/entered constant

 

[ActuaryTm]

Originally posted by: spidey07
I also use sheet references often...

=Sheet1!A1

meaning, take the foruma from sheet1, A1. That way you can have tons of sheets and keep all your input/things that are manully changed/entered constant

Actually, the above references the value rather than the formula itself.

 

[spidey07]

Originally posted by: ActuaryTm

Originally posted by: spidey07
I also use sheet references often...

=Sheet1!A1

meaning, take the foruma from sheet1, A1. That way you can have tons of sheets and keep all your input/things that are manully changed/entered constant

Actually, the above references the value rather than the formula itself.

oh well, I svck at teh excel.

 

[IronFar]

Thanks a bunch!!!


Two more questions:

1. What is the keyboard command for "Insert"?
2. Is there a keyboard command for Paste-special Values?

 

[ActuaryTm]

Originally posted by: IronFar
1. What is the keyboard command for "Insert"?
2. Is there a keyboard command for Paste-special Values?

1. Insert in what manner? Have to be a bit more specific.
2. No, unfortunately. Can however add a "Paste Values" button to the toolbar. Right-click toolbar area, select "Customize". Commands tab. "Edit" in Catagories list box. Should appear as this. Then simply drag the button onto the toolbar, where desired.