Hai Kesi, Menurut saya, formulanya ga bisa dicopy krn strukturnya berbeda.Kalo mau di copy value bisa pakai transpose atau formula. Salam,HK
Sent from Yahoo Mail on Android On Thu, Mar 30, 2017 at 11:23, KESI VIZZIANTI [email protected] [belajar-excel]<[email protected]> wrote: Selamat siang semauJika mengcopy sebuah formula ke cell di bawahnya, biasanya saya cukup sorot cell tersebut kemudian seret ke bawah sesuai yg kita inginkan. Pertanyaannya adakah cara untuk copy cell dengan formula untuk cell yang di sampingnya dst (vertical)? Terima kasih atas advisenya Salam.Kesi #yiv6024949552 #yiv6024949552 -- #yiv6024949552ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6024949552 #yiv6024949552ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6024949552 #yiv6024949552ygrp-mkp #yiv6024949552hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv6024949552 #yiv6024949552ygrp-mkp #yiv6024949552ads {margin-bottom:10px;}#yiv6024949552 #yiv6024949552ygrp-mkp .yiv6024949552ad {padding:0 0;}#yiv6024949552 #yiv6024949552ygrp-mkp .yiv6024949552ad p {margin:0;}#yiv6024949552 #yiv6024949552ygrp-mkp .yiv6024949552ad a {color:#0000ff;text-decoration:none;}#yiv6024949552 #yiv6024949552ygrp-sponsor #yiv6024949552ygrp-lc {font-family:Arial;}#yiv6024949552 #yiv6024949552ygrp-sponsor #yiv6024949552ygrp-lc #yiv6024949552hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6024949552 #yiv6024949552ygrp-sponsor #yiv6024949552ygrp-lc .yiv6024949552ad {margin-bottom:10px;padding:0 0;}#yiv6024949552 #yiv6024949552actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6024949552 #yiv6024949552activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6024949552 #yiv6024949552activity span {font-weight:700;}#yiv6024949552 #yiv6024949552activity span:first-child {text-transform:uppercase;}#yiv6024949552 #yiv6024949552activity span a {color:#5085b6;text-decoration:none;}#yiv6024949552 #yiv6024949552activity span span {color:#ff7900;}#yiv6024949552 #yiv6024949552activity span .yiv6024949552underline {text-decoration:underline;}#yiv6024949552 .yiv6024949552attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv6024949552 .yiv6024949552attach div a {text-decoration:none;}#yiv6024949552 .yiv6024949552attach img {border:none;padding-right:5px;}#yiv6024949552 .yiv6024949552attach label {display:block;margin-bottom:5px;}#yiv6024949552 .yiv6024949552attach label a {text-decoration:none;}#yiv6024949552 blockquote {margin:0 0 0 4px;}#yiv6024949552 .yiv6024949552bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv6024949552 .yiv6024949552bold a {text-decoration:none;}#yiv6024949552 dd.yiv6024949552last p a {font-family:Verdana;font-weight:700;}#yiv6024949552 dd.yiv6024949552last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6024949552 dd.yiv6024949552last p span.yiv6024949552yshortcuts {margin-right:0;}#yiv6024949552 div.yiv6024949552attach-table div div a {text-decoration:none;}#yiv6024949552 div.yiv6024949552attach-table {width:400px;}#yiv6024949552 div.yiv6024949552file-title a, #yiv6024949552 div.yiv6024949552file-title a:active, #yiv6024949552 div.yiv6024949552file-title a:hover, #yiv6024949552 div.yiv6024949552file-title a:visited {text-decoration:none;}#yiv6024949552 div.yiv6024949552photo-title a, #yiv6024949552 div.yiv6024949552photo-title a:active, #yiv6024949552 div.yiv6024949552photo-title a:hover, #yiv6024949552 div.yiv6024949552photo-title a:visited {text-decoration:none;}#yiv6024949552 div#yiv6024949552ygrp-mlmsg #yiv6024949552ygrp-msg p a span.yiv6024949552yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6024949552 .yiv6024949552green {color:#628c2a;}#yiv6024949552 .yiv6024949552MsoNormal {margin:0 0 0 0;}#yiv6024949552 o {font-size:0;}#yiv6024949552 #yiv6024949552photos div {float:left;width:72px;}#yiv6024949552 #yiv6024949552photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv6024949552 #yiv6024949552photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6024949552 #yiv6024949552reco-category {font-size:77%;}#yiv6024949552 #yiv6024949552reco-desc {font-size:77%;}#yiv6024949552 .yiv6024949552replbq {margin:4px;}#yiv6024949552 #yiv6024949552ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv6024949552 #yiv6024949552ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6024949552 #yiv6024949552ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6024949552 #yiv6024949552ygrp-mlmsg select, #yiv6024949552 input, #yiv6024949552 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv6024949552 #yiv6024949552ygrp-mlmsg pre, #yiv6024949552 code {font:115% monospace;}#yiv6024949552 #yiv6024949552ygrp-mlmsg * {line-height:1.22em;}#yiv6024949552 #yiv6024949552ygrp-mlmsg #yiv6024949552logo {padding-bottom:10px;}#yiv6024949552 #yiv6024949552ygrp-msg p a {font-family:Verdana;}#yiv6024949552 #yiv6024949552ygrp-msg p#yiv6024949552attach-count span {color:#1E66AE;font-weight:700;}#yiv6024949552 #yiv6024949552ygrp-reco #yiv6024949552reco-head {color:#ff7900;font-weight:700;}#yiv6024949552 #yiv6024949552ygrp-reco {margin-bottom:20px;padding:0px;}#yiv6024949552 #yiv6024949552ygrp-sponsor #yiv6024949552ov li a {font-size:130%;text-decoration:none;}#yiv6024949552 #yiv6024949552ygrp-sponsor #yiv6024949552ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv6024949552 #yiv6024949552ygrp-sponsor #yiv6024949552ov ul {margin:0;padding:0 0 0 8px;}#yiv6024949552 #yiv6024949552ygrp-text {font-family:Georgia;}#yiv6024949552 #yiv6024949552ygrp-text p {margin:0 0 1em 0;}#yiv6024949552 #yiv6024949552ygrp-text tt {font-size:120%;}#yiv6024949552 #yiv6024949552ygrp-vital ul li:last-child {border-right:none !important;}#yiv6024949552
