MacMost Q&A Forum • View All Forum Questions • Ask a Question 8/30/101:31 pm Numbers Formulas Across Sheets How to i point from one sheet to another with formulas? — Wilma Comments: One Response to “Numbers Formulas Across Sheets” Gary Rosenzweig 10 years ago It can be done easily with mouse clicks. For instance, in sheet 1, select a cell and start a formula by typing =. Then, click on sheet 2 in the left sidebar. Then, click on the cell in that second sheet that you want to add to the formula. This adds that cell to the formula, even though it is on a different sheet. Related Video Tutorials: Linking Cells Across Numbers Tables and Sheets ― Using Wildcards In Numbers Formulas ― Creating Dynamic Pop-Up Menus In Numbers With AppleScript Comments Closed.