{"id":111,"date":"2019-10-23T20:56:13","date_gmt":"2019-10-23T18:56:13","guid":{"rendered":"http:\/\/kalkulacija.com\/wordpress\/?p=111"},"modified":"2020-05-01T22:44:12","modified_gmt":"2020-05-01T20:44:12","slug":"zamrznite-kolone-ili-redove","status":"publish","type":"post","link":"https:\/\/kalkulacija.com\/wordpress\/en\/zamrznite-kolone-ili-redove\/","title":{"rendered":"Freeze columns and rows"},"content":{"rendered":"Column names are almost always found in the upper cells, so if the table is large, and we are at the bottom, it can be difficult to know where to find the correct column. The same goes for rows. In such situations, it is a great idea to freeze columns or rows, so you are always visible regardless of which part of the table is found.<br \/>\nThis is done very easily. It is necessary that you select the row or column after what we want to be frozen, and then go to View &#8211; Freeze Panes.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-112 size-full\" src=\"http:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2016\/12\/friz.png\" alt=\"freeze panes\" width=\"575\" height=\"257\" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2016\/12\/friz.png 575w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2016\/12\/friz-350x156.png 350w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2016\/12\/friz-300x134.png 300w\" sizes=\"auto, (max-width: 575px) 100vw, 575px\" \/>\n\n\n<div class=\"kk-star-ratings kksr-auto kksr-align-right kksr-valign-bottom\"\n    data-payload='{&quot;align&quot;:&quot;right&quot;,&quot;id&quot;:&quot;111&quot;,&quot;slug&quot;:&quot;default&quot;,&quot;valign&quot;:&quot;bottom&quot;,&quot;ignore&quot;:&quot;&quot;,&quot;reference&quot;:&quot;auto&quot;,&quot;class&quot;:&quot;&quot;,&quot;count&quot;:&quot;0&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;0&quot;,&quot;starsonly&quot;:&quot;&quot;,&quot;best&quot;:&quot;5&quot;,&quot;gap&quot;:&quot;5&quot;,&quot;greet&quot;:&quot;Rate this post&quot;,&quot;legend&quot;:&quot;0\\\/5 - (0 votes)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;Freeze columns and rows&quot;,&quot;width&quot;:&quot;0&quot;,&quot;_legend&quot;:&quot;{score}\\\/{best} - ({count} {votes})&quot;,&quot;font_factor&quot;:&quot;1.25&quot;}'>\n            \n<div class=\"kksr-stars\">\n    \n<div class=\"kksr-stars-inactive\">\n            <div class=\"kksr-star\" data-star=\"1\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"2\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"3\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"4\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"5\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n    \n<div class=\"kksr-stars-active\" style=\"width: 0px;\">\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n<\/div>\n                \n\n<div class=\"kksr-legend\" style=\"font-size: 19.2px;\">\n            <span class=\"kksr-muted\">Rate this post<\/span>\n    <\/div>\n    <\/div>","protected":false},"excerpt":{"rendered":"<p>Column names are almost always found in the upper cells, so if the table is large, and we are at<\/p>\n","protected":false},"author":1,"featured_media":112,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19],"tags":[],"class_list":["post-111","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-ekscel"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Freeze columns and rows - Calculation in essence of everything!<\/title>\n<meta name=\"description\" content=\"Zamrznite kolone ili redove je veoma va\u017ena tema korisnicima excela. Imena kolona se uglavnom uvek nalaze u gornjim \u0107elijama, pa ako je tabela velika, ...\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/kalkulacija.com\/wordpress\/zamrznite-kolone-ili-redove\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[:sr]Zamrznite kolone ili redove[:en]Freeze columns and rows[:] - Calculation in essence of everything!\" \/>\n<meta property=\"og:description\" content=\"Zamrznite kolone ili redove je veoma va\u017ena tema korisnicima excela. Imena kolona se uglavnom uvek nalaze u gornjim \u0107elijama, pa ako je tabela velika, ...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kalkulacija.com\/wordpress\/zamrznite-kolone-ili-redove\/\" \/>\n<meta property=\"og:site_name\" content=\"Calculation in essence of everything!\" \/>\n<meta property=\"article:published_time\" content=\"2019-10-23T18:56:13+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-05-01T20:44:12+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2016\/12\/friz.png\" \/>\n\t<meta property=\"og:image:width\" content=\"575\" \/>\n\t<meta property=\"og:image:height\" content=\"257\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/zamrznite-kolone-ili-redove\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/zamrznite-kolone-ili-redove\\\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\"},\"headline\":\"Freeze columns and rows\",\"datePublished\":\"2019-10-23T18:56:13+00:00\",\"dateModified\":\"2020-05-01T20:44:12+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/zamrznite-kolone-ili-redove\\\/\"},\"wordCount\":300,\"publisher\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\"},\"image\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/zamrznite-kolone-ili-redove\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2016\\\/12\\\/friz.png\",\"articleSection\":[\"Excel\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/zamrznite-kolone-ili-redove\\\/\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/zamrznite-kolone-ili-redove\\\/\",\"name\":\"[:sr]Zamrznite kolone ili redove[:en]Freeze columns and rows[:] - Calculation in essence of everything!\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/zamrznite-kolone-ili-redove\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/zamrznite-kolone-ili-redove\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2016\\\/12\\\/friz.png\",\"datePublished\":\"2019-10-23T18:56:13+00:00\",\"dateModified\":\"2020-05-01T20:44:12+00:00\",\"description\":\"Zamrznite kolone ili redove je veoma va\u017ena tema korisnicima excela. Imena kolona se uglavnom uvek nalaze u gornjim \u0107elijama, pa ako je tabela velika, ...\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/zamrznite-kolone-ili-redove\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/zamrznite-kolone-ili-redove\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/zamrznite-kolone-ili-redove\\\/#primaryimage\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2016\\\/12\\\/friz.png\",\"contentUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2016\\\/12\\\/friz.png\",\"width\":575,\"height\":257,\"caption\":\"freeze panels\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/zamrznite-kolone-ili-redove\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Zamrznite kolone ili redove\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#website\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/\",\"name\":\"Calculation in essence of everything!\",\"description\":\"Go ahead! Improve your data processing skills!\",\"publisher\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Excel-icon.png\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Excel-icon.png\",\"contentUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Excel-icon.png\",\"width\":128,\"height\":128,\"caption\":\"admin\"},\"logo\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Excel-icon.png\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[:sr]Zamrznite kolone ili redove[:en]Freeze columns and rows[:] - Calculation in essence of everything!","description":"Zamrznite kolone ili redove je veoma va\u017ena tema korisnicima excela. Imena kolona se uglavnom uvek nalaze u gornjim \u0107elijama, pa ako je tabela velika, ...","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:\/\/kalkulacija.com\/wordpress\/zamrznite-kolone-ili-redove\/","og_locale":"en_US","og_type":"article","og_title":"[:sr]Zamrznite kolone ili redove[:en]Freeze columns and rows[:] - Calculation in essence of everything!","og_description":"Zamrznite kolone ili redove je veoma va\u017ena tema korisnicima excela. Imena kolona se uglavnom uvek nalaze u gornjim \u0107elijama, pa ako je tabela velika, ...","og_url":"https:\/\/kalkulacija.com\/wordpress\/zamrznite-kolone-ili-redove\/","og_site_name":"Calculation in essence of everything!","article_published_time":"2019-10-23T18:56:13+00:00","article_modified_time":"2020-05-01T20:44:12+00:00","og_image":[{"width":575,"height":257,"url":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2016\/12\/friz.png","type":"image\/png"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/kalkulacija.com\/wordpress\/zamrznite-kolone-ili-redove\/#article","isPartOf":{"@id":"https:\/\/kalkulacija.com\/wordpress\/zamrznite-kolone-ili-redove\/"},"author":{"name":"admin","@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4"},"headline":"Freeze columns and rows","datePublished":"2019-10-23T18:56:13+00:00","dateModified":"2020-05-01T20:44:12+00:00","mainEntityOfPage":{"@id":"https:\/\/kalkulacija.com\/wordpress\/zamrznite-kolone-ili-redove\/"},"wordCount":300,"publisher":{"@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4"},"image":{"@id":"https:\/\/kalkulacija.com\/wordpress\/zamrznite-kolone-ili-redove\/#primaryimage"},"thumbnailUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2016\/12\/friz.png","articleSection":["Excel"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/kalkulacija.com\/wordpress\/zamrznite-kolone-ili-redove\/","url":"https:\/\/kalkulacija.com\/wordpress\/zamrznite-kolone-ili-redove\/","name":"[:sr]Zamrznite kolone ili redove[:en]Freeze columns and rows[:] - Calculation in essence of everything!","isPartOf":{"@id":"https:\/\/kalkulacija.com\/wordpress\/#website"},"primaryImageOfPage":{"@id":"https:\/\/kalkulacija.com\/wordpress\/zamrznite-kolone-ili-redove\/#primaryimage"},"image":{"@id":"https:\/\/kalkulacija.com\/wordpress\/zamrznite-kolone-ili-redove\/#primaryimage"},"thumbnailUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2016\/12\/friz.png","datePublished":"2019-10-23T18:56:13+00:00","dateModified":"2020-05-01T20:44:12+00:00","description":"Zamrznite kolone ili redove je veoma va\u017ena tema korisnicima excela. Imena kolona se uglavnom uvek nalaze u gornjim \u0107elijama, pa ako je tabela velika, ...","breadcrumb":{"@id":"https:\/\/kalkulacija.com\/wordpress\/zamrznite-kolone-ili-redove\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kalkulacija.com\/wordpress\/zamrznite-kolone-ili-redove\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kalkulacija.com\/wordpress\/zamrznite-kolone-ili-redove\/#primaryimage","url":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2016\/12\/friz.png","contentUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2016\/12\/friz.png","width":575,"height":257,"caption":"freeze panels"},{"@type":"BreadcrumbList","@id":"https:\/\/kalkulacija.com\/wordpress\/zamrznite-kolone-ili-redove\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/kalkulacija.com\/wordpress\/"},{"@type":"ListItem","position":2,"name":"Zamrznite kolone ili redove"}]},{"@type":"WebSite","@id":"https:\/\/kalkulacija.com\/wordpress\/#website","url":"https:\/\/kalkulacija.com\/wordpress\/","name":"Calculation in essence of everything!","description":"Go ahead! Improve your data processing skills!","publisher":{"@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/kalkulacija.com\/wordpress\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-icon.png","url":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-icon.png","contentUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-icon.png","width":128,"height":128,"caption":"admin"},"logo":{"@id":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-icon.png"}}]}},"_links":{"self":[{"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/posts\/111","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/comments?post=111"}],"version-history":[{"count":9,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/posts\/111\/revisions"}],"predecessor-version":[{"id":2127,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/posts\/111\/revisions\/2127"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/media\/112"}],"wp:attachment":[{"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/media?parent=111"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/categories?post=111"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/tags?post=111"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}