How to Dolarize multiple cells at once

[cartica]

Hi-

I already have my formulas in excel. Is there a way to dollarize all the cells at once? Something other than either manual inputting them, or find and replace the cells?

Thanks

[popipipo]

Try to use the function key F4

[newdoverman]

If you are referring to currency, select the cells and right click, format cells, choose Currency, select the currency and click OK.

If you are wanting to make references absolute, click on a cell, highlight the formula in the formula bar and hit F4 until you have the references that you need.

[AlKey]

Highlight cells and click on Dollar sign in Home-General section of the ribbon.