{"id":9237,"date":"2019-04-23T18:19:15","date_gmt":"2019-04-23T18:19:15","guid":{"rendered":"https:\/\/www.auslogics.com\/en\/articles\/?p=9237"},"modified":"2025-04-04T13:30:38","modified_gmt":"2025-04-04T13:30:38","slug":"use-split-screen-function-in-microsoft-excel","status":"publish","type":"post","link":"https:\/\/www.auslogics.com\/en\/articles\/use-split-screen-function-in-microsoft-excel\/","title":{"rendered":"How to Use the Split Screen Function in Microsoft Excel?"},"content":{"rendered":"

If you are working on a large spreadsheet in Excel, it can be tedious to compare data from different sections.<\/p>\n

Is there anything you can do to streamline the process? Definitely, there is \u2013 you can use the split-screen function.<\/p>\n

What is the split-screen function?<\/h2>\n

The split-screen function on Excel enables you to view separate sections of a spreadsheet simultaneously. This way, you can quickly compare your data without scrolling back and forth.<\/p>\n

How to use the split screen function in Excel?<\/h2>\n

Excel gives you complete control. You can customize the way the screen is split so as to meet your specific needs.<\/p>\n

To access the feature, click on the View<\/b> tab and select Split<\/b> from the menu.<\/p>\n

To use it, there are several options available to you:<\/p>\n

    \n
  1. Split the screen into four equal quadrants.<\/li>\n
  2. Split the screen vertically or horizontally.<\/li>\n<\/ol>\n

    Option 1: Split the screen into four equal quadrants<\/h3>\n

    You can split your screen to create four copies of your current worksheet. All the four copies are set side by side so you can view them at the same time.<\/p>\n

    To achieve this, follow the simple process below:<\/p>\n

      \n
    1. Go to the A1 cell and select it.<\/li>\n
    2. Click on the View<\/b> tab and select the Split<\/b> option from the menu.<\/li>\n<\/ol>\n

      That\u2019s it. Your screen will be automatically split into four worksheets.<\/p>\n

      You can make adjustments by clicking and dragging the sides of any of the worksheets or the center section.<\/p>\n

      Option 2: Split the screen vertically or horizontally<\/h3>\n

      You can split the screen in half instead if you don\u2019t require four copies of your worksheet. Depending on your preference, you can create vertical or horizontal splits.<\/p>\n

      To create horizontal splits, here\u2019s what you have to do:<\/b><\/p>\n

        \n
      1. Go to the A column and select any cell except A1.<\/li>\n
      2. Click on the View tab and select the Split option from the menu.<\/li>\n<\/ol>\n

        The split will be automatically created above the row of the selected cell. For instance, if you selected the A5 cell, the split will be between row 4 and row 5.<\/p>\n

        Creating a horizontal split is as easy as this:<\/b><\/p>\n

          \n
        1. Go to row 1 and select a cell from any column except column A.<\/li>\n
        2. Click on the View tab and select the Split option from the menu.<\/li>\n<\/ol>\n

          Once you have selected any cell and clicked on the Split button, the spreadsheet will be split. But you need to remember that four quadrants will be created instead of two when you choose cell A1.<\/p>\n

          How to remove the split screens?<\/h2>\n

          When you are done using the function to compare sections of your spreadsheet, click on the View tab and select the Split option again to turn it off. You will have a single worksheet again.<\/p>\n

          Alternatively, you can disable the feature by dragging the split screen bars to the edge of the window.<\/p>\n

          There you have it. You\u2019ve discovered how to make your work easy by using the split-screen function on Microsoft Excel.<\/p>\n

          It\u2019s important to keep your PC running smoothly if you wish to complete your work without any hitch. Some users experience annoying system glitches and crashes while trying to get an important assignment done.<\/p>\n\n

          If you are facing such issues, use\u00a0Auslogics BoostSpeed<\/a> to perform a full system checkup. The tool is very user-friendly. You can schedule automatic scans to locate and eliminate junk files and any speed-reducing issues that may be causing your applications to hang. It also includes a privacy protection feature to safeguard all your sensitive personal information while you surf the web.<\/p>\n

          We hope you\u2019ve found this content useful.<\/p>\n

          We\u2019d love to hear your thoughts\u2026<\/p>\n

          Feel free to drop a comment in the section below.<\/p>\n","protected":false},"excerpt":{"rendered":"

          If you are working on a large spreadsheet in Excel, it can be tedious to compare data from different sections. Is there anything you can do to streamline the process? Definitely, there is \u2013 you can use the split-screen function. What is the split-screen function? The split-screen function on Excel enables you to view separate […]<\/p>\n","protected":false},"author":19,"featured_media":90461,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[869,819,867,817],"tags":[163,77,619],"class_list":["post-9237","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-files","category-how-tos","category-multimedia","category-productivity","tag-monitor-issues","tag-ms-office","tag-windows-tweaks"],"yoast_head":"\nHow to Use the Split Screen Function in Microsoft Excel? — Auslogics Blog<\/title>\n<meta name=\"description\" content=\"Is there anything you can do to streamline the process? Definitely, there is \u2013 you can use the split-screen function.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.auslogics.com\/en\/articles\/wp-json\/wp\/v2\/posts\/9237\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Use the Split Screen Function in Microsoft Excel?\" \/>\n<meta property=\"og:description\" content=\"Is there anything you can do to streamline the process? Definitely, there is \u2013 you can use the split-screen function.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.auslogics.com\/en\/articles\/use-split-screen-function-in-microsoft-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Auslogics Blog | Tips to Diagnose & Resolve Computer Issues\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/Auslogics\" \/>\n<meta property=\"article:published_time\" content=\"2019-04-23T18:19:15+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-04-04T13:30:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.auslogics.com\/en\/articles\/wp-content\/uploads\/2019\/04\/How-to-Use-the-Split-Screen-Function-in-Microsoft-Excel.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"715\" \/>\n\t<meta property=\"og:image:height\" content=\"408\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\n<meta name=\"author\" content=\"Tobenna Nnabeze\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Tobenna Nnabeze\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.auslogics.com\\\/en\\\/articles\\\/use-split-screen-function-in-microsoft-excel\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.auslogics.com\\\/en\\\/articles\\\/use-split-screen-function-in-microsoft-excel\\\/\"},\"author\":{\"name\":\"Tobenna Nnabeze\",\"@id\":\"https:\\\/\\\/www.auslogics.com\\\/en\\\/articles\\\/#\\\/schema\\\/person\\\/e593d898737950b7d661d65e8967fa11\"},\"headline\":\"How to Use the Split Screen Function in Microsoft Excel?\",\"datePublished\":\"2019-04-23T18:19:15+00:00\",\"dateModified\":\"2025-04-04T13:30:38+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.auslogics.com\\\/en\\\/articles\\\/use-split-screen-function-in-microsoft-excel\\\/\"},\"wordCount\":624,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.auslogics.com\\\/en\\\/articles\\\/use-split-screen-function-in-microsoft-excel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.auslogics.com\\\/en\\\/articles\\\/wp-content\\\/uploads\\\/2019\\\/04\\\/How-to-Use-the-Split-Screen-Function-in-Microsoft-Excel.webp\",\"keywords\":[\"Display Issues\",\"MS Office\",\"Windows Tweaks\"],\"articleSection\":[\"Files\",\"How To`s\",\"Multimedia\",\"Productivity\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.auslogics.com\\\/en\\\/articles\\\/use-split-screen-function-in-microsoft-excel\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.auslogics.com\\\/en\\\/articles\\\/use-split-screen-function-in-microsoft-excel\\\/\",\"url\":\"https:\\\/\\\/www.auslogics.com\\\/en\\\/articles\\\/use-split-screen-function-in-microsoft-excel\\\/\",\"name\":\"How to Use the Split Screen Function in Microsoft Excel? — Auslogics Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.auslogics.com\\\/en\\\/articles\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.auslogics.com\\\/en\\\/articles\\\/use-split-screen-function-in-microsoft-excel\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.auslogics.com\\\/en\\\/articles\\\/use-split-screen-function-in-microsoft-excel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.auslogics.com\\\/en\\\/articles\\\/wp-content\\\/uploads\\\/2019\\\/04\\\/How-to-Use-the-Split-Screen-Function-in-Microsoft-Excel.webp\",\"datePublished\":\"2019-04-23T18:19:15+00:00\",\"dateModified\":\"2025-04-04T13:30:38+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.auslogics.com\\\/en\\\/articles\\\/#\\\/schema\\\/person\\\/e593d898737950b7d661d65e8967fa11\"},\"description\":\"Is there anything you can do to streamline the process? Definitely, there is \u2013 you can use the split-screen function.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.auslogics.com\\\/en\\\/articles\\\/use-split-screen-function-in-microsoft-excel\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.auslogics.com\\\/en\\\/articles\\\/use-split-screen-function-in-microsoft-excel\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.auslogics.com\\\/en\\\/articles\\\/use-split-screen-function-in-microsoft-excel\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.auslogics.com\\\/en\\\/articles\\\/wp-content\\\/uploads\\\/2019\\\/04\\\/How-to-Use-the-Split-Screen-Function-in-Microsoft-Excel.webp\",\"contentUrl\":\"https:\\\/\\\/www.auslogics.com\\\/en\\\/articles\\\/wp-content\\\/uploads\\\/2019\\\/04\\\/How-to-Use-the-Split-Screen-Function-in-Microsoft-Excel.webp\",\"width\":715,\"height\":408,\"caption\":\"How to Use the Split Screen Function in Microsoft Excel?\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.auslogics.com\\\/en\\\/articles\\\/use-split-screen-function-in-microsoft-excel\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Tech Wisdom Blog\",\"item\":\"https:\\\/\\\/www.auslogics.com\\\/en\\\/articles\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To`s\",\"item\":\"https:\\\/\\\/www.auslogics.com\\\/en\\\/articles\\\/category\\\/how-tos\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"How to Use the Split Screen Function in Microsoft Excel?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.auslogics.com\\\/en\\\/articles\\\/#website\",\"url\":\"https:\\\/\\\/www.auslogics.com\\\/en\\\/articles\\\/\",\"name\":\"Auslogics Blog | Tips to Diagnose & Resolve Computer Issues\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.auslogics.com\\\/en\\\/articles\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.auslogics.com\\\/en\\\/articles\\\/#\\\/schema\\\/person\\\/e593d898737950b7d661d65e8967fa11\",\"name\":\"Tobenna Nnabeze\",\"description\":\"Meet Tobenna Nnabeze, an author on the Auslogics blog, exploring gaming, PC troubleshooting, and performance optimization. With a passion for gaming and a sharp eye for PC devices, Tobenna shares insights to enrich your PC experience. His expertise in troubleshooting equips readers with easy fixes and practical solutions. Explore his articles for an engaging journey into the gaming realm and maximizing PC efficiency on the Auslogics blog.\",\"url\":\"https:\\\/\\\/www.auslogics.com\\\/en\\\/articles\\\/author\\\/tobenna-nnabeze\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to Use the Split Screen Function in Microsoft Excel? — Auslogics Blog","description":"Is there anything you can do to streamline the process? Definitely, there is \u2013 you can use the split-screen function.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.auslogics.com\/en\/articles\/wp-json\/wp\/v2\/posts\/9237","og_locale":"en_US","og_type":"article","og_title":"How to Use the Split Screen Function in Microsoft Excel?","og_description":"Is there anything you can do to streamline the process? Definitely, there is \u2013 you can use the split-screen function.","og_url":"https:\/\/www.auslogics.com\/en\/articles\/use-split-screen-function-in-microsoft-excel\/","og_site_name":"Auslogics Blog | Tips to Diagnose & Resolve Computer Issues","article_publisher":"https:\/\/www.facebook.com\/Auslogics","article_published_time":"2019-04-23T18:19:15+00:00","article_modified_time":"2025-04-04T13:30:38+00:00","og_image":[{"width":715,"height":408,"url":"https:\/\/www.auslogics.com\/en\/articles\/wp-content\/uploads\/2019\/04\/How-to-Use-the-Split-Screen-Function-in-Microsoft-Excel.webp","type":"image\/webp"}],"author":"Tobenna Nnabeze","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Tobenna Nnabeze","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.auslogics.com\/en\/articles\/use-split-screen-function-in-microsoft-excel\/#article","isPartOf":{"@id":"https:\/\/www.auslogics.com\/en\/articles\/use-split-screen-function-in-microsoft-excel\/"},"author":{"name":"Tobenna Nnabeze","@id":"https:\/\/www.auslogics.com\/en\/articles\/#\/schema\/person\/e593d898737950b7d661d65e8967fa11"},"headline":"How to Use the Split Screen Function in Microsoft Excel?","datePublished":"2019-04-23T18:19:15+00:00","dateModified":"2025-04-04T13:30:38+00:00","mainEntityOfPage":{"@id":"https:\/\/www.auslogics.com\/en\/articles\/use-split-screen-function-in-microsoft-excel\/"},"wordCount":624,"commentCount":0,"image":{"@id":"https:\/\/www.auslogics.com\/en\/articles\/use-split-screen-function-in-microsoft-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.auslogics.com\/en\/articles\/wp-content\/uploads\/2019\/04\/How-to-Use-the-Split-Screen-Function-in-Microsoft-Excel.webp","keywords":["Display Issues","MS Office","Windows Tweaks"],"articleSection":["Files","How To`s","Multimedia","Productivity"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.auslogics.com\/en\/articles\/use-split-screen-function-in-microsoft-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.auslogics.com\/en\/articles\/use-split-screen-function-in-microsoft-excel\/","url":"https:\/\/www.auslogics.com\/en\/articles\/use-split-screen-function-in-microsoft-excel\/","name":"How to Use the Split Screen Function in Microsoft Excel? — Auslogics Blog","isPartOf":{"@id":"https:\/\/www.auslogics.com\/en\/articles\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.auslogics.com\/en\/articles\/use-split-screen-function-in-microsoft-excel\/#primaryimage"},"image":{"@id":"https:\/\/www.auslogics.com\/en\/articles\/use-split-screen-function-in-microsoft-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.auslogics.com\/en\/articles\/wp-content\/uploads\/2019\/04\/How-to-Use-the-Split-Screen-Function-in-Microsoft-Excel.webp","datePublished":"2019-04-23T18:19:15+00:00","dateModified":"2025-04-04T13:30:38+00:00","author":{"@id":"https:\/\/www.auslogics.com\/en\/articles\/#\/schema\/person\/e593d898737950b7d661d65e8967fa11"},"description":"Is there anything you can do to streamline the process? Definitely, there is \u2013 you can use the split-screen function.","breadcrumb":{"@id":"https:\/\/www.auslogics.com\/en\/articles\/use-split-screen-function-in-microsoft-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.auslogics.com\/en\/articles\/use-split-screen-function-in-microsoft-excel\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.auslogics.com\/en\/articles\/use-split-screen-function-in-microsoft-excel\/#primaryimage","url":"https:\/\/www.auslogics.com\/en\/articles\/wp-content\/uploads\/2019\/04\/How-to-Use-the-Split-Screen-Function-in-Microsoft-Excel.webp","contentUrl":"https:\/\/www.auslogics.com\/en\/articles\/wp-content\/uploads\/2019\/04\/How-to-Use-the-Split-Screen-Function-in-Microsoft-Excel.webp","width":715,"height":408,"caption":"How to Use the Split Screen Function in Microsoft Excel?"},{"@type":"BreadcrumbList","@id":"https:\/\/www.auslogics.com\/en\/articles\/use-split-screen-function-in-microsoft-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Tech Wisdom Blog","item":"https:\/\/www.auslogics.com\/en\/articles\/"},{"@type":"ListItem","position":2,"name":"How To`s","item":"https:\/\/www.auslogics.com\/en\/articles\/category\/how-tos\/"},{"@type":"ListItem","position":3,"name":"How to Use the Split Screen Function in Microsoft Excel?"}]},{"@type":"WebSite","@id":"https:\/\/www.auslogics.com\/en\/articles\/#website","url":"https:\/\/www.auslogics.com\/en\/articles\/","name":"Auslogics Blog | Tips to Diagnose & Resolve Computer Issues","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.auslogics.com\/en\/articles\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.auslogics.com\/en\/articles\/#\/schema\/person\/e593d898737950b7d661d65e8967fa11","name":"Tobenna Nnabeze","description":"Meet Tobenna Nnabeze, an author on the Auslogics blog, exploring gaming, PC troubleshooting, and performance optimization. With a passion for gaming and a sharp eye for PC devices, Tobenna shares insights to enrich your PC experience. His expertise in troubleshooting equips readers with easy fixes and practical solutions. Explore his articles for an engaging journey into the gaming realm and maximizing PC efficiency on the Auslogics blog.","url":"https:\/\/www.auslogics.com\/en\/articles\/author\/tobenna-nnabeze\/"}]}},"_links":{"self":[{"href":"https:\/\/www.auslogics.com\/en\/articles\/wp-json\/wp\/v2\/posts\/9237","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.auslogics.com\/en\/articles\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.auslogics.com\/en\/articles\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.auslogics.com\/en\/articles\/wp-json\/wp\/v2\/users\/19"}],"replies":[{"embeddable":true,"href":"https:\/\/www.auslogics.com\/en\/articles\/wp-json\/wp\/v2\/comments?post=9237"}],"version-history":[{"count":10,"href":"https:\/\/www.auslogics.com\/en\/articles\/wp-json\/wp\/v2\/posts\/9237\/revisions"}],"predecessor-version":[{"id":90463,"href":"https:\/\/www.auslogics.com\/en\/articles\/wp-json\/wp\/v2\/posts\/9237\/revisions\/90463"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.auslogics.com\/en\/articles\/wp-json\/wp\/v2\/media\/90461"}],"wp:attachment":[{"href":"https:\/\/www.auslogics.com\/en\/articles\/wp-json\/wp\/v2\/media?parent=9237"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.auslogics.com\/en\/articles\/wp-json\/wp\/v2\/categories?post=9237"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.auslogics.com\/en\/articles\/wp-json\/wp\/v2\/tags?post=9237"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}