## A Sample of Practice Spreadsheet

First, let’s get introduced to our dataset. Here we have some products in Column B, their price in Column C, and their quantity in Column D. We have got the total price of the products in Column E by multiplying Column C and Column D. Here the quantity is identical for every product, which is 20. So when we multiply and then apply the Fill Handle tool Google Sheets automatically calculate the adjacent cells. But the values in the cells are empty.  So it gives us 0 in Column E. We can fix this problem by fixing Cell D5, which is called absolute cell referencing. We’ll do the process by 2 quick methods.

### 1. Following Manual Way

Steps:

• Firstly Double Click on Cell E5. It’ll show the formula.

• Then using the keyboard type the \$ sign in the formula.

• Next, hit Enter button to get the output.

• Subsequently, apply the Fill Handle tool to paste the formula into all cells.

• Finally, you will get the desired result.

### 2. Using F4 Key in Google Sheets

We can also use the shortcut F4 key to apply Dollar Sign to any formula in Google Sheets. This process is easier unlike the previous process.

Steps:

• First Double Click on Cell E5. It’ll show the formula.

• Second press the F4 key to insert the \$ sign in the formula. Apart from this, you can press the Fn+F4 keys together if pressing only the F4 key doesn’t work.

• Third press Enter to get the output.

• Furthermore, apply the Fill Handle tool to get results in all cells.

## How to Set Currency Format in Google Sheets

Some of us may want to set the currency format in Google Sheets. Undoubtedly the process is very easy. In this case, we’ll set the format in Dollar currency in Column E which is the total price of the products.

Steps:

• Select all the cells you want to format as currency. Here we select the cells from E5 to E9.
• You can simply do it by clicking the \$ sign above the formula bar.

• The results will be automatic.

• On the other hand, you can do this by going to the Format menu. Go to Format > Number > Currency to apply the currency format in the sheets.

• At this time you will get the output very quickly.

## How to Change Currency in Google Sheets

In the previous method, we learn about setting the currency and we get the output as Dollar. Whereas now we want to change the currency to another currency like the Euro. So let’s see how to do that.

Steps:

• Select the cells you want to change the currency.
• Then go to Format > Number > Custom Currency.

• Next, select Euro from the list and click Apply.

• Finally, you will get all the cells in Euro currency format.

## Things to Remember

• Sometimes pressing the F4 key wouldn’t change the Dollar Sign in the formula in Google Sheets. So we have to press the Fn+F4 keys together alternatively. That’ll solve the issue.