Open your spreadsheet in Microsoft Excel and locate the cells you wish to reference. Use the column letter, followed by the row number, for the reference. As an example, "A1" refers to column "A ...

Q: My partner says there’s an F4 shortcut to creating absolute cell references in Excel formulas, but for the life of me I can’t make it work. What am I doing wrong? A: Your partner is right, but ...

Microsoft Excel updates cell references when you copy an expression. Here are a couple of workarounds for those rare occasions when you don't want to change the cell references.

You can add text to a cell in Microsoft Excel the traditional way by simply typing, but there are other ways to get the job done. For example, you can use a formula, or even a function to ...