When you do so, Excel will jump back to where you started the formula and show you the results. Finish the Excel FormulaĪt this point, you can press enter to close out and complete your multi-sheet formula. Excel automatically writes part of the formula for you to reference a cell on another sheet.
Notice in the screenshot below that to reference a cell on another sheet, Excel adds "Sheet2!B3", which simply references cell B3 on a sheet named Sheet2. You could write this manually, but clicking on the cells makes Excel write it for you automatically. As you can see in the screenshot below, Excel automatically writes the part of the formula that references a cell on another sheet for you. Jump to different sheet in Excel.Īfter you switch sheets, click on the next cell that you want to include in the formula. It's very important that you don't close out the formula before you click on the next cell to include as part of the formula. While you still have the formula open, click on a different sheet tab at the bottom of Excel. Now, make sure that you don't close out your formula and press enter yet! You'll want to leave the formula open before you switch sheets. Start writing a formula in a cell and click on the first cell reference to include, but make sure not to close out the formula yet. Then, I'll type a + sign to add my second cell to this formula. I'll open up the = sign, and then click on the first cell on my current sheet to make it the first part of the formula.
0 kommentar(er)
