How to Reference a Cell in Another Worksheet in Excel?

Learn the easy formula to reference cell A1 from another worksheet in Excel.

76 views

To reference cell A1 from another worksheet, use the formula `=SheetName!A1`. Replace `SheetName` with the actual name of your worksheet. For example, if your worksheet is named `Data`, you would write `=Data!A1` to pull the content from cell A1 in the `Data` worksheet.

FAQs & Answers

  1. What is the formula to reference a cell in another sheet? Use the formula `=SheetName!CellReference`, replacing `SheetName` with the name of your worksheet.
  2. How do I combine data from multiple worksheets in Excel? You can reference multiple worksheets using the formula `=Sheet1!A1 + Sheet2!A1` to combine data from specific cells.
  3. Can I reference a cell in another workbook? Yes, use a similar format: `='[WorkbookName.xlsx]SheetName'!A1`, ensuring the other workbook is open.
  4. What if my worksheet name has spaces? If your worksheet name has spaces, enclose it in single quotes: `='Sheet Name'!A1`.