[belajar-excel] Copy cell ke samping [1 Attachment]

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

[belajar-excel] Copy cell ke samping [1 Attachment]

Milis Belajar Excel mailing list
Selamat siang semau
Jika 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

copy ke samping.xlsx (20K) Download Attachment
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [belajar-excel] Copy cell ke samping

Milis Belajar Excel mailing list
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 [hidden email] [belajar-excel]<[hidden email]> 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  
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [belajar-excel] Copy cell ke samping

Milis Belajar Excel mailing list
Dear All
Ternyata sudah ketemu jawabannya..
Pakai Paste special, Formula and number format> transpose,
Thanks


2017-03-30 11:41 GMT+07:00 hendrik karnadi [hidden email]
[belajar-excel] <[hidden email]>:


>
>
> 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
> <https://overview.mail.yahoo.com/mobile/?.src=Android>
>
>
>
> Selamat siang semau
> Jika 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
>
>
>
>






--
*Kesi Vizzianti*
Email   [hidden email]
Phone  0812-77176028
Blog     http://kesivizzianti.blogspot.com/
Twitter  KesiVizzianti <https://twitter.com/KesiVizzianti>
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [belajar-excel] Copy cell ke samping [1 Attachment]

Milis Belajar Excel mailing list
Dear All,


Semoga bisa membantu


Rgd's


On 30/03/17 14:45, KESI VIZZIANTI [hidden email]
[belajar-excel] wrote:

> Dear All
> Ternyata sudah ketemu jawabannya..
> Pakai Paste special, Formula and number format> transpose,
> Thanks
>
> 2017-03-30 11:41 GMT+07:00 hendrik karnadi [hidden email]
> <mailto:[hidden email]> [belajar-excel]
> <[hidden email] <mailto:[hidden email]>>:
>
>     Hai Kesi,
>
>     Menurut saya, formulanya ga bisa dicopy krn strukturnya berbeda.
>     Kalo mau di copy value bisa pakai transpose atau formula.
>
>     Salam,
>     HK
>



copy ke samping.xlsx (18K) Download Attachment
Loading...