{"id":1158,"date":"2018-01-12T11:49:27","date_gmt":"2018-01-12T10:49:27","guid":{"rendered":"http:\/\/kalkulacija.com\/wordpress\/?p=1158"},"modified":"2018-01-12T11:57:29","modified_gmt":"2018-01-12T10:57:29","slug":"excel-formula-hyperlink","status":"publish","type":"post","link":"https:\/\/kalkulacija.com\/wordpress\/excel-formula-hyperlink\/","title":{"rendered":"[:sr]Excel formula HYPERLINK[:en]HYPERLINK Formulas[:]"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_87_1 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">[:sr]Sadr\u017eaj[:en] Contents[:]<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #0d590e;color:#0d590e\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #0d590e;color:#0d590e\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><ul class='ez-toc-list-level-5' ><li class='ez-toc-heading-level-5'><ul class='ez-toc-list-level-5' ><li class='ez-toc-heading-level-5'><ul class='ez-toc-list-level-5' ><li class='ez-toc-heading-level-5'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/kalkulacija.com\/wordpress\/excel-formula-hyperlink\/#Formula_HYPERLINK_sintaksa\" >Formula HYPERLINK sintaksa<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-5'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/kalkulacija.com\/wordpress\/excel-formula-hyperlink\/#Argumenti\" >Argumenti<\/a><\/li><\/ul><\/li><\/ul><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/kalkulacija.com\/wordpress\/excel-formula-hyperlink\/#Slanje_mejlova_iz_EXCEL-a\" >Slanje mejlova iz EXCEL-a<\/a><\/li><\/ul><\/nav><\/div>\n[:sr]Excel formula HYPERLINK omogu\u0107ava povezivanje na navedenu internet lokaciju upotrebom &#8220;prijateljskog naziva&#8221;. Mo\u017eete je koristiti kao klikabilni link nastao iz prora\u010dunate formule. Ova formula omogu\u0107ava i povezivanje vi\u0161e lokacija u radnoj tabeli, kao i &#8220;skakanje&#8221; izme\u0111u radnih tabela ili datoteka.<\/p>\n<h5><span class=\"ez-toc-section\" id=\"Formula_HYPERLINK_sintaksa\"><\/span>Formula HYPERLINK sintaksa<span class=\"ez-toc-section-end\"><\/span><\/h5>\n<p>Izrada klikabilnog llinka radi interaktivnog povezivanja sadr\u017eaja.<\/p>\n<p>=HYPERLINK (link_location, [friendly_name])<\/p>\n<h5><span class=\"ez-toc-section\" id=\"Argumenti\"><\/span>Argumenti<span class=\"ez-toc-section-end\"><\/span><\/h5>\n<p><strong>link_location<\/strong> &#8211; put do datoteke ili lokacije koju \u017eelimo povezati.<br \/>\n<strong>friendly_name<\/strong> &#8211; [opciono] Tekst koji \u017eelimo da bude linkovan, mada u slu\u010daju da ne bude naveden bi\u0107e isti tekst kao u prethodnom parametru link_location.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Slanje_mejlova_iz_EXCEL-a\"><\/span>Slanje mejlova iz EXCEL-a<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Formulu HYPERLINK mo\u017eete upotrebiti za slanje mejlova iz excelove datoteke direktno.<\/p>\n<figure id=\"attachment_1160\" aria-describedby=\"caption-attachment-1160\" style=\"width: 836px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-1160 size-full\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2018\/01\/formula-hyperlink.png\" alt=\"formula HYPERLINK\" width=\"836\" height=\"532\" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2018\/01\/formula-hyperlink.png 836w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2018\/01\/formula-hyperlink-350x223.png 350w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2018\/01\/formula-hyperlink-300x191.png 300w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2018\/01\/formula-hyperlink-768x489.png 768w\" sizes=\"auto, (max-width: 836px) 100vw, 836px\" \/><figcaption id=\"caption-attachment-1160\" class=\"wp-caption-text\">formula HYPERLINK<\/figcaption><\/figure>\n<p>U primeru iz slike mo\u0161ete sve pripremiti i u polju B4 upotrebiti formulu sa slede\u0107im sadr\u017eajem:<\/p>\n<p><strong>=HYPERLINK(&#8220;mailto:&#8221; &amp; B1 &amp; &#8220;?subject=&#8221;&amp; B2 &amp; &#8220;&amp;body=&#8221; &amp; B3; &#8220;Sada&#8221;)<\/strong><\/p>\n<p>Excel HYPERLINK\u00a0 omogu\u0107ava povezivanje na navedenu internet lokaciju upotrebom &#8220;prijateljskog naziva&#8221;. Mo\u017eete je koristiti kao klikabilni HYPERLINK nastao iz prora\u010dunate formule. HYPERLINK formula omogu\u0107ava i povezivanje vi\u0161e lokacija u radnoj tabeli, kao i &#8220;skakanje&#8221; izme\u0111u radnih tabela ili datoteka.[:en]The Excel HYPERLINK function returns a hyperlink from a given destination and &#8220;friendly name&#8221;. You can use HYPERLINK to construct a clickable hyperlink with a formula. The HYPERLINK function can build links to workbook locations, pages on the internet, or to files on network servers.<\/p>\n<p>Purpose<br \/>\nCreate a clickable link.<br \/>\nReturn value<br \/>\nA clickable hyperlink<br \/>\nSyntax<br \/>\n=HYPERLINK (link_location, [friendly_name])<br \/>\nArguments<br \/>\nlink_location &#8211; The path to the file or page to be opened.<br \/>\nfriendly_name &#8211; [optional] The link text to display in a cell.<br \/>\nUsage notes<br \/>\nUse the HYPERLINK function to create links to workbook locations, pages on the internet, or to files on network servers.<\/p>\n<p>When a user clicks a cell that contains the HYPERLINK function, Excel will open the file or page specified by link_location. Link_location can be a cell reference or named range, a path to a file stored on a local drive, a path a file on a server using Universal Naming Convention (UNC) or a path to a location on the internet or an intranet in Uniform Resource Locator (URL) format.<\/p>\n<p>Link_location should be supplied as a text string in quotation marks or a cell reference that contains the link path as text.<br \/>\nIf friendly_name is not supplied, the HYPERLINK will display link_location as the friendly_name.<br \/>\nTo select a cell that contains HYPERLINK without jumping to the destination, use arrow keys to select the cell. Alternatively, click on the cell and hold the mouse button down until the cursor changes.[:]\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;1158&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;[:sr] Ocenite [:en]Rate this [:]post&quot;,&quot;legend&quot;:&quot;0\\\/5 - (0 votes)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;[:sr]Excel formula HYPERLINK[:en]HYPERLINK Formulas[:]&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\">[:sr] Ocenite [:en]Rate this [:]post<\/span>\n    <\/div>\n    <\/div>\n","protected":false},"excerpt":{"rendered":"<p>[:sr]Excel formula HYPERLINK omogu\u0107ava povezivanje na navedenu internet lokaciju upotrebom &#8220;prijateljskog naziva&#8221;. Mo\u017eete je koristiti kao klikabilni link nastao iz<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[42,49],"tags":[],"class_list":["post-1158","post","type-post","status-publish","format-standard","hentry","category-napredni-excel","category-saveti-napredni-excel"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>[:sr]Excel formula HYPERLINK[:en]HYPERLINK Formulas[:] - Kalkulacija u osnovi svega!<\/title>\n<meta name=\"description\" content=\"Excel formula HYPERLINK omogu\u0107ava povezivanje na navedenu internet lokaciju upotrebom &quot;prijateljskog naziva&quot;. Mo\u017eete je koristiti kao klikabilni HYPERLINK nastao iz prora\u010dunate formule. Formula HYPERLINK omogu\u0107ava i povezivanje vi\u0161e lokacija u radnoj tabeli, kao i &quot;skakanje&quot; izme\u0111u radnih tabela ili datoteka.\" \/>\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\/excel-formula-hyperlink\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[:sr]Excel formula HYPERLINK[:en]HYPERLINK Formulas[:] - Kalkulacija u osnovi svega!\" \/>\n<meta property=\"og:description\" content=\"Excel formula HYPERLINK omogu\u0107ava povezivanje na navedenu internet lokaciju upotrebom &quot;prijateljskog naziva&quot;. Mo\u017eete je koristiti kao klikabilni HYPERLINK nastao iz prora\u010dunate formule. Formula HYPERLINK omogu\u0107ava i povezivanje vi\u0161e lokacija u radnoj tabeli, kao i &quot;skakanje&quot; izme\u0111u radnih tabela ili datoteka.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kalkulacija.com\/wordpress\/excel-formula-hyperlink\/\" \/>\n<meta property=\"og:site_name\" content=\"Kalkulacija u osnovi svega!\" \/>\n<meta property=\"article:published_time\" content=\"2018-01-12T10:49:27+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-01-12T10:57:29+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2018\/01\/formula-hyperlink.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=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/excel-formula-hyperlink\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/excel-formula-hyperlink\\\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\"},\"headline\":\"[:sr]Excel formula HYPERLINK[:en]HYPERLINK Formulas[:]\",\"datePublished\":\"2018-01-12T10:49:27+00:00\",\"dateModified\":\"2018-01-12T10:57:29+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/excel-formula-hyperlink\\\/\"},\"wordCount\":468,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\"},\"image\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/excel-formula-hyperlink\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2018\\\/01\\\/formula-hyperlink.png\",\"articleSection\":[\"Napredni Excel\",\"Saveti za napredni excel\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/excel-formula-hyperlink\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/excel-formula-hyperlink\\\/\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/excel-formula-hyperlink\\\/\",\"name\":\"[:sr]Excel formula HYPERLINK[:en]HYPERLINK Formulas[:] - Kalkulacija u osnovi svega!\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/excel-formula-hyperlink\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/excel-formula-hyperlink\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2018\\\/01\\\/formula-hyperlink.png\",\"datePublished\":\"2018-01-12T10:49:27+00:00\",\"dateModified\":\"2018-01-12T10:57:29+00:00\",\"description\":\"Excel formula HYPERLINK omogu\u0107ava povezivanje na navedenu internet lokaciju upotrebom \\\"prijateljskog naziva\\\". Mo\u017eete je koristiti kao klikabilni HYPERLINK nastao iz prora\u010dunate formule. Formula HYPERLINK omogu\u0107ava i povezivanje vi\u0161e lokacija u radnoj tabeli, kao i \\\"skakanje\\\" izme\u0111u radnih tabela ili datoteka.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/excel-formula-hyperlink\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/excel-formula-hyperlink\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/excel-formula-hyperlink\\\/#primaryimage\",\"url\":\"http:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2018\\\/01\\\/formula-hyperlink.png\",\"contentUrl\":\"http:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2018\\\/01\\\/formula-hyperlink.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/excel-formula-hyperlink\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel formula HYPERLINK\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#website\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/\",\"name\":\"Kalkulacija u osnovi svega!\",\"description\":\"Samo napred! Unapredite svoje ve\u0161tine obrade podataka!\",\"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]Excel formula HYPERLINK[:en]HYPERLINK Formulas[:] - Kalkulacija u osnovi svega!","description":"Excel formula HYPERLINK omogu\u0107ava povezivanje na navedenu internet lokaciju upotrebom \"prijateljskog naziva\". Mo\u017eete je koristiti kao klikabilni HYPERLINK nastao iz prora\u010dunate formule. Formula HYPERLINK omogu\u0107ava i povezivanje vi\u0161e lokacija u radnoj tabeli, kao i \"skakanje\" izme\u0111u radnih tabela ili datoteka.","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\/excel-formula-hyperlink\/","og_locale":"en_US","og_type":"article","og_title":"[:sr]Excel formula HYPERLINK[:en]HYPERLINK Formulas[:] - Kalkulacija u osnovi svega!","og_description":"Excel formula HYPERLINK omogu\u0107ava povezivanje na navedenu internet lokaciju upotrebom \"prijateljskog naziva\". Mo\u017eete je koristiti kao klikabilni HYPERLINK nastao iz prora\u010dunate formule. Formula HYPERLINK omogu\u0107ava i povezivanje vi\u0161e lokacija u radnoj tabeli, kao i \"skakanje\" izme\u0111u radnih tabela ili datoteka.","og_url":"https:\/\/kalkulacija.com\/wordpress\/excel-formula-hyperlink\/","og_site_name":"Kalkulacija u osnovi svega!","article_published_time":"2018-01-12T10:49:27+00:00","article_modified_time":"2018-01-12T10:57:29+00:00","og_image":[{"url":"http:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2018\/01\/formula-hyperlink.png","type":"","width":"","height":""}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/kalkulacija.com\/wordpress\/excel-formula-hyperlink\/#article","isPartOf":{"@id":"https:\/\/kalkulacija.com\/wordpress\/excel-formula-hyperlink\/"},"author":{"name":"admin","@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4"},"headline":"[:sr]Excel formula HYPERLINK[:en]HYPERLINK Formulas[:]","datePublished":"2018-01-12T10:49:27+00:00","dateModified":"2018-01-12T10:57:29+00:00","mainEntityOfPage":{"@id":"https:\/\/kalkulacija.com\/wordpress\/excel-formula-hyperlink\/"},"wordCount":468,"commentCount":0,"publisher":{"@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4"},"image":{"@id":"https:\/\/kalkulacija.com\/wordpress\/excel-formula-hyperlink\/#primaryimage"},"thumbnailUrl":"http:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2018\/01\/formula-hyperlink.png","articleSection":["Napredni Excel","Saveti za napredni excel"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/kalkulacija.com\/wordpress\/excel-formula-hyperlink\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/kalkulacija.com\/wordpress\/excel-formula-hyperlink\/","url":"https:\/\/kalkulacija.com\/wordpress\/excel-formula-hyperlink\/","name":"[:sr]Excel formula HYPERLINK[:en]HYPERLINK Formulas[:] - Kalkulacija u osnovi svega!","isPartOf":{"@id":"https:\/\/kalkulacija.com\/wordpress\/#website"},"primaryImageOfPage":{"@id":"https:\/\/kalkulacija.com\/wordpress\/excel-formula-hyperlink\/#primaryimage"},"image":{"@id":"https:\/\/kalkulacija.com\/wordpress\/excel-formula-hyperlink\/#primaryimage"},"thumbnailUrl":"http:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2018\/01\/formula-hyperlink.png","datePublished":"2018-01-12T10:49:27+00:00","dateModified":"2018-01-12T10:57:29+00:00","description":"Excel formula HYPERLINK omogu\u0107ava povezivanje na navedenu internet lokaciju upotrebom \"prijateljskog naziva\". Mo\u017eete je koristiti kao klikabilni HYPERLINK nastao iz prora\u010dunate formule. Formula HYPERLINK omogu\u0107ava i povezivanje vi\u0161e lokacija u radnoj tabeli, kao i \"skakanje\" izme\u0111u radnih tabela ili datoteka.","breadcrumb":{"@id":"https:\/\/kalkulacija.com\/wordpress\/excel-formula-hyperlink\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kalkulacija.com\/wordpress\/excel-formula-hyperlink\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kalkulacija.com\/wordpress\/excel-formula-hyperlink\/#primaryimage","url":"http:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2018\/01\/formula-hyperlink.png","contentUrl":"http:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2018\/01\/formula-hyperlink.png"},{"@type":"BreadcrumbList","@id":"https:\/\/kalkulacija.com\/wordpress\/excel-formula-hyperlink\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/kalkulacija.com\/wordpress\/"},{"@type":"ListItem","position":2,"name":"Excel formula HYPERLINK"}]},{"@type":"WebSite","@id":"https:\/\/kalkulacija.com\/wordpress\/#website","url":"https:\/\/kalkulacija.com\/wordpress\/","name":"Kalkulacija u osnovi svega!","description":"Samo napred! Unapredite svoje ve\u0161tine obrade podataka!","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\/wp-json\/wp\/v2\/posts\/1158","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/comments?post=1158"}],"version-history":[{"count":9,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/posts\/1158\/revisions"}],"predecessor-version":[{"id":1168,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/posts\/1158\/revisions\/1168"}],"wp:attachment":[{"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/media?parent=1158"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/categories?post=1158"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/tags?post=1158"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}