Build more efficient spreadsheets by using the dollar sign to lock specific rows, columns, or permanent addresses when referencing cells.

Data validation in Microsoft Excel is a great way to limit what can be entered into a cell. However, creating rules using a formula allows you to enforce even more precise parameters—and there are ...

Another example: If you have cells named SubTotal and Tax, and type a formula =subtotal*tax Excel converts that to =SubTotal*Tax automatically. Because of this and because Excel puts functions in all ...