An Excel sheet with the text D1 in cell A1, and a example of the INDIRECT function being used to turn that text into a reference. An Excel sheet with an example of the INDIRECT function embedded ...

Open a New Worksheet; Launch Excel and create a new worksheet named "June." Type "Sales" in cell A1 and "1000" in cell B1. Do not place parentheses around these values.