Do you want to reference another sheet in Excel? This can be done manually, but more advanced users can use a specialized formula.

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.

Microsoft Excel's VLookup formula permits you to search large spreadsheets for specific data, one of Excel's lookup and reference functions. You can use VLookup between sheets within an Excel ...

Absolute and relative references in Excel formulas are two ways to refer to cells in your spreadsheet. They both have their purpose, and sometimes you may find yourself using them interchangeably.

You probably will need the same formula in several cells in your spreadsheet. So understanding how referencing works is vital to making your experience in Excel a good one and creating a spreadsheet ...

Excel offers myriad options for referring to workbooks and sheets in your VBA code. See which methods make sense in which situations.

Finding a circular reference in Excel is essential when troubleshooting complex spreadsheets. Circular references occur when a formula refers back to its own cell, either directly or indirectly, which ...

Our visual guide helps you find the most popular commands on the Ribbon in Excel 2016 and 2019 for Windows, along with keyboard shortcuts for performing each action.