{"id":477,"date":"2026-04-08T18:21:43","date_gmt":"2026-04-08T09:21:43","guid":{"rendered":"https:\/\/tablenote.webdia.net\/?page_id=477"},"modified":"2026-04-08T18:21:43","modified_gmt":"2026-04-08T09:21:43","slug":"copy-and-paste-cell-ranges","status":"publish","type":"page","link":"https:\/\/tablenote.webdia.net\/en\/copy-and-paste-cell-ranges\/","title":{"rendered":"Copy and Paste Cell Ranges"},"content":{"rendered":"\n<p>This page explains how to copy a range of multiple cells and paste it into another location.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Copy a Range<\/h2>\n\n\n\n<p><strong>1. Start range selection mode<\/strong><\/p>\n\n\n\n<p>Open the top-right menu (\u2026), then select Range Operations \u2192 Copy Range.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"471\" height=\"1024\" src=\"https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/shared-image-open-right-menu-1-471x1024.png\" alt=\"\" class=\"wp-image-418\" style=\"width:300px\" srcset=\"https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/shared-image-open-right-menu-1-471x1024.png 471w, https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/shared-image-open-right-menu-1-138x300.png 138w, https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/shared-image-open-right-menu-1-768x1670.png 768w, https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/shared-image-open-right-menu-1-706x1536.png 706w, https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/shared-image-open-right-menu-1-942x2048.png 942w, https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/shared-image-open-right-menu-1-scaled.png 1177w\" sizes=\"auto, (max-width: 471px) 100vw, 471px\" \/><\/figure>\n\n\n\n<p><strong>2. Select the range you want to copy<\/strong><\/p>\n\n\n\n<p>Tap the starting cell, then tap the ending cell to specify the range.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"471\" height=\"1024\" src=\"https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/copypaste_2-471x1024.png\" alt=\"\" class=\"wp-image-447\" style=\"width:300px\" srcset=\"https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/copypaste_2-471x1024.png 471w, https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/copypaste_2-138x300.png 138w, https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/copypaste_2-768x1670.png 768w, https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/copypaste_2-706x1536.png 706w, https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/copypaste_2-942x2048.png 942w, https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/copypaste_2-scaled.png 1177w\" sizes=\"auto, (max-width: 471px) 100vw, 471px\" \/><\/figure>\n\n\n\n<p><strong>3. Copy the range<\/strong><\/p>\n\n\n\n<p>Tap Copy in the top-right corner to copy the selected range.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"471\" height=\"1024\" src=\"https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/copypaste_2-471x1024.png\" alt=\"\" class=\"wp-image-447\" style=\"width:300px\" srcset=\"https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/copypaste_2-471x1024.png 471w, https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/copypaste_2-138x300.png 138w, https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/copypaste_2-768x1670.png 768w, https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/copypaste_2-706x1536.png 706w, https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/copypaste_2-942x2048.png 942w, https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/copypaste_2-scaled.png 1177w\" sizes=\"auto, (max-width: 471px) 100vw, 471px\" \/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Paste to Another Location<\/h2>\n\n\n\n<p><strong>1. Select the top-left destination cell<\/strong><\/p>\n\n\n\n<p>Tap the top-left cell of the location where you want to place the copied range.<\/p>\n\n\n\n<p><strong>2. Paste from the cell menu<\/strong><\/p>\n\n\n\n<p>Open the cell menu (for example, by pressing and holding the cell), then select Paste Range.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"471\" height=\"1024\" src=\"https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/copypaste_3-471x1024.png\" alt=\"\" class=\"wp-image-448\" style=\"width:300px\" srcset=\"https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/copypaste_3-471x1024.png 471w, https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/copypaste_3-138x300.png 138w, https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/copypaste_3-768x1670.png 768w, https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/copypaste_3-706x1536.png 706w, https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/copypaste_3-942x2048.png 942w, https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/copypaste_3-scaled.png 1177w\" sizes=\"auto, (max-width: 471px) 100vw, 471px\" \/><\/figure>\n\n\n\n<p><strong>3. Pasting complete<\/strong><\/p>\n\n\n\n<p>The copied range will be pasted at the specified location in the same size as the original.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"471\" height=\"1024\" src=\"https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/copypaste_4-471x1024.png\" alt=\"\" class=\"wp-image-449\" style=\"width:300px\" srcset=\"https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/copypaste_4-471x1024.png 471w, https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/copypaste_4-138x300.png 138w, https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/copypaste_4-768x1670.png 768w, https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/copypaste_4-706x1536.png 706w, https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/copypaste_4-942x2048.png 942w, https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/copypaste_4-scaled.png 1177w\" sizes=\"auto, (max-width: 471px) 100vw, 471px\" \/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Notes<\/strong><\/h2>\n\n\n\n<p>\u2022 You cannot paste if the destination is outside the sheet range or overlaps merged cells.<\/p>\n\n\n\n<p>\u2022 If you paste cells that contain formulas, the references will be automatically adjusted to match the paste location.<\/p>\n\n\n\n<p>\u2022 If you make a mistake, you can use Undo to revert it.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This page explains how to copy a range of multiple cells and paste it into another location. Copy a Range 1. Start range selection mode Open the top-right menu (\u2026), then select Range Operations \u2192 Copy Range. 2. Select the range you want to copy Tap the starting cell, then tap the ending cell to [&hellip;]<\/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=312","footnotes":""},"class_list":["post-477","page","type-page","status-publish","hentry","en-US"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/tablenote.webdia.net\/wp-json\/wp\/v2\/pages\/477","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=477"}],"version-history":[{"count":0,"href":"https:\/\/tablenote.webdia.net\/wp-json\/wp\/v2\/pages\/477\/revisions"}],"wp:attachment":[{"href":"https:\/\/tablenote.webdia.net\/wp-json\/wp\/v2\/media?parent=477"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}