Ƙara Hyperlinks na Excel, Alamomin shafi, da Lissafi na Mailto

Yayi mamaki yadda za a kara hyperlinks, alamar shafi da / ko mailto links a Excel? Amsoshin suna daidai a nan.

Na farko, bari mu bayyana abin da muke nufi da kowane lokaci.

Za a iya danna hyperlink don tsalle daga wata takardar aiki zuwa shafin yanar gizon yanar gizo, kuma ana iya amfani dashi a cikin Excel don ba da dama da sauƙi zuwa wasu littattafan Excel.

Ana iya amfani da alamar shafi don ƙirƙirar haɗin zuwa wani yanki na musamman a cikin aikin aiki na yanzu ko zuwa ɗayan aiki daban daban a cikin wannan fayil na Excel ta amfani da nassoshi.

Shafin mailto yana haɗi zuwa adireshin imel. Danna kan hanyar linkto yana buɗe sabon sakon sako a cikin tsarin imel na tsoho sannan ya saka adireshin imel a baya bayanan ɗin zuwa cikin layin saƙo.

A cikin Excel, ana amfani da hyperlinks da alamun shafi don sauƙaƙa don masu amfani su kewaya tsakanin yankunan da suka shafi bayanai. Mailto links ya sa ya fi sauƙi don aika saƙon email ga mutum ko kungiyar. A duk lokuta:

• Ko wane irin nau'in haɗi ya halicce - hyperlink, alamar shafi, ko mailto link - an shigar da shi a cikin Shigar Hyperlink maganganun.
• Kamar yadda haɗewa a cikin shafukan yanar gizo, haɗin da ke cikin Excel an haɗa su zuwa rubutun maƙala da ke cikin sashin layi.
• Ƙara wannan rubutun rubutu kafin bude akwatin maganganu ya sauƙaƙe aikin aikin ƙirƙiri hanyar haɗi, amma za'a iya shigar da shi bayan an buɗe akwatin maganganu.

Bude Safiyar Rubutun Magana ta Hyperlink

Maɓallin haɗi don bude Siffar maganganun Hyperlink shine Ctrl + K a PC ko Umurnin K a Mac ɗin.

1. A cikin takardar aiki na Excel, danna kan tantanin halitta da ke dauke da hyperlink don sa shi tantanin halitta mai aiki.
2. Rubuta kalma don aiki a matsayin rubutu mai mahimmanci kamar "Lissafi" ko "Yuni_Sales.xlsx" kuma latsa maɓallin Shigar da ke keyboard.
3. Danna kan tantanin halitta tare da rubutun rubutu a karo na biyu.
4. Latsa ka riƙe ƙasa maɓallin Ctrl akan keyboard.
5. Latsa kuma saki harafin K a kan keyboard don bude Siffar maganganun Hyperlink .

Yadda za a Buɗe Shigar da Rubutun Magana ta Hyperlink Amfani da Saka Menu

1. A cikin takardar aiki na Excel, danna kan tantanin halitta da ke dauke da hyperlink don sa shi tantanin halitta mai aiki.
2. Shigar da rubutun rubutu a cikin tantanin salula kuma latsa maɓallin shigarwa akan keyboard.
3. Danna kan tantanin halitta tare da rubutun rubutu a karo na biyu.
4. Danna kan Saka a mashaya menu.
5. Danna kan maɓallin Hyperlink don bude Siffar maganganun Hyperlink .

Ƙara Hyperlinks a cikin Excel

Za ka iya kafa hyperlink don tsalle zuwa shafin yanar gizon ko zuwa fayil din Excel. Ga yadda:

Ƙara Hyperlink zuwa Shafin Yanar Gizo

1. Bude rubutun maganganu na Hyperlink ta amfani da daya daga cikin hanyoyin da aka tsara a sama.
2. Danna kan Shafukan yanar gizo ko Fayil din shafin.
3. A cikin adireshin Adireshin , rubuta cikakken adireshin URL.
4. Danna Ya yi don kammala hyperlink kuma rufe akwatin maganganu.
5. Rubutun mahimmanci a cikin saitunan aikin aiki ya kamata a yi launin shuɗi a launi kuma ya nuna cewa yana dauke da hyperlink. Duk lokacin da aka danna shi, zai bude shafin da aka sanya a cikin mai bincike na baya.

Ƙara Hyperlink zuwa fayil na Excel

1. Bude akwatin Siffar Hyperlink .
2. Danna kan Fayil na Gida ko Shafin Yanar Gizo .
3. Danna kan Zabi kuma bincika don samo sunan fayil na Excel. Danna sunan sunan fayil yana ƙara shi zuwa layin adireshin a cikin akwatin maganganu.
4. Danna Ya yi don kammala hyperlink kuma rufe akwatin maganganu.
5. Rubutun mahimmanci a cikin saitunan aikin aiki ya kamata a yi launin shuɗi a launi kuma ya nuna cewa yana dauke da hyperlink. Duk lokacin da aka danna shi, zai bude takarda na Excel.

Samar da Alamomin Alamar Shafin Farko na Same Excel

Alamar alama a Excel tana kama da hyperlink sai dai an yi amfani da shi don ƙirƙirar haɗin zuwa wani yanki a kan aikin aiki na yanzu ko kuma zuwa wani aiki daban daban a cikin wannan fayil na Excel.

