Maximizing Connectivity & Productivity

Excel – Copying a formula to another cell

Ever try copying a formula to another cell and then found that all the references change?

To copy a formula so that it does not change when moved to another cell:

Simply put an apostrophe before the formula that you want to copy, copy and paste into the cell that you want to use the formula in.  Then delete the apostrophe in both the original and copied to cell.

Leave a Reply

You must be logged in to post a comment.

Mississauga, ON, Canada 905.607.3500