{"id":60,"date":"2008-11-30T11:17:34","date_gmt":"2008-11-30T11:17:34","guid":{"rendered":"http:\/\/jobshuk.com\/easydatasolutions\/2008\/11\/30\/excel-tips-5-freeze-split-and-hide\/"},"modified":"2008-11-30T11:17:34","modified_gmt":"2008-11-30T11:17:34","slug":"excel-tips-5-freeze-split-and-hide","status":"publish","type":"post","link":"https:\/\/jobshuk.com\/easydatasolutions\/2008\/11\/30\/excel-tips-5-freeze-split-and-hide\/","title":{"rendered":"Excel Tips #5: Freeze, split and hide"},"content":{"rendered":"

This blog was authored by Y. Karp.<\/span><\/em><\/p>\n

<\/span><\/em>Excel<\/span><\/strong> 2003 is limited to 65,536 rows and 256 columns. That might sound like a lot, but there are often situations where a spreadsheet you have designed can go right up to the limit. In fact, Microsoft increased these limits in Excel 2007 (1,048,576 rows and 16,384 columns).<\/span><\/p>\n

<\/span>For<\/span><\/strong> most of us, 65,536 rows and 256 columns may be more than enough. However, it is very common that your spreadsheet will extend beyond your screen real-estate, requiring you to scroll along or down the worksheet to view the data that initially appears off the page. When you do this, you can no longer see column or row headings, which can really make it difficult to know what you are looking at.<\/span><\/p>\n

<\/span>The answer: Freeze, Split and Hide (sounds like a law firm, doesn’t it?)<\/span><\/p>\n

<\/span>Freeze: <\/span><\/strong>Freezing an area of the worksheet allows you to view data on one part of the worksheet while scrolling through the rest of the worksheet. For example, if the top of your spreadsheet contains column headings, freeze Row 1 so that as you scroll down the sheet, Row 1 remains visible. You can do the same ­­for row headings by freezing columns. You can freeze one row or column or multiple rows or columns. For instance, you can make sure that as you scroll through your worksheet, columns A:C always remains visible. You can also freeze both a row and a column so that they always show as you scroll up and down or left and right.<\/span><\/p>\n

<\/span>Split: <\/span><\/strong>Splitting a worksheet allows you to to work on one part of the spreadsheet whilst still viewing a second part of the spreadsheet. Let’s say that you want to view columns AX:AZ while working on columns CP:CS: You can split the worksheet into two so that separate scroll bars appear below the two parts, as if they are in separate windows. The term “split” is not entirely accurate because you don’t create two spreadsheets from one. You only create a duplicate view. Think of it like a split-screen on your television, showing opposite ends of the same football field. As players on both screens run towards the center, the two sides of the screen end up showing the same picture because it is the same football field. So if you split the spreadsheet, you can still scroll along the entire length and breadth of the sheet on either of the split areas. Any changes made in one will immediately effect changes made in the other because they are really the same spreadsheet.<\/span><\/p>\n

<\/span>Hide: <\/span><\/strong>You can also hide columns to make them sort of invisible, although they are really still there. You will know that the row or column is hidden because the row numbers or the column headers will no longer be sequential, e.g.: 1,2,5,6,7. You can unhide the rows or columns at will to display them. This is particularly useful if you have rows or columns that are there for calculation or functions, but do not add value to the data itself. Hiding rows and columns can reduce the amount of screen space the spreadsheet uses, making it easier to work with.<\/span><\/p>\n

<\/span>So<\/span><\/strong> you have a choice of how to solve the problem of too much data and too little screen real-estate by choosing any or all of these solutions.<\/span><\/p>\n

<\/span>If you would like to make the most of your business information and understand what your data is telling you, contact Easy Data Solutions for customized Excel spreadsheets, business information models and professional PowerPoint presentations.<\/span><\/em><\/span><\/em> <\/p>\n

Website: <\/span>www.easydatasolutions.co.il<\/font><\/a>   Email: <\/span>in**<\/span>@******************<\/span>co.il<\/span><\/font><\/a><\/span><\/span><\/span><\/span><\/p>\n

<\/span><\/span><\/span>  <\/span> <\/span><\/p>\n\n\n","protected":false},"excerpt":{"rendered":"

This blog was authored by Y. Karp. Excel 2003 is limited to 65,536 rows and 256 columns. That might sound like a lot, but there are often situations where a spreadsheet you have designed can go right up to the limit. In fact, Microsoft increased these limits in Excel 2007 (1,048,576 rows and 16,384 columns). … <\/p>\n

Continue reading “Excel Tips #5: Freeze, split and hide”<\/span><\/a><\/p>\n\n\n","protected":false},"author":114,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[11,12,7,8,4,9,5,20,21],"class_list":["post-60","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-business","tag-consultant","tag-consulting","tag-data","tag-excel","tag-information","tag-microsoft","tag-services","tag-spreadsheet","entry"],"yoast_head":"\nExcel Tips #5: Freeze, split and hide - easydatasolutions's blog by Rafi Karp<\/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:\/\/jobshuk.com\/easydatasolutions\/2008\/11\/30\/excel-tips-5-freeze-split-and-hide\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel Tips #5: Freeze, split and hide - easydatasolutions's blog by Rafi Karp\" \/>\n<meta property=\"og:description\" content=\"This blog was authored by Y. Karp. Excel 2003 is limited to 65,536 rows and 256 columns. That might sound like a lot, but there are often situations where a spreadsheet you have designed can go right up to the limit. In fact, Microsoft increased these limits in Excel 2007 (1,048,576 rows and 16,384 columns). … Continue reading "Excel Tips #5: Freeze, split and hide"\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jobshuk.com\/easydatasolutions\/2008\/11\/30\/excel-tips-5-freeze-split-and-hide\/\" \/>\n<meta property=\"og:site_name\" content=\"easydatasolutions's blog by Rafi Karp\" \/>\n<meta property=\"article:published_time\" content=\"2008-11-30T11:17:34+00:00\" \/>\n<meta name=\"author\" content=\"easydatasolutions\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"easydatasolutions\" \/>\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:\\\/\\\/jobshuk.com\\\/easydatasolutions\\\/2008\\\/11\\\/30\\\/excel-tips-5-freeze-split-and-hide\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/jobshuk.com\\\/easydatasolutions\\\/2008\\\/11\\\/30\\\/excel-tips-5-freeze-split-and-hide\\\/\"},\"author\":{\"name\":\"easydatasolutions\",\"@id\":\"https:\\\/\\\/jobshuk.com\\\/easydatasolutions\\\/#\\\/schema\\\/person\\\/0c330ae54dbf357605bbf2e503832a75\"},\"headline\":\"Excel Tips #5: Freeze, split and hide\",\"datePublished\":\"2008-11-30T11:17:34+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/jobshuk.com\\\/easydatasolutions\\\/2008\\\/11\\\/30\\\/excel-tips-5-freeze-split-and-hide\\\/\"},\"wordCount\":621,\"commentCount\":1,\"keywords\":[\"business\",\"consultant\",\"consulting\",\"data\",\"Excel\",\"information\",\"Microsoft\",\"services\",\"spreadsheet\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/jobshuk.com\\\/easydatasolutions\\\/2008\\\/11\\\/30\\\/excel-tips-5-freeze-split-and-hide\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/jobshuk.com\\\/easydatasolutions\\\/2008\\\/11\\\/30\\\/excel-tips-5-freeze-split-and-hide\\\/\",\"url\":\"https:\\\/\\\/jobshuk.com\\\/easydatasolutions\\\/2008\\\/11\\\/30\\\/excel-tips-5-freeze-split-and-hide\\\/\",\"name\":\"Excel Tips #5: Freeze, split and hide - easydatasolutions's blog by Rafi Karp\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/jobshuk.com\\\/easydatasolutions\\\/#website\"},\"datePublished\":\"2008-11-30T11:17:34+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/jobshuk.com\\\/easydatasolutions\\\/#\\\/schema\\\/person\\\/0c330ae54dbf357605bbf2e503832a75\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/jobshuk.com\\\/easydatasolutions\\\/2008\\\/11\\\/30\\\/excel-tips-5-freeze-split-and-hide\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/jobshuk.com\\\/easydatasolutions\\\/2008\\\/11\\\/30\\\/excel-tips-5-freeze-split-and-hide\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/jobshuk.com\\\/easydatasolutions\\\/2008\\\/11\\\/30\\\/excel-tips-5-freeze-split-and-hide\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/jobshuk.com\\\/easydatasolutions\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel Tips #5: Freeze, split and hide\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/jobshuk.com\\\/easydatasolutions\\\/#website\",\"url\":\"https:\\\/\\\/jobshuk.com\\\/easydatasolutions\\\/\",\"name\":\"easydatasolutions's blog by Rafi Karp\",\"description\":\"Just another JobShuk site\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/jobshuk.com\\\/easydatasolutions\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/jobshuk.com\\\/easydatasolutions\\\/#\\\/schema\\\/person\\\/0c330ae54dbf357605bbf2e503832a75\",\"name\":\"easydatasolutions\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/jobshuk.com\\\/easydatasolutions\\\/wp-content\\\/uploads\\\/avatars\\\/114\\\/289cddb7b0909b29f6f45faf2e3dc19c-bpfull.jpg\",\"url\":\"https:\\\/\\\/jobshuk.com\\\/easydatasolutions\\\/wp-content\\\/uploads\\\/avatars\\\/114\\\/289cddb7b0909b29f6f45faf2e3dc19c-bpfull.jpg\",\"contentUrl\":\"https:\\\/\\\/jobshuk.com\\\/easydatasolutions\\\/wp-content\\\/uploads\\\/avatars\\\/114\\\/289cddb7b0909b29f6f45faf2e3dc19c-bpfull.jpg\",\"caption\":\"easydatasolutions\"},\"url\":\"https:\\\/\\\/jobshuk.com\\\/easydatasolutions\\\/author\\\/easydatasolutions\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel Tips #5: Freeze, split and hide - easydatasolutions's blog by Rafi Karp","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:\/\/jobshuk.com\/easydatasolutions\/2008\/11\/30\/excel-tips-5-freeze-split-and-hide\/","og_locale":"en_US","og_type":"article","og_title":"Excel Tips #5: Freeze, split and hide - easydatasolutions's blog by Rafi Karp","og_description":"This blog was authored by Y. Karp. Excel 2003 is limited to 65,536 rows and 256 columns. That might sound like a lot, but there are often situations where a spreadsheet you have designed can go right up to the limit. In fact, Microsoft increased these limits in Excel 2007 (1,048,576 rows and 16,384 columns). … Continue reading \"Excel Tips #5: Freeze, split and hide\"","og_url":"https:\/\/jobshuk.com\/easydatasolutions\/2008\/11\/30\/excel-tips-5-freeze-split-and-hide\/","og_site_name":"easydatasolutions's blog by Rafi Karp","article_published_time":"2008-11-30T11:17:34+00:00","author":"easydatasolutions","twitter_card":"summary_large_image","twitter_misc":{"Written by":"easydatasolutions","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/jobshuk.com\/easydatasolutions\/2008\/11\/30\/excel-tips-5-freeze-split-and-hide\/#article","isPartOf":{"@id":"https:\/\/jobshuk.com\/easydatasolutions\/2008\/11\/30\/excel-tips-5-freeze-split-and-hide\/"},"author":{"name":"easydatasolutions","@id":"https:\/\/jobshuk.com\/easydatasolutions\/#\/schema\/person\/0c330ae54dbf357605bbf2e503832a75"},"headline":"Excel Tips #5: Freeze, split and hide","datePublished":"2008-11-30T11:17:34+00:00","mainEntityOfPage":{"@id":"https:\/\/jobshuk.com\/easydatasolutions\/2008\/11\/30\/excel-tips-5-freeze-split-and-hide\/"},"wordCount":621,"commentCount":1,"keywords":["business","consultant","consulting","data","Excel","information","Microsoft","services","spreadsheet"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/jobshuk.com\/easydatasolutions\/2008\/11\/30\/excel-tips-5-freeze-split-and-hide\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/jobshuk.com\/easydatasolutions\/2008\/11\/30\/excel-tips-5-freeze-split-and-hide\/","url":"https:\/\/jobshuk.com\/easydatasolutions\/2008\/11\/30\/excel-tips-5-freeze-split-and-hide\/","name":"Excel Tips #5: Freeze, split and hide - easydatasolutions's blog by Rafi Karp","isPartOf":{"@id":"https:\/\/jobshuk.com\/easydatasolutions\/#website"},"datePublished":"2008-11-30T11:17:34+00:00","author":{"@id":"https:\/\/jobshuk.com\/easydatasolutions\/#\/schema\/person\/0c330ae54dbf357605bbf2e503832a75"},"breadcrumb":{"@id":"https:\/\/jobshuk.com\/easydatasolutions\/2008\/11\/30\/excel-tips-5-freeze-split-and-hide\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jobshuk.com\/easydatasolutions\/2008\/11\/30\/excel-tips-5-freeze-split-and-hide\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/jobshuk.com\/easydatasolutions\/2008\/11\/30\/excel-tips-5-freeze-split-and-hide\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jobshuk.com\/easydatasolutions\/"},{"@type":"ListItem","position":2,"name":"Excel Tips #5: Freeze, split and hide"}]},{"@type":"WebSite","@id":"https:\/\/jobshuk.com\/easydatasolutions\/#website","url":"https:\/\/jobshuk.com\/easydatasolutions\/","name":"easydatasolutions's blog by Rafi Karp","description":"Just another JobShuk site","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/jobshuk.com\/easydatasolutions\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/jobshuk.com\/easydatasolutions\/#\/schema\/person\/0c330ae54dbf357605bbf2e503832a75","name":"easydatasolutions","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jobshuk.com\/easydatasolutions\/wp-content\/uploads\/avatars\/114\/289cddb7b0909b29f6f45faf2e3dc19c-bpfull.jpg","url":"https:\/\/jobshuk.com\/easydatasolutions\/wp-content\/uploads\/avatars\/114\/289cddb7b0909b29f6f45faf2e3dc19c-bpfull.jpg","contentUrl":"https:\/\/jobshuk.com\/easydatasolutions\/wp-content\/uploads\/avatars\/114\/289cddb7b0909b29f6f45faf2e3dc19c-bpfull.jpg","caption":"easydatasolutions"},"url":"https:\/\/jobshuk.com\/easydatasolutions\/author\/easydatasolutions\/"}]}},"_links":{"self":[{"href":"https:\/\/jobshuk.com\/easydatasolutions\/wp-json\/wp\/v2\/posts\/60","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jobshuk.com\/easydatasolutions\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jobshuk.com\/easydatasolutions\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jobshuk.com\/easydatasolutions\/wp-json\/wp\/v2\/users\/114"}],"replies":[{"embeddable":true,"href":"https:\/\/jobshuk.com\/easydatasolutions\/wp-json\/wp\/v2\/comments?post=60"}],"version-history":[{"count":0,"href":"https:\/\/jobshuk.com\/easydatasolutions\/wp-json\/wp\/v2\/posts\/60\/revisions"}],"wp:attachment":[{"href":"https:\/\/jobshuk.com\/easydatasolutions\/wp-json\/wp\/v2\/media?parent=60"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jobshuk.com\/easydatasolutions\/wp-json\/wp\/v2\/categories?post=60"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jobshuk.com\/easydatasolutions\/wp-json\/wp\/v2\/tags?post=60"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}