This behaviour is very useful and is what allows a sum to be copied across or down the page and automatically refer to the new column or row that it finds itself in.But in some situations, you want some or all of the references to remain fixed when they are copied elsewhere.Using the dollar sign to do this, it becomes "=$A2*B

This behaviour is very useful and is what allows a sum to be copied across or down the page and automatically refer to the new column or row that it finds itself in.But in some situations, you want some or all of the references to remain fixed when they are copied elsewhere.Using the dollar sign to do this, it becomes "=$A2*B$1".This can then be copied to every cell in the white area.Once you make sure that it runs fine then you can buy it.The Premium Version of the Lease Calculator looks and feels exactly the same as the Free Version, just allows you to maintain more leases (or loans) Using this calculator is pretty easy.In our example if we replace the formula in cell B2 with "=A2*$E$1", then both the "E" and the "1" will remain fixed when the formula is copied. in cell B3, the formula will read "=A3*$E$1", still referring to the cell with the exchange rate in it.In this example we have fixed both the row and the column, but in other situations, you may just want to fix one or the other, for example: Above we have a spreadsheet calculating the times tables where we want to every cell in the white area to be the product of its row and column heading. In cell B2, the formula without dollars would be "=A2*B1", but for this formula to work when copied to each column, we need it to always look at column A for the first reference and to work for each row, we need to always look at row 1 for the second.

||This behaviour is very useful and is what allows a sum to be copied across or down the page and automatically refer to the new column or row that it finds itself in.

But in some situations, you want some or all of the references to remain fixed when they are copied elsewhere.

Using the dollar sign to do this, it becomes "=$A2*B$1".

This can then be copied to every cell in the white area.

Once you make sure that it runs fine then you can buy it.

The Premium Version of the Lease Calculator looks and feels exactly the same as the Free Version, just allows you to maintain more leases (or loans) Using this calculator is pretty easy.

In our example if we replace the formula in cell B2 with "=A2*$E$1", then both the "E" and the "1" will remain fixed when the formula is copied. in cell B3, the formula will read "=A3*$E$1", still referring to the cell with the exchange rate in it.

".This can then be copied to every cell in the white area.Once you make sure that it runs fine then you can buy it.The Premium Version of the Lease Calculator looks and feels exactly the same as the Free Version, just allows you to maintain more leases (or loans) Using this calculator is pretty easy.In our example if we replace the formula in cell B2 with "=A2*$EThis behaviour is very useful and is what allows a sum to be copied across or down the page and automatically refer to the new column or row that it finds itself in.But in some situations, you want some or all of the references to remain fixed when they are copied elsewhere.Using the dollar sign to do this, it becomes "=$A2*B$1".This can then be copied to every cell in the white area.Once you make sure that it runs fine then you can buy it.The Premium Version of the Lease Calculator looks and feels exactly the same as the Free Version, just allows you to maintain more leases (or loans) Using this calculator is pretty easy.In our example if we replace the formula in cell B2 with "=A2*$E$1", then both the "E" and the "1" will remain fixed when the formula is copied. in cell B3, the formula will read "=A3*$E$1", still referring to the cell with the exchange rate in it.In this example we have fixed both the row and the column, but in other situations, you may just want to fix one or the other, for example: Above we have a spreadsheet calculating the times tables where we want to every cell in the white area to be the product of its row and column heading. In cell B2, the formula without dollars would be "=A2*B1", but for this formula to work when copied to each column, we need it to always look at column A for the first reference and to work for each row, we need to always look at row 1 for the second.

||This behaviour is very useful and is what allows a sum to be copied across or down the page and automatically refer to the new column or row that it finds itself in.

But in some situations, you want some or all of the references to remain fixed when they are copied elsewhere.

Using the dollar sign to do this, it becomes "=$A2*B$1".

This can then be copied to every cell in the white area.

Once you make sure that it runs fine then you can buy it.

The Premium Version of the Lease Calculator looks and feels exactly the same as the Free Version, just allows you to maintain more leases (or loans) Using this calculator is pretty easy.

In our example if we replace the formula in cell B2 with "=A2*$E$1", then both the "E" and the "1" will remain fixed when the formula is copied. in cell B3, the formula will read "=A3*$E$1", still referring to the cell with the exchange rate in it.

", then both the "E" and the "1" will remain fixed when the formula is copied. in cell B3, the formula will read "=A3*$EThis behaviour is very useful and is what allows a sum to be copied across or down the page and automatically refer to the new column or row that it finds itself in.But in some situations, you want some or all of the references to remain fixed when they are copied elsewhere.Using the dollar sign to do this, it becomes "=$A2*B$1".This can then be copied to every cell in the white area.Once you make sure that it runs fine then you can buy it.The Premium Version of the Lease Calculator looks and feels exactly the same as the Free Version, just allows you to maintain more leases (or loans) Using this calculator is pretty easy.In our example if we replace the formula in cell B2 with "=A2*$E$1", then both the "E" and the "1" will remain fixed when the formula is copied. in cell B3, the formula will read "=A3*$E$1", still referring to the cell with the exchange rate in it.In this example we have fixed both the row and the column, but in other situations, you may just want to fix one or the other, for example: Above we have a spreadsheet calculating the times tables where we want to every cell in the white area to be the product of its row and column heading. In cell B2, the formula without dollars would be "=A2*B1", but for this formula to work when copied to each column, we need it to always look at column A for the first reference and to work for each row, we need to always look at row 1 for the second.

||This behaviour is very useful and is what allows a sum to be copied across or down the page and automatically refer to the new column or row that it finds itself in.

But in some situations, you want some or all of the references to remain fixed when they are copied elsewhere.

Using the dollar sign to do this, it becomes "=$A2*B$1".

This can then be copied to every cell in the white area.

Once you make sure that it runs fine then you can buy it.

The Premium Version of the Lease Calculator looks and feels exactly the same as the Free Version, just allows you to maintain more leases (or loans) Using this calculator is pretty easy.

In our example if we replace the formula in cell B2 with "=A2*$E$1", then both the "E" and the "1" will remain fixed when the formula is copied. in cell B3, the formula will read "=A3*$E$1", still referring to the cell with the exchange rate in it.

", still referring to the cell with the exchange rate in it.In this example we have fixed both the row and the column, but in other situations, you may just want to fix one or the other, for example: Above we have a spreadsheet calculating the times tables where we want to every cell in the white area to be the product of its row and column heading. In cell B2, the formula without dollars would be "=A2*B1", but for this formula to work when copied to each column, we need it to always look at column A for the first reference and to work for each row, we need to always look at row 1 for the second.The simple formula for cell B2, would be "=A2*E1", however if you copy this down, then the formula in cell B3, would read "=A3*E2" as both references would move down a row as described above. The dollar sign allows you to fix either the row, the column or both on any cell reference, by preceding the column or row with the dollar sign.I want to cover something today that I use all of the time but seems to be understood in varying degrees by clients I work with.I am talking about use of the dollar sign ($) in an Excel formula.If you are an Accountant for a small or medium sized company with multiple leases (or loans) then you probably experience problems with generating accounting entries every month.What you need to work out are the principal and interest amounts for each lease and then summarize them.