how can i add $ to formulas with a click of a button to ?

H

hgood

I want to create formulas in excel and i need the formulas to reference
certain cells multiple times. Is there a way to have the $ added to my
formulas without having to type it? Thanks.
 
K

KC Rippstein hotmail com>

You could use ctrl+H to find & replace the cell reference with the
mixed/absolute reference, or when you go into the formula to edit the
reference just hit your F4 key to toggle between absolute, mixed, and
relative referencing.
 

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

I need to add multiple cells then subtract them from one cell c4+c6+c7+c9+c10+c11 and subtract them 1
Excel Formula 1
Excel How to add numbers in same cell? 2
Excel Vlookup Help 0
Maintain Formatting with Formulas 1
Malfunction formulae 1
Copying formulas with relative references 2
Using text in a cell in a formula 2

Top