1. Open the cell you want to edit<\/strong><\/strong><\/p>\n\n\n\n Tap the cell where you want to enter a formula to open the editing panel.<\/p>\n\n\n\n 2. Start entering a formula<\/strong><\/p>\n\n\n\n Enter\u00a0=\u00a0in the input field to switch to formula mode.<\/p>\n\n\n\n Example: Start with\u00a0=SUM(\u00a0or\u00a0=.<\/p>\n\n\n\n 3. Tap the cell you want to reference<\/strong><\/strong><\/p>\n\n\n\n Tap a cell on the sheet, and its cell name, such as\u00a0A1, will be automatically inserted into the input field.<\/p>\n\n\n\n 4. Continue entering operators or functions as needed<\/strong><\/strong><\/p>\n\n\n\n Complete the formula, for example:\u00a0=A1+B1\u00a0or\u00a0=SUM(A1:A10).<\/p>\n\n\n\n 5. Confirm the formula<\/strong><\/strong><\/p>\n\n\n\n When you close the editor or move to another cell, the formula is confirmed.\u00a0<\/p>\n\n\n\n \u2022 This feature works only while the input field is in formula editing mode.<\/p>\n\n\n\n \u2022 It helps reduce reference mistakes compared with manual typing, so it is especially useful for complex formulas.<\/p>\n\n\n\n \u2022 If the result is invalid,\u00a0Error\u00a0will be displayed.\u00a0<\/p>\n\n\n\n This page explains how to automatically insert cell references by tapping cells while entering a formula. How to Use 1. Open the cell you want to edit Tap the cell where you want to enter a formula to open the editing panel. 2. Start entering a formula Enter\u00a0=\u00a0in the input field to switch to formula […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_locale":"en_US","_original_post":"https:\/\/tablenote.webdia.net\/?page_id=325","footnotes":""},"class_list":["post-469","page","type-page","status-publish","hentry","en-US"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/tablenote.webdia.net\/wp-json\/wp\/v2\/pages\/469","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tablenote.webdia.net\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/tablenote.webdia.net\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/tablenote.webdia.net\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tablenote.webdia.net\/wp-json\/wp\/v2\/comments?post=469"}],"version-history":[{"count":0,"href":"https:\/\/tablenote.webdia.net\/wp-json\/wp\/v2\/pages\/469\/revisions"}],"wp:attachment":[{"href":"https:\/\/tablenote.webdia.net\/wp-json\/wp\/v2\/media?parent=469"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}![\"\"](\"https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/page-325-1-471x1024.png\"){kind=spacer}
<\/figure>\n\n\n\n![\"\"](\"https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/page-325-2-471x1024.png\"){kind=spacer}
<\/figure>\n\n\n\n![\"\"](\"https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/page-325-3-471x1024.png\"){kind=spacer}
<\/figure>\n\n\n\n![\"\"](\"https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/page-325-4-471x1024.png\"){kind=spacer}
<\/figure>\n\n\n\n![\"\"](\"https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/page325-5-471x1024.png\"){kind=spacer}
<\/figure>\n\n\n\n
\n\n\n\nNotes<\/strong><\/strong><\/h2>\n\n\n\n
![\"\"](\"https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/page-322-6-471x1024.png\"){kind=spacer}
<\/figure>\n","protected":false},"excerpt":{"rendered":"