bisa manfaatkansaja fungsi hyperlink,
ketikan nama sheet yang akan di buka pada cell yang akan di link kan, masih
pada cell yang sama, masuk ke menu insert pilih links hyperlink, setelah muncul
popup pilih place in this document( sebelah kiri tengah2 ), setelah itu pilih
sheet yang ingin dibuka. br,
odong nando
Dari: "riansutarsa [email protected] [belajar-excel]"
<[email protected]>
Kepada: [email protected]
Dikirim: Jumat, 17 Juni 2016 20:27
Judul: [belajar-excel] Link Cell ke Sheet
assalamu'alaikum para master mohon pencerahannya adakah formula/rumus
membuat sebuah cell yang nge-link ke sheet (yang namanya sama dengan cell) yang
dimaksud
terimakasih sebelumnya.
wassalam
#yiv1216212534 #yiv1216212534 -- #yiv1216212534ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1216212534
#yiv1216212534ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1216212534
#yiv1216212534ygrp-mkp #yiv1216212534hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv1216212534 #yiv1216212534ygrp-mkp #yiv1216212534ads
{margin-bottom:10px;}#yiv1216212534 #yiv1216212534ygrp-mkp .yiv1216212534ad
{padding:0 0;}#yiv1216212534 #yiv1216212534ygrp-mkp .yiv1216212534ad p
{margin:0;}#yiv1216212534 #yiv1216212534ygrp-mkp .yiv1216212534ad a
{color:#0000ff;text-decoration:none;}#yiv1216212534 #yiv1216212534ygrp-sponsor
#yiv1216212534ygrp-lc {font-family:Arial;}#yiv1216212534
#yiv1216212534ygrp-sponsor #yiv1216212534ygrp-lc #yiv1216212534hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1216212534
#yiv1216212534ygrp-sponsor #yiv1216212534ygrp-lc .yiv1216212534ad
{margin-bottom:10px;padding:0 0;}#yiv1216212534 #yiv1216212534actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1216212534
#yiv1216212534activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1216212534
#yiv1216212534activity span {font-weight:700;}#yiv1216212534
#yiv1216212534activity span:first-child
{text-transform:uppercase;}#yiv1216212534 #yiv1216212534activity span a
{color:#5085b6;text-decoration:none;}#yiv1216212534 #yiv1216212534activity span
span {color:#ff7900;}#yiv1216212534 #yiv1216212534activity span
.yiv1216212534underline {text-decoration:underline;}#yiv1216212534
.yiv1216212534attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv1216212534 .yiv1216212534attach div a
{text-decoration:none;}#yiv1216212534 .yiv1216212534attach img
{border:none;padding-right:5px;}#yiv1216212534 .yiv1216212534attach label
{display:block;margin-bottom:5px;}#yiv1216212534 .yiv1216212534attach label a
{text-decoration:none;}#yiv1216212534 blockquote {margin:0 0 0
4px;}#yiv1216212534 .yiv1216212534bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv1216212534
.yiv1216212534bold a {text-decoration:none;}#yiv1216212534 dd.yiv1216212534last
p a {font-family:Verdana;font-weight:700;}#yiv1216212534 dd.yiv1216212534last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1216212534
dd.yiv1216212534last p span.yiv1216212534yshortcuts
{margin-right:0;}#yiv1216212534 div.yiv1216212534attach-table div div a
{text-decoration:none;}#yiv1216212534 div.yiv1216212534attach-table
{width:400px;}#yiv1216212534 div.yiv1216212534file-title a, #yiv1216212534
div.yiv1216212534file-title a:active, #yiv1216212534
div.yiv1216212534file-title a:hover, #yiv1216212534 div.yiv1216212534file-title
a:visited {text-decoration:none;}#yiv1216212534 div.yiv1216212534photo-title a,
#yiv1216212534 div.yiv1216212534photo-title a:active, #yiv1216212534
div.yiv1216212534photo-title a:hover, #yiv1216212534
div.yiv1216212534photo-title a:visited {text-decoration:none;}#yiv1216212534
div#yiv1216212534ygrp-mlmsg #yiv1216212534ygrp-msg p a
span.yiv1216212534yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1216212534
.yiv1216212534green {color:#628c2a;}#yiv1216212534 .yiv1216212534MsoNormal
{margin:0 0 0 0;}#yiv1216212534 o {font-size:0;}#yiv1216212534
#yiv1216212534photos div {float:left;width:72px;}#yiv1216212534
#yiv1216212534photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv1216212534
#yiv1216212534photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1216212534
#yiv1216212534reco-category {font-size:77%;}#yiv1216212534
#yiv1216212534reco-desc {font-size:77%;}#yiv1216212534 .yiv1216212534replbq
{margin:4px;}#yiv1216212534 #yiv1216212534ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv1216212534 #yiv1216212534ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1216212534
#yiv1216212534ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1216212534
#yiv1216212534ygrp-mlmsg select, #yiv1216212534 input, #yiv1216212534 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv1216212534
#yiv1216212534ygrp-mlmsg pre, #yiv1216212534 code {font:115%
monospace;}#yiv1216212534 #yiv1216212534ygrp-mlmsg *
{line-height:1.22em;}#yiv1216212534 #yiv1216212534ygrp-mlmsg #yiv1216212534logo
{padding-bottom:10px;}#yiv1216212534 #yiv1216212534ygrp-msg p a
{font-family:Verdana;}#yiv1216212534 #yiv1216212534ygrp-msg
p#yiv1216212534attach-count span {color:#1E66AE;font-weight:700;}#yiv1216212534
#yiv1216212534ygrp-reco #yiv1216212534reco-head
{color:#ff7900;font-weight:700;}#yiv1216212534 #yiv1216212534ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv1216212534 #yiv1216212534ygrp-sponsor
#yiv1216212534ov li a {font-size:130%;text-decoration:none;}#yiv1216212534
#yiv1216212534ygrp-sponsor #yiv1216212534ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv1216212534
#yiv1216212534ygrp-sponsor #yiv1216212534ov ul {margin:0;padding:0 0 0
8px;}#yiv1216212534 #yiv1216212534ygrp-text
{font-family:Georgia;}#yiv1216212534 #yiv1216212534ygrp-text p {margin:0 0 1em
0;}#yiv1216212534 #yiv1216212534ygrp-text tt {font-size:120%;}#yiv1216212534
#yiv1216212534ygrp-vital ul li:last-child {border-right:none
!important;}#yiv1216212534
