Home معادلات إكسيل

شرح صيغة الدالة HYPERLINK في برنامج مايكروسوفت Excel

October 25, 2021

شرح صيغة الدالة HYPERLINK في برنامج مايكروسوفت Excel

شرح صيغة الدالة HYPERLINK في برنامج مايكروسوفت Excel

في هذه التدوينة سنتعرف على كيفية استخدام الدالة HYPERLINK في برنامج مايكروسوفت Excel.

تعريف الدالة HYPERLINK :

تقوم الدالة HYPERLINK بفتح ملف أو الذهاب إلى موقع ويب أو إرسال بريد الكتروني من خلال الضغط على رابط .

تحتوي الدالة HYPERLINK على وسائط أو معاملات :

link_location : الملف الذي تريد فتحه أو عنوان الموقع الذي تريد الذهاب إليه أو البريد الالكتروني الذي تريد إرسال رساله له .

[friendly_name] : نص الرابط

أمثلة على استخدام الدالة HYPERLINK :

في المثال التالي ستقوم الدالة HYPERLINK بالذهاب إلى موقع https://www.facebook.com عند الضغط على الرابط Facbook.

شرح صيغة الدالة HYPERLINK في برنامج مايكروسوفت Excel

في المثال التالي ستقوم الدالة HYPERLINK بإرسال بريد الكتروني إلى cocharli86@gmail.com عند الضغط على الرابط Contact Us.

شرح صيغة الدالة HYPERLINK في برنامج مايكروسوفت Excel

في المثال التالي ستقوم الدالة HYPERLINK بفتح ملف Excel اسمه TDB موجود في المجلد Desktop في الجزء C عند الضغط على الرابط C:\Users\Oussama\Desktop\TDB.xlsx.

شرح صيغة الدالة HYPERLINK في برنامج مايكروسوفت Excel

في المثال التالي ستقوم الدالة HYPERLINK بفتح ملف Excel اسمه TDB موجود في المجلد Desktop في الجزء C عند الضغط على الرابط TABLEAU DE BORD.

شرح صيغة الدالة HYPERLINK في برنامج مايكروسوفت Excel

في المثال التالي ستقوم الدالة HYPERLINK بفتح ملف Excel اسمه Java عند الضغط على الرابط Francais Book

لاحظ عدم كتابة مسار الملف كاملا وهذا معناه أن هذا المسار موجود في نفس المكان الموجود فيه ملف العمل الذي نعمل عليه حاليا , أي أن :

اذا كان ملف العمل الحالي موجود في المسار C:\User

فإن المسار المكتوب في المعادلة كاملا هوC:\Users\Oussama\Desktop\guide_bonne-pratiq-ling.pdf .

شرح صيغة الدالة HYPERLINK في برنامج مايكروسوفت Excel

Tags معادلات إكسيل

Latest articles from : معادلات إكسيل

Comments

2 comments

Anonymous December 3, 2022 at 9:49 PM

Atridage modified Palmgren’s equation to take the effect of the lubricating oil move into consideration. Stein and Tu modified Palmgren’s equation to think about|to contemplate} the effect of the induced thermal preload. Shapeoko works with most free CNC software program, but it Direct CNC additionally includes our Carbide Create so there's nothing extra to buy. Shapeoko can reduce any type of wood from pine, to MDF, to exhausting woods like white oak.
replydelete
Anonymous December 7, 2022 at 2:50 PM

Guests who make qualifying arms on the Party Pit tables shall be eligible for prizes. Prizes embody merchandise and/or gaming cheques valued a lot as} $25. We prefer to hold issues recent and full of cash and prizes, so we're all the time cooking up exciting methods for you to can} win big. Take advantage of mychoice® promotions and different offers at Hollywood Casino thecasinosource.com Bangor and you would win money, superb prizes, Free SlotPlay® and rather more. Check again often, so that you by no means miss one tasty chunk of action.
replydelete

Post a Comment

Reading Mode :

Font Size

+

16

-

lines height

