{"id":483,"date":"2026-04-09T02:58:44","date_gmt":"2026-04-08T17:58:44","guid":{"rendered":"https:\/\/tablenote.webdia.net\/?page_id=483"},"modified":"2026-04-09T02:58:44","modified_gmt":"2026-04-08T17:58:44","slug":"freeze-rows-and-columns","status":"publish","type":"page","link":"https:\/\/tablenote.webdia.net\/en\/freeze-rows-and-columns\/","title":{"rendered":"Freeze Rows and Columns to Keep Headers Visible"},"content":{"rendered":"\n<p>This page explains how to configure frozen rows and frozen columns.<\/p>\n\n\n\n<p>Even in a large sheet, you can scroll while keeping the headers visible at all times.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Open the Settings Screen<\/h2>\n\n\n\n<p><strong>1. Open the top-right menu<\/strong><\/p>\n\n\n\n<p>Tap the menu (\u2026) in the top-right corner of the sheet screen.<\/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. Open Sheet Settings<\/strong><\/p>\n\n\n\n<p>Select Sheet Settings.<\/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-sheetsetting-471x1024.png\" alt=\"\" class=\"wp-image-419\" style=\"width:300px\" srcset=\"https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/shared-image-open-sheetsetting-471x1024.png 471w, https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/shared-image-open-sheetsetting-138x300.png 138w, https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/shared-image-open-sheetsetting-768x1670.png 768w, https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/shared-image-open-sheetsetting-706x1536.png 706w, https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/shared-image-open-sheetsetting-942x2048.png 942w, https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/shared-image-open-sheetsetting-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\">Set Frozen Columns<\/h2>\n\n\n\n<p><strong>1. Select &#8220;Frozen Columns&#8221;<\/strong><\/p>\n\n\n\n<p>Tap Frozen Columns in the settings list.<\/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\/sheetsetting-freeze-row-471x1024.png\" alt=\"\" class=\"wp-image-430\" style=\"width:300px\" srcset=\"https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/sheetsetting-freeze-row-471x1024.png 471w, https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/sheetsetting-freeze-row-138x300.png 138w, https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/sheetsetting-freeze-row-768x1670.png 768w, https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/sheetsetting-freeze-row-706x1536.png 706w, https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/sheetsetting-freeze-row-942x2048.png 942w, https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/sheetsetting-freeze-row-scaled.png 1177w\" sizes=\"auto, (max-width: 471px) 100vw, 471px\" \/><\/figure>\n\n\n\n<p><strong>2. Enter the number of columns to freeze<\/strong><\/p>\n\n\n\n<p>Enter the number of columns you want to freeze (0 or more), then confirm.<\/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\/page-317-1-471x1024.png\" alt=\"\" class=\"wp-image-431\" style=\"width:300px\" srcset=\"https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/page-317-1-471x1024.png 471w, https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/page-317-1-138x300.png 138w, https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/page-317-1-768x1670.png 768w, https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/page-317-1-706x1536.png 706w, https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/page-317-1-942x2048.png 942w, https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/page-317-1-scaled.png 1177w\" sizes=\"auto, (max-width: 471px) 100vw, 471px\" \/><\/figure>\n\n\n\n<p><strong>3. Check the result<\/strong><\/p>\n\n\n\n<p>Even when you scroll horizontally, the specified number of columns will remain fixed on the left side.<\/p>\n\n\n\n<p>Example when Frozen Column is set to 2<\/p>\n\n\n\n<figure class=\"wp-block-video\"><video height=\"2622\" style=\"aspect-ratio: 1206 \/ 2622;\" width=\"1206\" controls src=\"https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/page-317-2.mp4\"><\/video><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Set Frozen Rows<\/h2>\n\n\n\n<p><strong>1. Select &#8220;Frozen Rows&#8221;<\/strong><\/p>\n\n\n\n<p>Tap Frozen Rows in the settings list.<\/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\/sheetsetting-freeze-column-471x1024.png\" alt=\"\" class=\"wp-image-433\" style=\"width:300px\" srcset=\"https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/sheetsetting-freeze-column-471x1024.png 471w, https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/sheetsetting-freeze-column-138x300.png 138w, https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/sheetsetting-freeze-column-768x1670.png 768w, https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/sheetsetting-freeze-column-706x1536.png 706w, https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/sheetsetting-freeze-column-942x2048.png 942w, https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/sheetsetting-freeze-column-scaled.png 1177w\" sizes=\"auto, (max-width: 471px) 100vw, 471px\" \/><\/figure>\n\n\n\n<p><strong>2. Enter the number of rows to freeze<\/strong><\/p>\n\n\n\n<p>Enter the number of rows you want to freeze (0 or more), then confirm.<\/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\/Simulator-Screenshot-iPhone-17-Pro-2026-04-07-at-04.18.26-471x1024.png\" alt=\"\" class=\"wp-image-434\" style=\"width:300px\" srcset=\"https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/Simulator-Screenshot-iPhone-17-Pro-2026-04-07-at-04.18.26-471x1024.png 471w, https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/Simulator-Screenshot-iPhone-17-Pro-2026-04-07-at-04.18.26-138x300.png 138w, https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/Simulator-Screenshot-iPhone-17-Pro-2026-04-07-at-04.18.26-768x1670.png 768w, https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/Simulator-Screenshot-iPhone-17-Pro-2026-04-07-at-04.18.26-706x1536.png 706w, https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/Simulator-Screenshot-iPhone-17-Pro-2026-04-07-at-04.18.26-942x2048.png 942w, https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/Simulator-Screenshot-iPhone-17-Pro-2026-04-07-at-04.18.26-scaled.png 1177w\" sizes=\"auto, (max-width: 471px) 100vw, 471px\" \/><\/figure>\n\n\n\n<p><strong>3.Check the result<\/strong><\/p>\n\n\n\n<p>Even when you scroll vertically, the specified number of rows will remain fixed at the top.<\/p>\n\n\n\n<p>Example when Frozen Rows is set to 2<\/p>\n\n\n\n<figure class=\"wp-block-video\"><video height=\"2622\" style=\"aspect-ratio: 1206 \/ 2622;\" width=\"1206\" controls src=\"https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/page-317-3.mp4\"><\/video><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Notes<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>If you set the value to 0, freezing will be disabled.<\/li>\n\n\n\n<li>If merged cells overlap the freeze boundary, the setting may not be available.<\/li>\n\n\n\n<li>You can use Undo to revert the setting change.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>This page explains how to configure frozen rows and frozen columns. Even in a large sheet, you can scroll while keeping the headers visible at all times. Open the Settings Screen 1. Open the top-right menu Tap the menu (\u2026) in the top-right corner of the sheet screen. 2. Open Sheet Settings Select Sheet Settings. [&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=317","footnotes":""},"class_list":["post-483","page","type-page","status-publish","hentry","en-US"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/tablenote.webdia.net\/wp-json\/wp\/v2\/pages\/483","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=483"}],"version-history":[{"count":0,"href":"https:\/\/tablenote.webdia.net\/wp-json\/wp\/v2\/pages\/483\/revisions"}],"wp:attachment":[{"href":"https:\/\/tablenote.webdia.net\/wp-json\/wp\/v2\/media?parent=483"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}