--- title: "Larilyn’s Tip of the Week: Microsoft Excel – Freezing Panes" description: Hey everybody! Side bar. Any Lost fans out there? For some reason, when I said hey everybody, all I could hear in my head is Charlie singing “You all everybody!” If you’re not a Lost fan….sorry. We’ve established long before now what a nerd I am. Annnnyway…..time for this weeks tip, and we’re sticking with […] --- [Skip to content](https://www.inmotionnet.com/blog/2021/11/larilyns-tip-of-the-week-microsoft-excel-freezing-panes#main-content) [Contact us](https://www.inmotionnet.com/contact) ![](https://www.inmotionnet.com/hs-fs/hubfs/InMotionLogoNEW_RGB%20copy.png?width=600&height=350&name=InMotionLogoNEW_RGB%20copy.png) - [Home](https://www.inmotionnet.com/) - [Contact](https://www.inmotionnet.com/contact) - Client Tools Show submenu for Client Tools - [Client Portal](https://na.myconnectwise.net/v4_6_release/services/system_io/CustomerPortal/Portal.html?company=inmotionnets) - [Payment Portal](https://inmtn.connectboosterportal.com/) Open main navigation Close main navigation - [Home](https://www.inmotionnet.com/) - [Contact](https://www.inmotionnet.com/contact) - Client Tools Show submenu for Client Tools - [Client Portal](https://na.myconnectwise.net/v4_6_release/services/system_io/CustomerPortal/Portal.html?company=inmotionnets) - [Payment Portal](https://inmtn.connectboosterportal.com/) - [Contact us](https://www.inmotionnet.com/contact) Nov 10, 2021 8:30:00 PM # Larilyn’s Tip of the Week: Microsoft Excel – Freezing Panes [Larilyn Holt](https://www.inmotionnet.com/blog/author/larilyn-holt) Share: [facebook-f icon](http://www.facebook.com/share.php?u=https://www.inmotionnet.com/blog/2021/11/larilyns-tip-of-the-week-microsoft-excel-freezing-panes) [linkedin-in icon](http://www.linkedin.com/shareArticle?mini=true&url=https://www.inmotionnet.com/blog/2021/11/larilyns-tip-of-the-week-microsoft-excel-freezing-panes) [Twitter icon](https://twitter.com/intent/tweet?url=https://www.inmotionnet.com/blog/2021/11/larilyns-tip-of-the-week-microsoft-excel-freezing-panes) [pinterest-p icon](http://pinterest.com/pin/create/link/?url=https://www.inmotionnet.com/blog/2021/11/larilyns-tip-of-the-week-microsoft-excel-freezing-panes) [envelope icon](mailto:?body=https://www.inmotionnet.com/blog/2021/11/larilyns-tip-of-the-week-microsoft-excel-freezing-panes) Hey everybody! Side bar. Any Lost fans out there? For some reason, when I said hey everybody, all I could hear in my head is Charlie singing “You all everybody!” [![](https://www.inmotionnet.com/hs-fs/hubfs/Imported_Blog_Media/41076db96d2cf17c38bd5fb2e8435d26.gif?width=498&height=274&name=41076db96d2cf17c38bd5fb2e8435d26.gif)](https://www.inmotionnet.com/hubfs/Imported_Blog_Media/41076db96d2cf17c38bd5fb2e8435d26.gif) If you’re not a Lost fan….sorry. We’ve established long before now what a nerd I am. Annnnyway…..time for this weeks tip, and we’re sticking with Excel! Have you ever found yourself working in Excel with a lot of data? And at the top of the columns, there are nice, organized, pretty labels for every column…..but there is SO much data, that after working for a minute, you’ve scrolled down so far that you can’t see them anymore? There’s just too. Much. INFORMATION! [![](https://www.inmotionnet.com/hs-fs/hubfs/Imported_Blog_Media/AccIT-7537238368_a0bf8fa717-1.jpg?width=500&height=455&name=AccIT-7537238368_a0bf8fa717-1.jpg)](https://www.inmotionnet.com/hubfs/Imported_Blog_Media/AccIT-7537238368_a0bf8fa717-1.jpg) Now, I’m sure none of you are like me…..thinking that I can just figure it out. I can remember the columns. Or I can just scroll up every once in awhile to refresh them in my mind. And no, I’m not mixing them up. And yes, of course I’m putting things in their right column. [![](https://www.inmotionnet.com/hs-fs/hubfs/Imported_Blog_Media/c3df858109bf422dc99011118b7ec266.jpg?width=270&height=340&name=c3df858109bf422dc99011118b7ec266.jpg)](https://www.inmotionnet.com/hubfs/Imported_Blog_Media/c3df858109bf422dc99011118b7ec266.jpg) However, if any of you ARE like me – let me share with you a trick I learned years ago to avoid this exact scenario. Did you know you can freeze rows in Excel? [![](https://www.inmotionnet.com/hs-fs/hubfs/Imported_Blog_Media/elsa-frozen-today-main-190930-1024x538.jpg?width=1024&height=538&name=elsa-frozen-today-main-190930-1024x538.jpg)](https://www.inmotionnet.com/hubfs/Imported_Blog_Media/elsa-frozen-today-main-190930.jpg) Luckily, it has nothing to do with Arendelle, queens or ice and everything to do with freezing the rows in place! So you can freeze the top row of your spreadsheet and no matter how much you scroll down, it will stay the top row. Amazing. Ingenious. What will they think of next?? [![](https://www.inmotionnet.com/hs-fs/hubfs/Imported_Blog_Media/804020043451907001.jpg?width=1000&height=746&name=804020043451907001.jpg)](https://www.inmotionnet.com/hubfs/Imported_Blog_Media/804020043451907001.jpg) To accomplish this, just go to the View tab of Excel. Once there, you should see the Freeze Panes option which has a drop down menu. And there, you can select for it to freeze either the first row or the first column, where ever your organizational information is located. [![](https://www.inmotionnet.com/hs-fs/hubfs/Imported_Blog_Media/freeze-excel.jpg?width=918&height=217&name=freeze-excel.jpg)](https://www.inmotionnet.com/hubfs/Imported_Blog_Media/freeze-excel.jpg) Easy peasy lemon squeezy. Join me next time when I teach you….ummm….more about Excel. I haven’t thought that far in advance! [Uncategorized](https://www.inmotionnet.com/blog/tag/uncategorized), [Excel](https://www.inmotionnet.com/blog/tag/excel) ## Related posts [Uncategorized](https://www.inmotionnet.com/blog/tag/uncategorized) ## [Larilyn’s Tip of the Week: Scroll Wheel](https://www.inmotionnet.com/blog/2017/10/larilyns-tip-of-the-week-2) [Larilyn Holt](https://www.inmotionnet.com/blog/author/larilyn-holt) Oct 13, 2017 1:39:20 AM Have you guys met my friend, the scroll wheel of the mouse?? [Read more](https://www.inmotionnet.com/blog/2017/10/larilyns-tip-of-the-week-2) [Microsoft Teams](https://www.inmotionnet.com/blog/tag/microsoft-teams) ## [Larilyn’s Tip of the Week: Microsoft Teams – Immersive Reader](https://www.inmotionnet.com/blog/2021/06/larilyns-tip-of-the-week-microsoft-teams-immersive-reader) [Larilyn Holt](https://www.inmotionnet.com/blog/author/larilyn-holt) Jun 9, 2021 9:30:00 PM Have you ever made the mistake of admitting to not liking or having experienced something that is... [Read more](https://www.inmotionnet.com/blog/2021/06/larilyns-tip-of-the-week-microsoft-teams-immersive-reader) [Uncategorized](https://www.inmotionnet.com/blog/tag/uncategorized) ## [Larilyn’s Tip of the Week: Entire word backspace](https://www.inmotionnet.com/blog/2020/09/larilyns-tip-of-the-week-13) [Larilyn Holt](https://www.inmotionnet.com/blog/author/larilyn-holt) Sep 14, 2020 3:30:00 AM I was trying to figure out some big life altering tip for this week, but nothing I was finding... [Read more](https://www.inmotionnet.com/blog/2020/09/larilyns-tip-of-the-week-13) [![](https://www.inmotionnet.com/hs-fs/hubfs/InMotionLogoNEW_RGB%20copy.png?width=600&height=350&name=InMotionLogoNEW_RGB%20copy.png)](https://inmotionnet.com) 24930 Washington Ave Unit #157 Murrieta, CA  92564 (951) 894-8809 This is a search field with an auto-suggest feature attached. - There are no suggestions because the search field is empty. - [Home](https://www.inmotionnet.com) - [Blog](https://www.inmotionnet.com/blog) - [Contact](https://www.inmotionnet.com/contact) - Client Tools - [Client Portal](https://na.myconnectwise.net/v4_6_release/services/system_io/CustomerPortal/Portal.html?company=inmotionnets) - [Payment Portal](https://inmtn.connectboosterportal.com/) - [Privacy](https://www.inmotionnet.com/privacy-policy) - [Terms](https://www.inmotionnet.com/terms-of-service) --- [linkedin-in icon](https://www.linkedin.com/company/in-motion-networks-corporation/) [Twitter icon](https://twitter.com/InMotionNet/) [facebook-f icon](https://www.facebook.com/inmotionnet/) Copyright © 2026, In Motion Networks Corporation ```json { "@context" : "https://schema.org", "@type" : "BlogPosting", "author" : { "@type" : "Person", "name" : "Larilyn Holt", "url" : "https://www.inmotionnet.com/blog/author/larilyn-holt" }, "dateModified" : "2021-12-07T20:40:55.861Z", "datePublished" : "2021-11-11T04:30:00.000Z", "headline" : "Larilyn’s Tip of the Week: Microsoft Excel – Freezing Panes", "mainEntityOfPage" : { "@id" : "https://www.inmotionnet.com/blog/2021/11/larilyns-tip-of-the-week-microsoft-excel-freezing-panes", "@type" : "WebPage" }, "publisher" : { "@type" : "Organization", "logo" : { "@type" : "ImageObject", "url" : "https://www.inmotionnet.com/hubfs/InMotionLogoNEW_RGB%20copy.png" }, "name" : "In Motion Networks" } } ```