+

2

-

window['__wavt'] = 'AOuZoY4mM1UEVMasXpzUw66qfPPgrj_AXg:1733717488605';_WidgetManager._Init('//www.blogger.com/rearrange?blogID\x3d7172743834752994373','//www.practiceexcel-365.com/2021/10/HYPERLINK%20.html','7172743834752994373'); _WidgetManager._SetDataContext([{'name': 'blog', 'data': {'blogId': '7172743834752994373', 'title': 'Practice Excel365 | Free Excel Courses', 'url': 'https://www.practiceexcel-365.com/2021/10/HYPERLINK%20.html', 'canonicalUrl': 'https://www.practiceexcel-365.com/2021/10/HYPERLINK%20.html', 'homepageUrl': 'https://www.practiceexcel-365.com/', 'searchUrl': 'https://www.practiceexcel-365.com/search', 'canonicalHomepageUrl': 'https://www.practiceexcel-365.com/', 'blogspotFaviconUrl': 'https://www.practiceexcel-365.com/favicon.ico', 'bloggerUrl': 'https://www.blogger.com', 'hasCustomDomain': true, 'httpsEnabled': true, 'enabledCommentProfileImages': true, 'gPlusViewType': 'FILTERED_POSTMOD', 'adultContent': false, 'analyticsAccountNumber': '', 'encoding': 'UTF-8', 'locale': 'en', 'localeUnderscoreDelimited': 'en', 'languageDirection': 'ltr', 'isPrivate': false, 'isMobile': false, 'isMobileRequest': false, 'mobileClass': '', 'isPrivateBlog': false, 'isDynamicViewsAvailable': true, 'feedLinks': '\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22Practice Excel365 | Free Excel Courses - Atom\x22 href\x3d\x22https://www.practiceexcel-365.com/feeds/posts/default\x22 /\x3e\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/rss+xml\x22 title\x3d\x22Practice Excel365 | Free Excel Courses - RSS\x22 href\x3d\x22https://www.practiceexcel-365.com/feeds/posts/default?alt\x3drss\x22 /\x3e\n\x3clink rel\x3d\x22service.post\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22Practice Excel365 | Free Excel Courses - Atom\x22 href\x3d\x22https://www.blogger.com/feeds/7172743834752994373/posts/default\x22 /\x3e\n\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22Practice Excel365 | Free Excel Courses - Atom\x22 href\x3d\x22https://www.practiceexcel-365.com/feeds/902164268060289919/comments/default\x22 /\x3e\n', 'meTag': '', 'adsenseClientId': 'ca-pub-6657372632750930', 'adsenseHostId': 'ca-host-pub-1556223355139109', 'adsenseHasAds': true, 'adsenseAutoAds': true, 'boqCommentIframeForm': true, 'loginRedirectParam': '', 'view': '', 'dynamicViewsCommentsSrc': '//www.blogblog.com/dynamicviews/4224c15c4e7c9321/js/comments.js', 'dynamicViewsScriptSrc': '//www.blogblog.com/dynamicviews/36eb93a0ea1bb211', 'plusOneApiSrc': 'https://apis.google.com/js/platform.js', 'disableGComments': true, 'interstitialAccepted': false, 'sharing': {'platforms': [{'name': 'Get link', 'key': 'link', 'shareMessage': 'Get link', 'target': ''}, {'name': 'Facebook', 'key': 'facebook', 'shareMessage': 'Share to Facebook', 'target': 'facebook'}, {'name': 'BlogThis!', 'key': 'blogThis', 'shareMessage': 'BlogThis!', 'target': 'blog'}, {'name': 'X', 'key': 'twitter', 'shareMessage': 'Share to X', 'target': 'twitter'}, {'name': 'Pinterest', 'key': 'pinterest', 'shareMessage': 'Share to Pinterest', 'target': 'pinterest'}, {'name': 'Email', 'key': 'email', 'shareMessage': 'Email', 'target': 'email'}], 'disableGooglePlus': true, 'googlePlusShareButtonWidth': 0, 'googlePlusBootstrap': '\x3cscript type\x3d\x22text/javascript\x22\x3ewindow.___gcfg \x3d {\x27lang\x27: \x27en\x27};\x3c/script\x3e'}, 'hasCustomJumpLinkMessage': true, 'jumpLinkMessage': 'Read more \xbb', 'pageType': 'item', 'postId': '902164268060289919', 'postImageThumbnailUrl': 'https://blogger.googleusercontent.com/img/a/AVvXsEgxb8_rR1HvSPAd9WWt4QUdnEOW9zflLP1-Y87peP0gygUHhnJYqQ5koO-4DCmJgdqL-haz_DYdFkK6kNAr2lFTonNkiYl4__M2nae4un57Bx5efW6oqF3VsAUqhFWFaQJYx_1K9zVIumE6hujqHFre1kjrasGYEFtZfo6ZbgPl0qNU5GknIOl2VCZF\x3ds72-w640-c-h452', 'postImageUrl': 'https://blogger.googleusercontent.com/img/a/AVvXsEgxb8_rR1HvSPAd9WWt4QUdnEOW9zflLP1-Y87peP0gygUHhnJYqQ5koO-4DCmJgdqL-haz_DYdFkK6kNAr2lFTonNkiYl4__M2nae4un57Bx5efW6oqF3VsAUqhFWFaQJYx_1K9zVIumE6hujqHFre1kjrasGYEFtZfo6ZbgPl0qNU5GknIOl2VCZF\x3dw640-h452', 'pageName': '\u0634\u0631\u062d \u0635\u064a\u063a\u0629 \u0627\u0644\u062f\u0627\u0644\u0629 HYPERLINK \u0641\u064a \u0628\u0631\u0646\u0627\u0645\u062c \u0645\u0627\u064a\u0643\u0631\u0648\u0633\u0648\u0641\u062a Excel', 'pageTitle': 'Practice Excel365 | Free Excel Courses: \u0634\u0631\u062d \u0635\u064a\u063a\u0629 \u0627\u0644\u062f\u0627\u0644\u0629 HYPERLINK \u0641\u064a \u0628\u0631\u0646\u0627\u0645\u062c \u0645\u0627\u064a\u0643\u0631\u0648\u0633\u0648\u0641\u062a Excel', 'metaDescription': '\u062a\u0639\u0631\u064a\u0641 \u0627\u0644\u062f\u0627\u0644\u0629 HYPERLINK :\n\n \u062a\u0642\u0648\u0645 \u0627\u0644\u062f\u0627\u0644\u0629 HYPERLINK \u0628\u0641\u062a\u062d \u0645\u0644\u0641 \u0623\u0648 \u0627\u0644\u0630\u0647\u0627\u0628 \u0625\u0644\u0649 \u0645\u0648\u0642\u0639 \u0648\u064a\u0628 \u0623\u0648 \u0625\u0631\u0633\u0627\u0644 \u0628\u0631\u064a\u062f \u0627\u0644\u0643\u062a\u0631\u0648\u0646\u064a \u0645\u0646 \u062e\u0644\u0627\u0644 \u0627\u0644\u0636\u063a\u0637 \u0639\u0644\u0649 \u0631\u0627\u0628\u0637 '}}, {'name': 'features', 'data': {}}, {'name': 'messages', 'data': {'edit': 'Edit', 'linkCopiedToClipboard': 'Link copied to clipboard!', 'ok': 'Ok', 'postLink': 'Post Link'}}, {'name': 'template', 'data': {'name': 'custom', 'localizedName': 'Custom', 'isResponsive': true, 'isAlternateRendering': false, 'isCustom': true}}, {'name': 'view', 'data': {'classic': {'name': 'classic', 'url': '?view\x3dclassic'}, 'flipcard': {'name': 'flipcard', 'url': '?view\x3dflipcard'}, 'magazine': {'name': 'magazine', 'url': '?view\x3dmagazine'}, 'mosaic': {'name': 'mosaic', 'url': '?view\x3dmosaic'}, 'sidebar': {'name': 'sidebar', 'url': '?view\x3dsidebar'}, 'snapshot': {'name': 'snapshot', 'url': '?view\x3dsnapshot'}, 'timeslide': {'name': 'timeslide', 'url': '?view\x3dtimeslide'}, 'isMobile': false, 'title': '\u0634\u0631\u062d \u0635\u064a\u063a\u0629 \u0627\u0644\u062f\u0627\u0644\u0629 HYPERLINK \u0641\u064a \u0628\u0631\u0646\u0627\u0645\u062c \u0645\u0627\u064a\u0643\u0631\u0648\u0633\u0648\u0641\u062a Excel', 'description': '\u062a\u0639\u0631\u064a\u0641 \u0627\u0644\u062f\u0627\u0644\u0629 HYPERLINK :\n\n \u062a\u0642\u0648\u0645 \u0627\u0644\u062f\u0627\u0644\u0629 HYPERLINK \u0628\u0641\u062a\u062d \u0645\u0644\u0641 \u0623\u0648 \u0627\u0644\u0630\u0647\u0627\u0628 \u0625\u0644\u0649 \u0645\u0648\u0642\u0639 \u0648\u064a\u0628 \u0623\u0648 \u0625\u0631\u0633\u0627\u0644 \u0628\u0631\u064a\u062f \u0627\u0644\u0643\u062a\u0631\u0648\u0646\u064a \u0645\u0646 \u062e\u0644\u0627\u0644 \u0627\u0644\u0636\u063a\u0637 \u0639\u0644\u0649 \u0631\u0627\u0628\u0637 ', 'featuredImage': 'https://blogger.googleusercontent.com/img/a/AVvXsEgxb8_rR1HvSPAd9WWt4QUdnEOW9zflLP1-Y87peP0gygUHhnJYqQ5koO-4DCmJgdqL-haz_DYdFkK6kNAr2lFTonNkiYl4__M2nae4un57Bx5efW6oqF3VsAUqhFWFaQJYx_1K9zVIumE6hujqHFre1kjrasGYEFtZfo6ZbgPl0qNU5GknIOl2VCZF\x3dw640-h452', 'url': 'https://www.practiceexcel-365.com/2021/10/HYPERLINK%20.html', 'type': 'item', 'isSingleItem': true, 'isMultipleItems': false, 'isError': false, 'isPage': false, 'isPost': true, 'isHomepage': false, 'isArchive': false, 'isLabelSearch': false, 'postId': 902164268060289919}}, {'name': 'widgets', 'data': [{'title': 'BlogArchive', 'type': 'BlogArchive', 'sectionId': 'sitting', 'id': 'BlogArchive400'}, {'title': 'BlogLabels', 'type': 'Label', 'sectionId': 'sitting', 'id': 'Label400'}, {'title': 'Pages', 'type': 'PageList', 'sectionId': 'pages', 'id': 'PageList1'}, {'title': '\u0645\u0648\u0627\u0642\u0639 \u0627\u0644\u062a\u0648\u0627\u0635\u0644 \u0627\u0644\u0625\u062c\u062a\u0645\u0627\u0639\u064a', 'type': 'LinkList', 'sectionId': 'topsocialL', 'id': 'LinkList3'}, {'title': 'Practice Excel365 | Free Excel Courses (Header)', 'type': 'Header', 'sectionId': 'logo', 'id': 'Header1'}, {'title': '\u0627\u0644\u0642\u0627\u0626\u0645\u0629 \u0627\u0644\u0631\u0626\u064a\u0633\u064a\u0629', 'type': 'LinkList', 'sectionId': 'menu', 'id': 'LinkList22'}, {'title': '\u0627\u0639\u0644\u0627\u0646 \u0627\u0633\u0641\u0644 \u0627\u0644\u0642\u0627\u0626\u0645\u0629 \u0627\u0644\u0639\u0644\u0648\u064a\u0629 \u0644\u0644\u062d\u0627\u0633\u0648\u0628', 'type': 'HTML', 'sectionId': 'Topa3lan-sc', 'id': 'HTML100'}, {'title': '\u0627\u0639\u0644\u0627\u0646 \u0627\u0633\u0641\u0644 \u0627\u0644\u0642\u0627\u0626\u0645\u0629 \u0627\u0644\u0639\u0644\u0648\u064a\u0629 \u0644\u0644\u0647\u0627\u062a\u0641', 'type': 'HTML', 'sectionId': 'Topa3lan-sc2', 'id': 'HTML101'}, {'title': 'Blog Posts', 'type': 'Blog', 'sectionId': 'Tempnec', 'id': 'Blog1', 'posts': [{'id': '902164268060289919', 'title': '\u0634\u0631\u062d \u0635\u064a\u063a\u0629 \u0627\u0644\u062f\u0627\u0644\u0629 HYPERLINK \u0641\u064a \u0628\u0631\u0646\u0627\u0645\u062c \u0645\u0627\u064a\u0643\u0631\u0648\u0633\u0648\u0641\u062a Excel', 'featuredImage': 'https://blogger.googleusercontent.com/img/a/AVvXsEgxb8_rR1HvSPAd9WWt4QUdnEOW9zflLP1-Y87peP0gygUHhnJYqQ5koO-4DCmJgdqL-haz_DYdFkK6kNAr2lFTonNkiYl4__M2nae4un57Bx5efW6oqF3VsAUqhFWFaQJYx_1K9zVIumE6hujqHFre1kjrasGYEFtZfo6ZbgPl0qNU5GknIOl2VCZF\x3dw640-h452', 'showInlineAds': false}], 'headerByline': {'regionName': 'header1', 'items': [{'name': 'share', 'label': ''}, {'name': 'timestamp', 'label': '-'}]}, 'footerBylines': [{'regionName': 'footer1', 'items': [{'name': 'comments', 'label': 'comments'}, {'name': 'icons', 'label': ''}]}, {'regionName': 'footer2', 'items': [{'name': 'labels', 'label': ''}]}], 'allBylineItems': [{'name': 'share', 'label': ''}, {'name': 'timestamp', 'label': '-'}, {'name': 'comments', 'label': 'comments'}, {'name': 'icons', 'label': ''}, {'name': 'labels', 'label': ''}]}, {'title': '\u0623\u0639\u0644\u0627\u0646 \u0627\u0648\u0644 \u0627\u0644\u0645\u0648\u0636\u0648\u0639', 'type': 'HTML', 'sectionId': 'PostA3lan', 'id': 'HTML201'}, {'title': '\u0627\u0639\u0644\u0627\u0646 \u0628\u0639\u062f \u0643\u0644 \u0639\u0646\u0648\u0627\u0646 [\u0645\u062a\u0643\u0631\u0631]', 'type': 'HTML', 'sectionId': 'PostA3lan2', 'id': 'HTML222'}, {'title': '\u0627\u0639\u0644\u0627\u0646 \u0628\u0639\u062f \u0643\u0644 \u0641\u0642\u0631\u0629 [\u0645\u062a\u0643\u0631\u0631]', 'type': 'HTML', 'sectionId': 'PostA3lan2', 'id': 'HTML223'}, {'title': 'Contact Form', 'type': 'ContactForm', 'sectionId': 'AddOns', 'id': 'ContactForm200'}, {'title': '\u0645\u0648\u0627\u0642\u0639 \u0627\u0644\u062a\u0648\u0627\u0635\u0644 \u0627\u0644\u0625\u062c\u062a\u0645\u0627\u0639\u064a', 'type': 'LinkList', 'sectionId': 'sidepar', 'id': 'LinkList4'}, {'title': 'Fiver', 'type': 'HTML', 'sectionId': 'Postnw6', 'id': 'HTML3'}, {'title': '\u0645\u0648\u0627\u0642\u0639 \u0627\u0644\u062a\u0648\u0627\u0635\u0644 \u0627\u0644\u0625\u062c\u062a\u0645\u0627\u0639\u064a', 'type': 'LinkList', 'sectionId': 'footer-social', 'id': 'LinkList2'}]}]); _WidgetManager._RegisterWidget('_BlogArchiveView', new _WidgetInfo('BlogArchive400', 'sitting', document.getElementById('BlogArchive400'), {'languageDirection': 'ltr', 'loadingMessage': 'Loading\x26hellip;'}, 'displayModeFull')); _WidgetManager._RegisterWidget('_LabelView', new _WidgetInfo('Label400', 'sitting', document.getElementById('Label400'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_PageListView', new _WidgetInfo('PageList1', 'pages', document.getElementById('PageList1'), {'title': 'Pages', 'links': [{'isCurrentPage': false, 'href': 'http://www.practiceexcel-365.com/', 'title': 'Home'}, {'isCurrentPage': false, 'href': 'https://www.practiceexcel-365.com/p/privacy-policy.html', 'id': '9039293699451073275', 'title': 'Privacy Policy'}, {'isCurrentPage': false, 'href': 'https://www.practiceexcel-365.com/p/who-are-we.html', 'id': '3848084781500635721', 'title': 'Who We Are'}, {'isCurrentPage': false, 'href': 'https://www.practiceexcel-365.com/p/contact-us.html', 'id': '5696516493396065643', 'title': 'Contact Us'}, {'isCurrentPage': false, 'href': 'https://www.practiceexcel-365.com/p/blog-page.html', 'id': '4724947008150640905', 'title': 'Frequently Asked Questions'}], 'mobile': false, 'showPlaceholder': true, 'hasCurrentPage': false}, 'displayModeFull')); _WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList3', 'topsocialL', document.getElementById('LinkList3'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HeaderView', new _WidgetInfo('Header1', 'logo', document.getElementById('Header1'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList22', 'menu', document.getElementById('LinkList22'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML100', 'Topa3lan-sc', document.getElementById('HTML100'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML101', 'Topa3lan-sc2', document.getElementById('HTML101'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_BlogView', new _WidgetInfo('Blog1', 'Tempnec', document.getElementById('Blog1'), {'cmtInteractionsEnabled': false, 'lightboxEnabled': true, 'lightboxModuleUrl': 'https://www.blogger.com/static/v1/jsbin/2385764300-lbx.js', 'lightboxCssUrl': 'https://www.blogger.com/static/v1/v-css/1964470060-lightbox_bundle.css'}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML201', 'PostA3lan', document.getElementById('HTML201'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML222', 'PostA3lan2', document.getElementById('HTML222'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML223', 'PostA3lan2', document.getElementById('HTML223'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_ContactFormView', new _WidgetInfo('ContactForm200', 'AddOns', document.getElementById('ContactForm200'), {'contactFormMessageSendingMsg': 'Sending...', 'contactFormMessageSentMsg': 'Your message has been sent.', 'contactFormMessageNotSentMsg': 'Message could not be sent. Please try again later.', 'contactFormInvalidEmailMsg': 'A valid email address is required.', 'contactFormEmptyMessageMsg': 'Message field cannot be empty.', 'title': 'Contact Form', 'blogId': '7172743834752994373', 'contactFormNameMsg': 'Name', 'contactFormEmailMsg': 'Email', 'contactFormMessageMsg': 'Message', 'contactFormSendMsg': 'Send', 'contactFormToken': 'AOuZoY5II1EYtHsmXr8_Eeq2zYZ19_1_zQ:1733717488605', 'submitUrl': 'https://www.blogger.com/contact-form.do'}, 'displayModeFull')); _WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList4', 'sidepar', document.getElementById('LinkList4'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML3', 'Postnw6', document.getElementById('HTML3'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList2', 'footer-social', document.getElementById('LinkList2'), {}, 'displayModeFull'));