This formula shows how to reference the cell in another worksheet using a formula. Begin the formula with an equal sign, and follow it with the name of the worksheet you wish to reference.

Mary Ann Richardson explains that when concatenating date and text cell data in an Excel formula, you need to convert date cells to text to avoid unexpected results.

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 ...