Duk da yake hyperlinks yi amfani da sunayen fayilolin don ƙirƙirar haɗin zuwa wasu fayilolin Excel, alamar shafi suna amfani da bayanan salula da sunayen rubutu don ƙirƙirar haɗi.

Yadda za a ƙirƙirar alamomin zuwa Same Shafin

Misali na gaba ya haifar da alamar shafi zuwa wani wuri daban a cikin takardar aikin Excel guda.

1. Rubuta sunan a cikin tantanin halitta wanda zai yi aiki a matsayin rubutu na alamar alamar shafi kuma latsa Shigar .
2. Latsa wannan tantanin halitta don sa shi tantanin halitta mai aiki.
3. Bude akwatin Siffar Hyperlink .
4. Danna kan Wannan Jaridar ta .
5. A karkashin Rubutun tantanin salula , shigar da tantanin halitta zuwa wani wuri dabam a kan takardun aiki ɗaya - irin su "Z100."
6. Danna Ya yi don kammala alamar shafi kuma rufe akwatin maganganu.
7. Rubutun rubutu a cikin saitunan aikin aiki ya kamata a yi launin shuɗi a launi kuma ya nuna cewa yana da alamar shafi.
8. Danna kan alamar shafi kuma mai siginan kwamfuta mai aiki yana motsa zuwa tantanin tantanin halitta wanda aka shigar don alamar shafi.

Samar da alamun shafi zuwa shafukan aiki daban

Samar da alamar shafi zuwa ɗayan ayyuka daban-daban a cikin wannan fayil na Excel ko ɗawainiyar yana da ƙarin mataki na gano aikin aiwatarwa don alamun shafi. Kayan aiki na sake sabuntawa zai iya sauƙaƙe don ƙirƙirar alamun shafi cikin fayiloli tare da babban adadin ayyukan aiki.

1. Bude littafi na Excel da yawa-takarda ko ƙara ƙarin zanen gado zuwa takardar fayil daya.
2. A ɗaya daga cikin zanen gado, rubuta sunan a cikin tantanin halitta don aiki a matsayin rubutu na alamar alamar shafi.
3. Latsa wannan tantanin halitta don sa shi tantanin halitta mai aiki.
4. Bude akwatin Siffar Hyperlink .
5. Danna kan Wannan Jaridar ta .
6. Shigar da tantancewar salula a cikin filin karkashin Rubuta a cikin tantanin halitta .
7. A cikin Ko kuma zaɓi wuri a cikin wannan filin fayil , danna sunan sunan fayil na makaman. Fusoshin da ba a san shi ba suna da suna Sheet1, Sheet2, Sheet3 da sauransu.
8. Danna Ya yi don kammala alamar shafi kuma rufe akwatin maganganu.
9. Rubutun rubutu a cikin saitunan aikin aiki ya kamata a yi launin shuɗi a launi kuma ya nuna cewa yana da alamar shafi.
10. Danna kan alamar shafi kuma mai siginan kwamfuta mai aiki ya kamata ya motsa zuwa tantancewar salula a kan takardar da aka shigar don alamar shafi.

Saka Jagorar Mai Saukowa A cikin Fayil na Excel

Ƙara bayanin lamba zuwa takardar aiki na Excel yana sa sauƙi don aika imel daga cikin takardun.

1. Rubuta suna a cikin tantanin halitta wanda zai yi aiki a matsayin rubutu na mahimmanci don link link. Latsa Shigar .
2. Latsa wannan tantanin halitta don sa shi tantanin halitta mai aiki .
3. Bude akwatin Siffar Hyperlink .
4. Danna kan adireshin Imel ɗin .
5. A cikin adireshin imel ɗin , shigar da adireshin imel na mai karɓa na mahaɗin. An shigar da wannan adireshin a cikin Zaman layi na sabon imel ɗin lokacin da aka danna mahaɗin.
6. A ƙarƙashin Sashin Rubutun , shigar da batun don email. An shigar da wannan rubutu cikin layi a cikin sabon saƙo.
7. Danna Ya yi don kammala link linkto kuma rufe akwatin maganganu.
8. Rubutun mahimmanci a cikin saitunan aikin aiki ya kamata a yi launin shuɗi a launi kuma ya nuna cewa yana dauke da hyperlink.
9. Danna kan mahaɗin mailto, kuma shirin imel na asali ya bude sabon saƙo tare da adireshin da rubutu da aka shigar.

Ana cire Hyperlink ba tare da cire Rubutun Maganin ba

Lokacin da ka daina buƙatar hyperlink, zaka iya cire bayanin haɗin yanar gizo ba tare da cire rubutun da yayi aiki a matsayin alamar ba.

1. Matsayi maɓallin linzamin kwamfuta a kan hyperlink da za a cire. Yawan maɓallin arrow ya canza zuwa alama ta hannun.
2. Danna-dama a kan rubutun rubutun hyperlink don buɗe menu da aka sauke shi.
3. Danna kan cire Hyperlink a cikin menu.
4. Ya kamata a cire launi mai launi da layin layi daga rubutun da ke nuna cewa an cire hyperlink.