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.

To make your cell non-editable in Excel, you have to lock the cell and use a password to protect the information. Learn how!

Cell References in Excel Formulas When you create a formula in an Excel cell, you'll frequently include a reference to another cell in the spreadsheet.

To lock your cells in Microsoft Excel, you just need to head into the program's "Protection" tab. Locking a cell in Excel will make it so viewers can't change the data inside of that cell, which ...

Have you ever carefully crafted a formula in Excel, only to watch it unravel into chaos the moment you copy it across columns? It’s a maddening quirk of Excel tables—structured references that ...

Save this for the spreadsheet jocks in your office—we'd bet even the experts don't know all of these formula tips.

Q. I have an amortization schedule arranged vertically in Excel on Sheet 1 that I want to reference horizontally in my income statement on Sheet 2. Is there a way to write and copy/paste a single ...

Copying formulas in Excel is a relatively simple operation - unless you need to copy down through dozens or even hundreds of cells. Here's a foolproof little trick that will knock out the task for ...

Adding a text to a cell in Excel using Formula requires use of ampersand operator, CONCAT function, or the LEFT, RIGHT, and LEN functions.