{"id":479,"date":"2026-04-09T02:24:47","date_gmt":"2026-04-08T17:24:47","guid":{"rendered":"https:\/\/tablenote.webdia.net\/?page_id=479"},"modified":"2026-04-09T02:24:47","modified_gmt":"2026-04-08T17:24:47","slug":"clear-contents-in-a-range","status":"publish","type":"page","link":"https:\/\/tablenote.webdia.net\/en\/clear-contents-in-a-range\/","title":{"rendered":"Clear Contents in a Range"},"content":{"rendered":"\n

This page explains how to delete the contents of a selected range all at once.<\/p>\n\n\n\n

\n\n\n\n

Steps to Clear a Range<\/h2>\n\n\n\n

1. Open the top-right menu<\/strong><\/p>\n\n\n\n

Tap the menu (\u2026) in the top-right corner of the sheet screen.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

2. Select Clear Range<\/strong><\/p>\n\n\n\n

Select Range Operations \u2192 Clear Range.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

3. Select the range to clear<\/strong><\/p>\n\n\n\n

Tap the starting cell, then tap the ending cell to select the range.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

4. Clear the range<\/strong><\/p>\n\n\n\n

Tap Clear in the top-right corner. When the confirmation dialog appears, select Clear.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
\n\n\n\n

State After Clearing<\/h2>\n\n\n\n
    \n
  • The contents of the cells in the selected range, including text, formulas, and images, will be deleted.<\/li>\n\n\n\n
  • If the selected range includes merged cells, those cells will also be unmerged.<\/li>\n<\/ul>\n\n\n\n
    \n\n\n\n

    Notes<\/h2>\n\n\n\n
      \n
    • This operation applies to the entire selected range. Please check the selected range before running it.<\/li>\n\n\n\n
    • If you delete something by mistake, you can use Undo to restore it.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"

      This page explains how to delete the contents of a selected range all at once. Steps to Clear a Range 1. Open the top-right menu Tap the menu (\u2026) in the top-right corner of the sheet screen. 2. Select Clear Range Select Range Operations \u2192 Clear Range. 3. Select the range to clear Tap the […]<\/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=314","footnotes":""},"class_list":["post-479","page","type-page","status-publish","hentry","en-US"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/tablenote.webdia.net\/wp-json\/wp\/v2\/pages\/479","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=479"}],"version-history":[{"count":0,"href":"https:\/\/tablenote.webdia.net\/wp-json\/wp\/v2\/pages\/479\/revisions"}],"wp:attachment":[{"href":"https:\/\/tablenote.webdia.net\/wp-json\/wp\/v2\/media?parent=479"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}