{"id":2267,"date":"2024-03-05T10:30:00","date_gmt":"2024-03-05T10:30:00","guid":{"rendered":"https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/?p=2267"},"modified":"2025-12-01T09:47:08","modified_gmt":"2025-12-01T09:47:08","slug":"digitip-24-make-using-excel-easier-by-freezing-columns-and-rows-%f0%9f%93%8a","status":"publish","type":"post","link":"https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/2024\/03\/05\/digitip-24-make-using-excel-easier-by-freezing-columns-and-rows-%f0%9f%93%8a\/","title":{"rendered":"DigiTip 24: Make using Excel easier by freezing columns and rows \ud83d\udcca"},"content":{"rendered":"\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"241\" src=\"http:\/\/wordpress.aber.ac.uk\/digital-capabilities\/files\/2023\/08\/digitips-banner_61877145-2-1024x241.png\" alt=\"\" class=\"wp-image-1463\" srcset=\"https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/files\/2023\/08\/digitips-banner_61877145-2-1024x241.png 1024w, https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/files\/2023\/08\/digitips-banner_61877145-2-300x71.png 300w, https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/files\/2023\/08\/digitips-banner_61877145-2-768x181.png 768w, https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/files\/2023\/08\/digitips-banner_61877145-2-1536x362.png 1536w, https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/files\/2023\/08\/digitips-banner_61877145-2-2048x482.png 2048w, https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/files\/2023\/08\/digitips-banner_61877145-2-712x168.png 712w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<div style=\"height:8px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>Have you ever worked on a large Excel document where you\u2019ve scrolled down to find a figure, but then you\u2019ve had to scroll back up to the top again to remind yourself of what the headings was for that column?!<\/p>\n\n\n\n<p>There\u2019s an incredibly useful function in Excel that can help with this issue, which enables you to freeze single or multiple rows and columns. You can access this feature within Excel by clicking <strong>View <\/strong>&gt; <strong>Freeze<\/strong> <strong>Panes<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"285\" src=\"https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/files\/2023\/12\/Excel-Freeze-1024x285.png\" alt=\"\" class=\"wp-image-2268\" srcset=\"https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/files\/2023\/12\/Excel-Freeze-1024x285.png 1024w, https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/files\/2023\/12\/Excel-Freeze-300x84.png 300w, https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/files\/2023\/12\/Excel-Freeze-768x214.png 768w, https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/files\/2023\/12\/Excel-Freeze-712x198.png 712w, https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/files\/2023\/12\/Excel-Freeze.png 1146w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<div style=\"height:27px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\" \/>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Watch the video below to learn how to freeze columns and rows:<\/strong><\/h4>\n\n\n\n<figure class=\"wp-block-video\"><video height=\"1080\" style=\"aspect-ratio: 1920 \/ 1080;\" width=\"1920\" controls loop muted poster=\"http:\/\/wordpress.aber.ac.uk\/digital-capabilities\/files\/2023\/12\/TipDigi-24.png\" src=\"https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/files\/2023\/12\/Copy-of-TipDigi-24-_-DigiTip-24-Made-with-Clipchamp.mp4\"><\/video><\/figure>\n\n\n\n<div style=\"height:26px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-white-color has-text-color has-background\" style=\"background:linear-gradient(339deg,rgb(254,205,165) 0%,rgb(254,45,45) 17%,rgb(107,0,62) 37%,rgb(171,85,85) 91%);font-size:18px\">To follow our DigiTips,&nbsp;<a rel=\"noreferrer noopener\" href=\"https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/\" target=\"_blank\"><strong>subscribe to our Digital Skills Blog<\/strong><\/a>. Or alternatively, you can&nbsp;<a rel=\"noreferrer noopener\" href=\"https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/category\/digitips\/\" target=\"_blank\"><strong>bookmark this webpage<\/strong><\/a>, where a new DigiTip will be added each week!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Have you ever worked on a large Excel document where you\u2019ve scrolled down to find a figure, but then you\u2019ve had to scroll back up to the top again to remind yourself of what the headings was for that column?! There\u2019s an incredibly useful function in Excel that can help with this issue, which enables [&hellip;]<\/p>\n","protected":false},"author":15501,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[56,205,136,394,402],"tags":[215,464,194,329,462],"class_list":["post-2267","post","type-post","status-publish","format-standard","hentry","category-ict-proficiency-en","category-digitips","category-information-data-media-literacy-en","category-microsoft-excel-en","category-microsoft-support","tag-tipiaudigipa-digitipsau-en","tag-applications","tag-excel","tag-office365-en","tag-organisation"],"jetpack_featured_media_url":"","jetpack_likes_enabled":true,"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/wp-json\/wp\/v2\/posts\/2267","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/wp-json\/wp\/v2\/users\/15501"}],"replies":[{"embeddable":true,"href":"https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/wp-json\/wp\/v2\/comments?post=2267"}],"version-history":[{"count":13,"href":"https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/wp-json\/wp\/v2\/posts\/2267\/revisions"}],"predecessor-version":[{"id":2295,"href":"https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/wp-json\/wp\/v2\/posts\/2267\/revisions\/2295"}],"wp:attachment":[{"href":"https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/wp-json\/wp\/v2\/media?parent=2267"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/wp-json\/wp\/v2\/categories?post=2267"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/wp-json\/wp\/v2\/tags?post=2267"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}