Excel is amazing software allows you to function any way you want to do, here i will demonstrate you to use single cell value to multiply/add/subtract to all other cell values, like if you want to multiply the single exchange rate to all of your worksheet for example; the exchange rate is PKR 100 for $1 and you want to check the amount in local currency like PKR currency so you have to multiply the PKR100 to each cell amount of the sheet so you don't need to be worried use the following method to solve this issue.
write exchange rate in one cell
now enter the formula for multiply but enter the this $ sign before and after the row name like below.
now drag down your formula to all cells it will pick the value only from one cell E1 of exchange rate.
Let me know if you have any question.
