{"id":3600,"date":"2014-07-08T22:34:01","date_gmt":"2014-07-08T22:34:01","guid":{"rendered":"http:\/\/affirmativeaction.com\/news\/?p=3600"},"modified":"2020-08-09T09:41:16","modified_gmt":"2020-08-09T16:41:16","slug":"excel-tutorial-freeze-panes","status":"publish","type":"post","link":"https:\/\/biddle.com\/blog\/2014\/07\/08\/excel-tutorial-freeze-panes\/","title":{"rendered":"Excel Tutorial: Freeze Panes"},"content":{"rendered":"<p><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-full wp-image-3605\" src=\"\/blog\/wp-content\/uploads\/2014\/07\/excel.png\" alt=\"Excel Tips and Tutorials\" width=\"128\" height=\"128\">This is the second in a series of Excel tutorials. These tutorials share tips on how to use Excel to better prepare your data for use in an Affirmative Action Plan.<\/p>\n<p>Last month, we&nbsp;showed you how to&nbsp;<a title=\"Excel Tutorial: Removing Blank Spaces\" href=\"\/news\/excel-tutorial-removing-blank-spaces\/\">remove blank spaces from your Excel data<\/a>. Today&#8217;s&nbsp;video demonstrates how to use Excel&#8217;s &#8220;Freeze Panes&#8221; option so that you can more easily scan your AAP data.<\/p>\n<p><!--more--><\/p>\n<p><iframe loading=\"lazy\" src=\"\/\/www.youtube.com\/embed\/BB38K2eW6ws?rel=0\" width=\"640\" height=\"480\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n","protected":false},"excerpt":{"rendered":"<p>This is the second in a series of Excel tutorials. These tutorials share tips on how to use Excel to better prepare your data for use in an Affirmative Action Plan. Last month, we&nbsp;showed you how to&nbsp;remove blank spaces from your Excel data. Today&#8217;s&nbsp;video demonstrates how to use Excel&#8217;s &#8220;Freeze Panes&#8221; option so that you [&hellip;]<\/p>\n","protected":false},"author":101026,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_genesis_hide_title":false,"_genesis_hide_breadcrumbs":false,"_genesis_hide_singular_image":false,"_genesis_hide_footer_widgets":false,"_genesis_custom_body_class":"","_genesis_custom_post_class":"","_genesis_layout":"","footnotes":""},"categories":[11],"tags":[184,55],"class_list":{"0":"post-3600","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-training","7":"tag-data-preparation","8":"tag-excel","9":"entry"},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Excel Tutorial: Freeze Panes &#187; Biddle Consulting Group News<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/biddle.com\/blog\/2014\/07\/08\/excel-tutorial-freeze-panes\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel Tutorial: Freeze Panes &#187; Biddle Consulting Group News\" \/>\n<meta property=\"og:description\" content=\"This is the second in a series of Excel tutorials. These tutorials share tips on how to use Excel to better prepare your data for use in an Affirmative Action Plan. Last month, we&nbsp;showed you how to&nbsp;remove blank spaces from your Excel data. Today&#8217;s&nbsp;video demonstrates how to use Excel&#8217;s &#8220;Freeze Panes&#8221; option so that you [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/biddle.com\/blog\/2014\/07\/08\/excel-tutorial-freeze-panes\/\" \/>\n<meta property=\"og:site_name\" content=\"Biddle Consulting Group News\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/pages\/Biddle-Consulting-Group-Inc\/283128085965\" \/>\n<meta property=\"article:published_time\" content=\"2014-07-08T22:34:01+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-08-09T16:41:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/biddle.com\/blog\/wp-content\/uploads\/2014\/07\/excel.png\" \/>\n<meta name=\"author\" content=\"Jeff Davies, M.A.\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@BiddleCG\" \/>\n<meta name=\"twitter:site\" content=\"@BiddleCG\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jeff Davies, M.A.\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/biddle.com\\\/blog\\\/2014\\\/07\\\/08\\\/excel-tutorial-freeze-panes\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/biddle.com\\\/blog\\\/2014\\\/07\\\/08\\\/excel-tutorial-freeze-panes\\\/\"},\"author\":{\"name\":\"Jeff Davies, M.A.\",\"@id\":\"https:\\\/\\\/biddle.com\\\/blog\\\/#\\\/schema\\\/person\\\/e60b7ef3c24a54fa39bd0f3a8f0342e7\"},\"headline\":\"Excel Tutorial: Freeze Panes\",\"datePublished\":\"2014-07-08T22:34:01+00:00\",\"dateModified\":\"2020-08-09T16:41:16+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/biddle.com\\\/blog\\\/2014\\\/07\\\/08\\\/excel-tutorial-freeze-panes\\\/\"},\"wordCount\":72,\"publisher\":{\"@id\":\"https:\\\/\\\/biddle.com\\\/blog\\\/#organization\"},\"keywords\":[\"data preparation\",\"excel\"],\"articleSection\":[\"Training\"],\"inLanguage\":\"en\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/biddle.com\\\/blog\\\/2014\\\/07\\\/08\\\/excel-tutorial-freeze-panes\\\/\",\"url\":\"https:\\\/\\\/biddle.com\\\/blog\\\/2014\\\/07\\\/08\\\/excel-tutorial-freeze-panes\\\/\",\"name\":\"Excel Tutorial: Freeze Panes &#187; Biddle Consulting Group News\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/biddle.com\\\/blog\\\/#website\"},\"datePublished\":\"2014-07-08T22:34:01+00:00\",\"dateModified\":\"2020-08-09T16:41:16+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/biddle.com\\\/blog\\\/2014\\\/07\\\/08\\\/excel-tutorial-freeze-panes\\\/#breadcrumb\"},\"inLanguage\":\"en\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/biddle.com\\\/blog\\\/2014\\\/07\\\/08\\\/excel-tutorial-freeze-panes\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/biddle.com\\\/blog\\\/2014\\\/07\\\/08\\\/excel-tutorial-freeze-panes\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/biddle.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel Tutorial: Freeze Panes\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/biddle.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/biddle.com\\\/blog\\\/\",\"name\":\"Biddle Consulting Group News\",\"description\":\"EEO, Affirmative Action, Pay Equity &amp; Employee Testing Solutions\",\"publisher\":{\"@id\":\"https:\\\/\\\/biddle.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/biddle.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/biddle.com\\\/blog\\\/#organization\",\"name\":\"Biddle Consulting Group, Inc.\",\"url\":\"https:\\\/\\\/biddle.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en\",\"@id\":\"https:\\\/\\\/biddle.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/biddle.com\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/09\\\/logo-biddle.png\",\"contentUrl\":\"https:\\\/\\\/biddle.com\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/09\\\/logo-biddle.png\",\"width\":154,\"height\":48,\"caption\":\"Biddle Consulting Group, Inc.\"},\"image\":{\"@id\":\"https:\\\/\\\/biddle.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/pages\\\/Biddle-Consulting-Group-Inc\\\/283128085965\",\"https:\\\/\\\/x.com\\\/BiddleCG\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/biddle-consulting-group\",\"https:\\\/\\\/www.youtube.com\\\/user\\\/biddletube01\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/biddle.com\\\/blog\\\/#\\\/schema\\\/person\\\/e60b7ef3c24a54fa39bd0f3a8f0342e7\",\"name\":\"Jeff Davies, M.A.\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/cbbe5d37acc3e7cfc9291cbf01ccf6b17836bc3c7407e9cc4c1e3212dc20f7dc?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/cbbe5d37acc3e7cfc9291cbf01ccf6b17836bc3c7407e9cc4c1e3212dc20f7dc?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/cbbe5d37acc3e7cfc9291cbf01ccf6b17836bc3c7407e9cc4c1e3212dc20f7dc?s=96&d=mm&r=g\",\"caption\":\"Jeff Davies, M.A.\"},\"description\":\"Jeff Davies is an EEO\\\/AA Consultant at Biddle Consulting Group. He assists federal contractors in developing and maintaining compliant Affirmative Action Plans and navigating OFCCP audits. Jeff also manages all AAP software clients at Biddle and routinely presents on various industry topics.\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel Tutorial: Freeze Panes &#187; Biddle Consulting Group News","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:\/\/biddle.com\/blog\/2014\/07\/08\/excel-tutorial-freeze-panes\/","og_locale":"en_US","og_type":"article","og_title":"Excel Tutorial: Freeze Panes &#187; Biddle Consulting Group News","og_description":"This is the second in a series of Excel tutorials. These tutorials share tips on how to use Excel to better prepare your data for use in an Affirmative Action Plan. Last month, we&nbsp;showed you how to&nbsp;remove blank spaces from your Excel data. Today&#8217;s&nbsp;video demonstrates how to use Excel&#8217;s &#8220;Freeze Panes&#8221; option so that you [&hellip;]","og_url":"https:\/\/biddle.com\/blog\/2014\/07\/08\/excel-tutorial-freeze-panes\/","og_site_name":"Biddle Consulting Group News","article_publisher":"https:\/\/www.facebook.com\/pages\/Biddle-Consulting-Group-Inc\/283128085965","article_published_time":"2014-07-08T22:34:01+00:00","article_modified_time":"2020-08-09T16:41:16+00:00","og_image":[{"url":"https:\/\/biddle.com\/blog\/wp-content\/uploads\/2014\/07\/excel.png","type":"","width":"","height":""}],"author":"Jeff Davies, M.A.","twitter_card":"summary_large_image","twitter_creator":"@BiddleCG","twitter_site":"@BiddleCG","twitter_misc":{"Written by":"Jeff Davies, M.A."},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/biddle.com\/blog\/2014\/07\/08\/excel-tutorial-freeze-panes\/#article","isPartOf":{"@id":"https:\/\/biddle.com\/blog\/2014\/07\/08\/excel-tutorial-freeze-panes\/"},"author":{"name":"Jeff Davies, M.A.","@id":"https:\/\/biddle.com\/blog\/#\/schema\/person\/e60b7ef3c24a54fa39bd0f3a8f0342e7"},"headline":"Excel Tutorial: Freeze Panes","datePublished":"2014-07-08T22:34:01+00:00","dateModified":"2020-08-09T16:41:16+00:00","mainEntityOfPage":{"@id":"https:\/\/biddle.com\/blog\/2014\/07\/08\/excel-tutorial-freeze-panes\/"},"wordCount":72,"publisher":{"@id":"https:\/\/biddle.com\/blog\/#organization"},"keywords":["data preparation","excel"],"articleSection":["Training"],"inLanguage":"en"},{"@type":"WebPage","@id":"https:\/\/biddle.com\/blog\/2014\/07\/08\/excel-tutorial-freeze-panes\/","url":"https:\/\/biddle.com\/blog\/2014\/07\/08\/excel-tutorial-freeze-panes\/","name":"Excel Tutorial: Freeze Panes &#187; Biddle Consulting Group News","isPartOf":{"@id":"https:\/\/biddle.com\/blog\/#website"},"datePublished":"2014-07-08T22:34:01+00:00","dateModified":"2020-08-09T16:41:16+00:00","breadcrumb":{"@id":"https:\/\/biddle.com\/blog\/2014\/07\/08\/excel-tutorial-freeze-panes\/#breadcrumb"},"inLanguage":"en","potentialAction":[{"@type":"ReadAction","target":["https:\/\/biddle.com\/blog\/2014\/07\/08\/excel-tutorial-freeze-panes\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/biddle.com\/blog\/2014\/07\/08\/excel-tutorial-freeze-panes\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/biddle.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Excel Tutorial: Freeze Panes"}]},{"@type":"WebSite","@id":"https:\/\/biddle.com\/blog\/#website","url":"https:\/\/biddle.com\/blog\/","name":"Biddle Consulting Group News","description":"EEO, Affirmative Action, Pay Equity &amp; Employee Testing Solutions","publisher":{"@id":"https:\/\/biddle.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/biddle.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en"},{"@type":"Organization","@id":"https:\/\/biddle.com\/blog\/#organization","name":"Biddle Consulting Group, Inc.","url":"https:\/\/biddle.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en","@id":"https:\/\/biddle.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/biddle.com\/blog\/wp-content\/uploads\/2017\/09\/logo-biddle.png","contentUrl":"https:\/\/biddle.com\/blog\/wp-content\/uploads\/2017\/09\/logo-biddle.png","width":154,"height":48,"caption":"Biddle Consulting Group, Inc."},"image":{"@id":"https:\/\/biddle.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/pages\/Biddle-Consulting-Group-Inc\/283128085965","https:\/\/x.com\/BiddleCG","https:\/\/www.linkedin.com\/company\/biddle-consulting-group","https:\/\/www.youtube.com\/user\/biddletube01"]},{"@type":"Person","@id":"https:\/\/biddle.com\/blog\/#\/schema\/person\/e60b7ef3c24a54fa39bd0f3a8f0342e7","name":"Jeff Davies, M.A.","image":{"@type":"ImageObject","inLanguage":"en","@id":"https:\/\/secure.gravatar.com\/avatar\/cbbe5d37acc3e7cfc9291cbf01ccf6b17836bc3c7407e9cc4c1e3212dc20f7dc?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/cbbe5d37acc3e7cfc9291cbf01ccf6b17836bc3c7407e9cc4c1e3212dc20f7dc?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/cbbe5d37acc3e7cfc9291cbf01ccf6b17836bc3c7407e9cc4c1e3212dc20f7dc?s=96&d=mm&r=g","caption":"Jeff Davies, M.A."},"description":"Jeff Davies is an EEO\/AA Consultant at Biddle Consulting Group. He assists federal contractors in developing and maintaining compliant Affirmative Action Plans and navigating OFCCP audits. Jeff also manages all AAP software clients at Biddle and routinely presents on various industry topics."}]}},"_links":{"self":[{"href":"https:\/\/biddle.com\/blog\/wp-json\/wp\/v2\/posts\/3600","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/biddle.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/biddle.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/biddle.com\/blog\/wp-json\/wp\/v2\/users\/101026"}],"replies":[{"embeddable":true,"href":"https:\/\/biddle.com\/blog\/wp-json\/wp\/v2\/comments?post=3600"}],"version-history":[{"count":1,"href":"https:\/\/biddle.com\/blog\/wp-json\/wp\/v2\/posts\/3600\/revisions"}],"predecessor-version":[{"id":5009,"href":"https:\/\/biddle.com\/blog\/wp-json\/wp\/v2\/posts\/3600\/revisions\/5009"}],"wp:attachment":[{"href":"https:\/\/biddle.com\/blog\/wp-json\/wp\/v2\/media?parent=3600"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/biddle.com\/blog\/wp-json\/wp\/v2\/categories?post=3600"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/biddle.com\/blog\/wp-json\/wp\/v2\/tags?post=3600"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}