you can copy the currency rate and paste special selecting multiply.

"PH" wrote:

I have budget worksheets in HKD and I would like to convert them into USD to
work on. Is there a easy way to convert all the worksheets into USD instead
of using the formula in each columns?