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

MOD is more versatile thank you might think.

In a Microsoft Excel spreadsheet, you may have formulas sitting in one cell that require the information within another cell in order to calculate. These relationships are called references. When a ...

Typing entire expressions from the keyboard is tedious. Instead, use these 9 shortcuts to enter and work with expressions more efficiently. Most of us spend a lot of time entering expressions–they’re ...

When you're configuring data in a Microsoft Excel worksheet, you may realize that the information you entered in rows makes better sense in columns or vice versa. For example, you're especially likely ...