{"id":18744,"date":"2013-05-08T15:57:53","date_gmt":"2013-05-08T10:27:53","guid":{"rendered":"http:\/\/vskills.in\/certification\/tutorial\/?p=18744"},"modified":"2024-04-12T14:24:19","modified_gmt":"2024-04-12T08:54:19","slug":"create-and-modify-hyperlinks","status":"publish","type":"page","link":"https:\/\/www.vskills.in\/certification\/tutorial\/create-and-modify-hyperlinks\/","title":{"rendered":"Create and Modify Hyperlinks"},"content":{"rendered":"<h4><strong>Create and Modify Hyperlinks<\/strong><\/h4>\n<h2>Create a hyperlink to a new file<\/h2>\n<ol start=\"1\" type=\"1\">\n<li>On a worksheet, click the cell where you want to create a hyperlink.\u00a0TIP\u00a0\u00a0\u00a0You can also select an object, such as a picture or an element in a chart, that you want to use to represent the hyperlink.On the\u00a0Insert\u00a0tab, in the\u00a0Links\u00a0group, click\u00a0Hyperlink.<\/li>\n<\/ol>\n<p><a ref=\"magnificPopup\" href=\"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/14.gif\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-30726\" src=\"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/14.gif\" alt=\"1\" width=\"62\" height=\"85\" \/><\/a><span style=\"text-decoration: underline;\"><strong>TIP<\/strong><\/span>\u00a0\u00a0\u00a0 You can also right-click the cell or graphic and then click\u00a0Hyperlink\u00a0on the shortcut menu, or you can press CTRL+K.<\/p>\n<ul>\n<li><strong>Under\u00a0Link to, click\u00a0Create New Document.<\/strong><\/li>\n<li><strong>In the\u00a0Name of new document\u00a0box, type a name for the new file.<\/strong><\/li>\n<\/ul>\n<p><span style=\"text-decoration: underline;\"><strong>\u00a0TIP<\/strong><\/span>\u00a0\u00a0\u00a0To specify a location other than the one shown under\u00a0Full path, you can type the new location preceding the name in the\u00a0Name of new document\u00a0box, or you can click\u00a0Change\u00a0to select the location that you want and then click\u00a0<strong>OK.<\/strong><\/p>\n<ul>\n<li>Under\u00a0When to edit, click\u00a0Edit the new document later\u00a0or\u00a0Edit the new document now\u00a0to specify when you want to open the new file for editing.<\/li>\n<li>In the\u00a0Text to display\u00a0box, type the text that you want to use to represent the hyperlink.<\/li>\n<li>To display helpful information when you rest the pointer on the hyperlink, click\u00a0ScreenTip, type the text that you want in the\u00a0ScreenTip text\u00a0box, and then click\u00a0OK.<\/li>\n<\/ul>\n<p><a ref=\"magnificPopup\" href=\"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/25.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-30729\" src=\"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/25-300x79.png\" alt=\"2\" width=\"300\" height=\"79\" srcset=\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/25-300x79.png 300w, https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/25-624x166.png 624w, https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/25.png 683w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>Click the Hyperlink button\u00a0<img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/www.addintools.com\/documents\/excel\/where-is-edit-links\/excel-edit-hyperlinks-18-18.png\" alt=\"links button\" width=\"18\" height=\"18\" \/>, you will view the Edit Hyperlinks dialog box pops up as the figure 2 shows:<\/p>\n<p><a ref=\"magnificPopup\" href=\"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/33.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-30730\" src=\"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/33-300x163.png\" alt=\"3\" width=\"300\" height=\"163\" srcset=\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/33-300x163.png 300w, https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/33-624x340.png 624w, https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/33.png 701w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<ul>\n<li>Firstly select the Hyperlinks that you will edit;<\/li>\n<li>Click the\u00a0<strong>Insert<\/strong>\u00a0drop down menu under Main Menus;<\/li>\n<li>Then you will view the<img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/www.addintools.com\/documents\/excel\/where-is-edit-links\/excel-edit-hyperlinks-18-18.png\" alt=\"links button\" width=\"18\" height=\"18\" \/>\u00a0<strong>Hyperlink\u2026<\/strong>\u00a0button.<\/li>\n<\/ul>\n<p><a ref=\"magnificPopup\" href=\"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/42.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-30732\" src=\"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/42-300x230.png\" alt=\"4\" width=\"300\" height=\"230\" srcset=\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/42-300x230.png 300w, https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/42-624x479.png 624w, https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/42.png 674w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<div class=\"apply\">\n<h3>Apply for MS Excel Certification Now!!<\/h3>\n<p><a href=\"https:\/\/www.vskills.in\/certification\/excel-online-certification-course\" target=\"_blank\" rel=\"noopener\">https:\/\/www.vskills.in\/certification\/excel-online-certification-course<\/a><\/p>\n<h4><a href=\"https:\/\/www.vskills.in\/certification\/tutorial\/certified-excel-2003-professional\/\" target=\"_blank\" rel=\"noopener\"><strong>Back to Tutorial<\/strong><\/a><\/h4>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Create and Modify Hyperlinks Create a hyperlink to a new file On a worksheet, click the cell where you want to create a hyperlink.\u00a0TIP\u00a0\u00a0\u00a0You can also select an object, such as a picture or an element in a chart, that you want to use to represent the hyperlink.On the\u00a0Insert\u00a0tab, in the\u00a0Links\u00a0group, click\u00a0Hyperlink. TIP\u00a0\u00a0\u00a0 You can&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"categories":[47],"tags":[5138,5139,5140],"class_list":["post-18744","page","type-page","status-publish","hentry","category-ms-excel","tag-create-and-modify-hyperlinks","tag-hyperlinks","tag-modify-hyperlinks"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Create and Modify Hyperlinks - Tutorial<\/title>\n<meta name=\"description\" content=\"Create and modify hyperlinks. Govt of India Certification for Excel\" \/>\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.vskills.in\/certification\/tutorial\/create-and-modify-hyperlinks\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Create and Modify Hyperlinks - Tutorial\" \/>\n<meta property=\"og:description\" content=\"Create and modify hyperlinks. Govt of India Certification for Excel\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.vskills.in\/certification\/tutorial\/create-and-modify-hyperlinks\/\" \/>\n<meta property=\"og:site_name\" content=\"Tutorial\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/vskills.in\/\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-12T08:54:19+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/14.gif\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/create-and-modify-hyperlinks\/\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/create-and-modify-hyperlinks\/\",\"name\":\"Create and Modify Hyperlinks - Tutorial\",\"isPartOf\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/create-and-modify-hyperlinks\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/create-and-modify-hyperlinks\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/14.gif\",\"datePublished\":\"2013-05-08T10:27:53+00:00\",\"dateModified\":\"2024-04-12T08:54:19+00:00\",\"description\":\"Create and modify hyperlinks. Govt of India Certification for Excel\",\"breadcrumb\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/create-and-modify-hyperlinks\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.vskills.in\/certification\/tutorial\/create-and-modify-hyperlinks\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/create-and-modify-hyperlinks\/#primaryimage\",\"url\":\"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/14.gif\",\"contentUrl\":\"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/14.gif\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/create-and-modify-hyperlinks\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Create and Modify Hyperlinks\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#website\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\",\"name\":\"Tutorial\",\"description\":\"Vskills - A initiative in elearning and certification\",\"publisher\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.vskills.in\/certification\/tutorial\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#organization\",\"name\":\"Vskills\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg\",\"contentUrl\":\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg\",\"width\":73,\"height\":55,\"caption\":\"Vskills\"},\"image\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/vskills.in\/\",\"https:\/\/x.com\/vskills_in\",\"https:\/\/www.linkedin.com\/company-beta\/1371554\/\",\"https:\/\/www.youtube.com\/channel\/UCMWnscxPwRF_PqXo9B7q_Tw\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Create and Modify Hyperlinks - Tutorial","description":"Create and modify hyperlinks. Govt of India Certification for Excel","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.vskills.in\/certification\/tutorial\/create-and-modify-hyperlinks\/","og_locale":"en_US","og_type":"article","og_title":"Create and Modify Hyperlinks - Tutorial","og_description":"Create and modify hyperlinks. Govt of India Certification for Excel","og_url":"https:\/\/www.vskills.in\/certification\/tutorial\/create-and-modify-hyperlinks\/","og_site_name":"Tutorial","article_publisher":"https:\/\/www.facebook.com\/vskills.in\/","article_modified_time":"2024-04-12T08:54:19+00:00","og_image":[{"url":"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/14.gif","type":"","width":"","height":""}],"twitter_misc":{"Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/create-and-modify-hyperlinks\/","url":"https:\/\/www.vskills.in\/certification\/tutorial\/create-and-modify-hyperlinks\/","name":"Create and Modify Hyperlinks - Tutorial","isPartOf":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/create-and-modify-hyperlinks\/#primaryimage"},"image":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/create-and-modify-hyperlinks\/#primaryimage"},"thumbnailUrl":"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/14.gif","datePublished":"2013-05-08T10:27:53+00:00","dateModified":"2024-04-12T08:54:19+00:00","description":"Create and modify hyperlinks. Govt of India Certification for Excel","breadcrumb":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/create-and-modify-hyperlinks\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.vskills.in\/certification\/tutorial\/create-and-modify-hyperlinks\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/create-and-modify-hyperlinks\/#primaryimage","url":"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/14.gif","contentUrl":"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/14.gif"},{"@type":"BreadcrumbList","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/create-and-modify-hyperlinks\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.vskills.in\/certification\/tutorial\/"},{"@type":"ListItem","position":2,"name":"Create and Modify Hyperlinks"}]},{"@type":"WebSite","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#website","url":"https:\/\/www.vskills.in\/certification\/tutorial\/","name":"Tutorial","description":"Vskills - A initiative in elearning and certification","publisher":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.vskills.in\/certification\/tutorial\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#organization","name":"Vskills","url":"https:\/\/www.vskills.in\/certification\/tutorial\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/","url":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg","contentUrl":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg","width":73,"height":55,"caption":"Vskills"},"image":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/vskills.in\/","https:\/\/x.com\/vskills_in","https:\/\/www.linkedin.com\/company-beta\/1371554\/","https:\/\/www.youtube.com\/channel\/UCMWnscxPwRF_PqXo9B7q_Tw"]}]}},"_links":{"self":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/18744","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/comments?post=18744"}],"version-history":[{"count":6,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/18744\/revisions"}],"predecessor-version":[{"id":130064,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/18744\/revisions\/130064"}],"wp:attachment":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/media?parent=18744"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/categories?post=18744"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/tags?post=18744"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}