Bls: [belajar-excel] insert row kosong
boz kid,hehe jadi malu... kenapa di 2 kolom kok jadi berhasiltp ya sudah lah ga pp, saya bisa narik 6 kolom berikutnya menggunakan id yang ada... trimakasih boz kid... br, odong nando Dari: "'Mr. Kid' mr.nm...@gmail.com [belajar-excel]" Kepada: BeExcel Dikirim: Senin, 16 April 2018 22:29 Judul: Re: [belajar-excel] insert row kosong [1 Attachment] Pakai pivot table ya... fitur pivot dalam field setting berupa opsi insert blank row blabla On Mon, Apr 16, 2018 at 7:48 PM, odong nando odongna...@yahoo.com [belajar-excel] wrote: boleh di output boz kid, jadi data yang ada cuma sebagai database yang tidak bisa berubah... br, odong nando Dari: "'Mr. Kid' mr.nm...@gmail.com [belajar-excel]" Kepada: BeExcel Dikirim: Senin, 16 April 2018 19:35 Judul: Re: [belajar-excel] insert row kosong boleh tahu untuk apa insert row kosong di sheet data ? kenapa tidak di sheet output saja ? 2018-04-16 18:54 GMT+07:00 odong nando odongna...@yahoo.com [belajar-excel] : hai rekan2 beExcel, mohon solusi menambahkan row kosong di antara data yang ada. utk lebih jelasnya mohon lihat di lampiran br, odong nando #yiv7460834960 #yiv7460834960 -- #yiv7460834960ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7460834960 #yiv7460834960ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7460834960 #yiv7460834960ygrp-mkp #yiv7460834960hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv7460834960 #yiv7460834960ygrp-mkp #yiv7460834960ads {margin-bottom:10px;}#yiv7460834960 #yiv7460834960ygrp-mkp .yiv7460834960ad {padding:0 0;}#yiv7460834960 #yiv7460834960ygrp-mkp .yiv7460834960ad p {margin:0;}#yiv7460834960 #yiv7460834960ygrp-mkp .yiv7460834960ad a {color:#ff;text-decoration:none;}#yiv7460834960 #yiv7460834960ygrp-sponsor #yiv7460834960ygrp-lc {font-family:Arial;}#yiv7460834960 #yiv7460834960ygrp-sponsor #yiv7460834960ygrp-lc #yiv7460834960hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7460834960 #yiv7460834960ygrp-sponsor #yiv7460834960ygrp-lc .yiv7460834960ad {margin-bottom:10px;padding:0 0;}#yiv7460834960 #yiv7460834960actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7460834960 #yiv7460834960activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7460834960 #yiv7460834960activity span {font-weight:700;}#yiv7460834960 #yiv7460834960activity span:first-child {text-transform:uppercase;}#yiv7460834960 #yiv7460834960activity span a {color:#5085b6;text-decoration:none;}#yiv7460834960 #yiv7460834960activity span span {color:#ff7900;}#yiv7460834960 #yiv7460834960activity span .yiv7460834960underline {text-decoration:underline;}#yiv7460834960 .yiv7460834960attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv7460834960 .yiv7460834960attach div a {text-decoration:none;}#yiv7460834960 .yiv7460834960attach img {border:none;padding-right:5px;}#yiv7460834960 .yiv7460834960attach label {display:block;margin-bottom:5px;}#yiv7460834960 .yiv7460834960attach label a {text-decoration:none;}#yiv7460834960 blockquote {margin:0 0 0 4px;}#yiv7460834960 .yiv7460834960bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv7460834960 .yiv7460834960bold a {text-decoration:none;}#yiv7460834960 dd.yiv7460834960last p a {font-family:Verdana;font-weight:700;}#yiv7460834960 dd.yiv7460834960last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7460834960 dd.yiv7460834960last p span.yiv7460834960yshortcuts {margin-right:0;}#yiv7460834960 div.yiv7460834960attach-table div div a {text-decoration:none;}#yiv7460834960 div.yiv7460834960attach-table {width:400px;}#yiv7460834960 div.yiv7460834960file-title a, #yiv7460834960 div.yiv7460834960file-title a:active, #yiv7460834960 div.yiv7460834960file-title a:hover, #yiv7460834960 div.yiv7460834960file-title a:visited {text-decoration:none;}#yiv7460834960 div.yiv7460834960photo-title a, #yiv7460834960 div.yiv7460834960photo-title a:active, #yiv7460834960 div.yiv7460834960photo-title a:hover, #yiv7460834960 div.yiv7460834960photo-title a:visited {text-decoration:none;}#yiv7460834960 div#yiv7460834960ygrp-mlmsg #yiv7460834960ygrp-msg p a span.yiv7460834960yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7460834960 .yiv7460834960green {color:#628c2a;}#yiv7460834960 .yiv7460834960MsoNormal {margin:0 0 0 0;}#yiv7460834960 o {font-size:0;}#yiv7460834960 #yiv7460834960photos div {float:left;width:72px;}#yiv7460834960 #yiv7460834960photos div div {border:1px solid #66;min-height:62px;overflow:hidden;width:62px;}#yiv7460834960 #yiv7460834960photos div label {color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7460834960 #yiv7460834960reco-category {font-size:77%;}#yiv746083496
Bls: Bls: [belajar-excel] insert row kosong
trimz p gozi atas solusinya br, odong nando Dari: "ghozi alkatiri ghozialkat...@yahoo.co.id [belajar-excel]" Kepada: "odong nando odongna...@yahoo.com [belajar-excel]" Dikirim: Senin, 16 April 2018 21:16 Judul: Re: Bls: [belajar-excel] insert row kosong formula dimulai dari E3 dan F3 sedangkan untuk E2 dan F2 cukup mengcopy nilai dari A2 dan B2 formula untuk E3:=IF(E2="",INDEX($A$2:$A$40,MATCH(E1,$A$2:$A$40,0)+COUNTIF($A$2:$A$40,E1)),IF(COUNTIF(E$2:E2,E2)=COUNTIF($A$2:$A$40,E2),"",E2)) formula untuk F3:=IF(E3="","",INDEX($B$2:$B$40,SUMPRODUCT((LEN(E$2:E2)>0)*1)+1)) copy ke bawah. lihat lampiran di sheet solusi wassalam Ghozi AlkatiriPada Senin, 16 April 2018 20.04.53 GMT+7, odong nando odongna...@yahoo.com [belajar-excel] menulis: boleh di output boz kid, jadi data yang ada cuma sebagai database yang tidak bisa berubah... br, odong nando Dari: "'Mr. Kid' mr.nm...@gmail.com [belajar-excel]" Kepada: BeExcel Dikirim: Senin, 16 April 2018 19:35 Judul: Re: [belajar-excel] insert row kosong boleh tahu untuk apa insert row kosong di sheet data ? kenapa tidak di sheet output saja ? 2018-04-16 18:54 GMT+07:00 odong nando odongna...@yahoo.com [belajar-excel] : hai rekan2 beExcel, mohon solusi menambahkan row kosong di antara data yang ada. utk lebih jelasnya mohon lihat di lampiran br, odong nando #yiv6902945449 #yiv6902945449 -- #yiv6902945449ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6902945449 #yiv6902945449ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6902945449 #yiv6902945449ygrp-mkp #yiv6902945449hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv6902945449 #yiv6902945449ygrp-mkp #yiv6902945449ads {margin-bottom:10px;}#yiv6902945449 #yiv6902945449ygrp-mkp .yiv6902945449ad {padding:0 0;}#yiv6902945449 #yiv6902945449ygrp-mkp .yiv6902945449ad p {margin:0;}#yiv6902945449 #yiv6902945449ygrp-mkp .yiv6902945449ad a {color:#ff;text-decoration:none;}#yiv6902945449 #yiv6902945449ygrp-sponsor #yiv6902945449ygrp-lc {font-family:Arial;}#yiv6902945449 #yiv6902945449ygrp-sponsor #yiv6902945449ygrp-lc #yiv6902945449hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6902945449 #yiv6902945449ygrp-sponsor #yiv6902945449ygrp-lc .yiv6902945449ad {margin-bottom:10px;padding:0 0;}#yiv6902945449 #yiv6902945449actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6902945449 #yiv6902945449activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6902945449 #yiv6902945449activity span {font-weight:700;}#yiv6902945449 #yiv6902945449activity span:first-child {text-transform:uppercase;}#yiv6902945449 #yiv6902945449activity span a {color:#5085b6;text-decoration:none;}#yiv6902945449 #yiv6902945449activity span span {color:#ff7900;}#yiv6902945449 #yiv6902945449activity span .yiv6902945449underline {text-decoration:underline;}#yiv6902945449 .yiv6902945449attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv6902945449 .yiv6902945449attach div a {text-decoration:none;}#yiv6902945449 .yiv6902945449attach img {border:none;padding-right:5px;}#yiv6902945449 .yiv6902945449attach label {display:block;margin-bottom:5px;}#yiv6902945449 .yiv6902945449attach label a {text-decoration:none;}#yiv6902945449 blockquote {margin:0 0 0 4px;}#yiv6902945449 .yiv6902945449bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv6902945449 .yiv6902945449bold a {text-decoration:none;}#yiv6902945449 dd.yiv6902945449last p a {font-family:Verdana;font-weight:700;}#yiv6902945449 dd.yiv6902945449last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6902945449 dd.yiv6902945449last p span.yiv6902945449yshortcuts {margin-right:0;}#yiv6902945449 div.yiv6902945449attach-table div div a {text-decoration:none;}#yiv6902945449 div.yiv6902945449attach-table {width:400px;}#yiv6902945449 div.yiv6902945449file-title a, #yiv6902945449 div.yiv6902945449file-title a:active, #yiv6902945449 div.yiv6902945449file-title a:hover, #yiv6902945449 div.yiv6902945449file-title a:visited {text-decoration:none;}#yiv6902945449 div.yiv6902945449photo-title a, #yiv6902945449 div.yiv6902945449photo-title a:active, #yiv6902945449 div.yiv6902945449photo-title a:hover, #yiv6902945449 div.yiv6902945449photo-title a:visited {text-decoration:none;}#yiv6902945449 div#yiv6902945449ygrp-mlmsg #yiv6902945449ygrp-msg p a span.yiv6902945449yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6902945449 .yiv6902945449green {color:#628c2a;}#yiv6902945449 .yiv6902945449MsoNormal {margin:0 0 0 0;}#yiv6902945449 o {font-size:0;}#yiv6902945449 #yiv6902945449photos div {float:left;width:72px;}#yiv6902945449 #yiv6902945449photos div div {border:1px solid #
Re: [belajar-excel] insert row kosong [1 Attachment]
Pakai pivot table ya... fitur pivot dalam field setting berupa opsi insert blank row blabla On Mon, Apr 16, 2018 at 7:48 PM, odong nando odongna...@yahoo.com [belajar-excel] wrote: > > > boleh di output boz kid, jadi data yang ada cuma sebagai database yang > tidak bisa berubah... > > br, > > odong nando > > > -- > *Dari:* "'Mr. Kid' mr.nm...@gmail.com [belajar-excel]" < > belajar-excel@yahoogroups.com> > *Kepada:* BeExcel > *Dikirim:* Senin, 16 April 2018 19:35 > *Judul:* Re: [belajar-excel] insert row kosong > > > boleh tahu untuk apa insert row kosong di sheet data ? > kenapa tidak di sheet output saja ? > > > 2018-04-16 18:54 GMT+07:00 odong nando odongna...@yahoo.com > [belajar-excel] : > > > hai rekan2 beExcel, > > mohon solusi menambahkan row kosong di antara data yang ada. > > utk lebih jelasnya mohon lihat di lampiran > > > br, > > odong nando > > > > > > re-insert row jika beda.xlsx Description: MS-Excel 2007 spreadsheet
Re: Bls: [belajar-excel] insert row kosong
formula dimulai dari E3 dan F3 sedangkan untuk E2 dan F2 cukup mengcopy nilai dari A2 dan B2 formula untuk E3:=IF(E2="",INDEX($A$2:$A$40,MATCH(E1,$A$2:$A$40,0)+COUNTIF($A$2:$A$40,E1)),IF(COUNTIF(E$2:E2,E2)=COUNTIF($A$2:$A$40,E2),"",E2)) formula untuk F3:=IF(E3="","",INDEX($B$2:$B$40,SUMPRODUCT((LEN(E$2:E2)>0)*1)+1)) copy ke bawah. lihat lampiran di sheet solusi wassalam Ghozi AlkatiriPada Senin, 16 April 2018 20.04.53 GMT+7, odong nando odongna...@yahoo.com [belajar-excel] menulis: boleh di output boz kid, jadi data yang ada cuma sebagai database yang tidak bisa berubah... br, odong nando Dari: "'Mr. Kid' mr.nm...@gmail.com [belajar-excel]" Kepada: BeExcel Dikirim: Senin, 16 April 2018 19:35 Judul: Re: [belajar-excel] insert row kosong boleh tahu untuk apa insert row kosong di sheet data ? kenapa tidak di sheet output saja ? 2018-04-16 18:54 GMT+07:00 odong nando odongna...@yahoo.com [belajar-excel] : hai rekan2 beExcel, mohon solusi menambahkan row kosong di antara data yang ada. utk lebih jelasnya mohon lihat di lampiran br, odong nando #yiv7405091748 #yiv7405091748 -- #yiv7405091748ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7405091748 #yiv7405091748ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7405091748 #yiv7405091748ygrp-mkp #yiv7405091748hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv7405091748 #yiv7405091748ygrp-mkp #yiv7405091748ads {margin-bottom:10px;}#yiv7405091748 #yiv7405091748ygrp-mkp ..yiv7405091748ad {padding:0 0;}#yiv7405091748 #yiv7405091748ygrp-mkp .yiv7405091748ad p {margin:0;}#yiv7405091748 #yiv7405091748ygrp-mkp .yiv7405091748ad a {color:#ff;text-decoration:none;}#yiv7405091748 #yiv7405091748ygrp-sponsor #yiv7405091748ygrp-lc {font-family:Arial;}#yiv7405091748 #yiv7405091748ygrp-sponsor #yiv7405091748ygrp-lc #yiv7405091748hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7405091748 #yiv7405091748ygrp-sponsor #yiv7405091748ygrp-lc .yiv7405091748ad {margin-bottom:10px;padding:0 0;}#yiv7405091748 #yiv7405091748actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7405091748 #yiv7405091748activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7405091748 #yiv7405091748activity span {font-weight:700;}#yiv7405091748 #yiv7405091748activity span:first-child {text-transform:uppercase;}#yiv7405091748 #yiv7405091748activity span a {color:#5085b6;text-decoration:none;}#yiv7405091748 #yiv7405091748activity span span {color:#ff7900;}#yiv7405091748 #yiv7405091748activity span .yiv7405091748underline {text-decoration:underline;}#yiv7405091748 .yiv7405091748attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv7405091748 .yiv7405091748attach div a {text-decoration:none;}#yiv7405091748 .yiv7405091748attach img {border:none;padding-right:5px;}#yiv7405091748 .yiv7405091748attach label {display:block;margin-bottom:5px;}#yiv7405091748 .yiv7405091748attach label a {text-decoration:none;}#yiv7405091748 blockquote {margin:0 0 0 4px;}#yiv7405091748 .yiv7405091748bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv7405091748 .yiv7405091748bold a {text-decoration:none;}#yiv7405091748 dd.yiv7405091748last p a {font-family:Verdana;font-weight:700;}#yiv7405091748 dd.yiv7405091748last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7405091748 dd.yiv7405091748last p span.yiv7405091748yshortcuts {margin-right:0;}#yiv7405091748 div.yiv7405091748attach-table div div a {text-decoration:none;}#yiv7405091748 div.yiv7405091748attach-table {width:400px;}#yiv7405091748 div.yiv7405091748file-title a, #yiv7405091748 div.yiv7405091748file-title a:active, #yiv7405091748 div.yiv7405091748file-title a:hover, #yiv7405091748 div.yiv7405091748file-title a:visited {text-decoration:none;}#yiv7405091748 div.yiv7405091748photo-title a, #yiv7405091748 div.yiv7405091748photo-title a:active, #yiv7405091748 div.yiv7405091748photo-title a:hover, #yiv7405091748 div.yiv7405091748photo-title a:visited {text-decoration:none;}#yiv7405091748 div#yiv7405091748ygrp-mlmsg #yiv7405091748ygrp-msg p a span.yiv7405091748yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7405091748 .yiv7405091748green {color:#628c2a;}#yiv7405091748 .yiv7405091748MsoNormal {margin:0 0 0 0;}#yiv7405091748 o {font-size:0;}#yiv7405091748 #yiv7405091748photos div {float:left;width:72px;}#yiv7405091748 #yiv7405091748photos div div {border:1px solid #66;min-height:62px;overflow:hidden;width:62px;}#yiv7405091748 #yiv7405091748photos div label {color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7405091748 #yiv7405091748reco-category {font-size:77%;}#yiv7405091748 #yiv7405091748reco-desc {
Bls: [belajar-excel] insert row kosong
boleh di output boz kid, jadi data yang ada cuma sebagai database yang tidak bisa berubah... br, odong nando Dari: "'Mr. Kid' mr.nm...@gmail.com [belajar-excel]" Kepada: BeExcel Dikirim: Senin, 16 April 2018 19:35 Judul: Re: [belajar-excel] insert row kosong boleh tahu untuk apa insert row kosong di sheet data ? kenapa tidak di sheet output saja ? 2018-04-16 18:54 GMT+07:00 odong nando odongna...@yahoo.com [belajar-excel] : hai rekan2 beExcel, mohon solusi menambahkan row kosong di antara data yang ada. utk lebih jelasnya mohon lihat di lampiran br, odong nando #yiv6580020930 #yiv6580020930 -- #yiv6580020930ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6580020930 #yiv6580020930ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6580020930 #yiv6580020930ygrp-mkp #yiv6580020930hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv6580020930 #yiv6580020930ygrp-mkp #yiv6580020930ads {margin-bottom:10px;}#yiv6580020930 #yiv6580020930ygrp-mkp .yiv6580020930ad {padding:0 0;}#yiv6580020930 #yiv6580020930ygrp-mkp .yiv6580020930ad p {margin:0;}#yiv6580020930 #yiv6580020930ygrp-mkp .yiv6580020930ad a {color:#ff;text-decoration:none;}#yiv6580020930 #yiv6580020930ygrp-sponsor #yiv6580020930ygrp-lc {font-family:Arial;}#yiv6580020930 #yiv6580020930ygrp-sponsor #yiv6580020930ygrp-lc #yiv6580020930hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6580020930 #yiv6580020930ygrp-sponsor #yiv6580020930ygrp-lc .yiv6580020930ad {margin-bottom:10px;padding:0 0;}#yiv6580020930 #yiv6580020930actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6580020930 #yiv6580020930activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6580020930 #yiv6580020930activity span {font-weight:700;}#yiv6580020930 #yiv6580020930activity span:first-child {text-transform:uppercase;}#yiv6580020930 #yiv6580020930activity span a {color:#5085b6;text-decoration:none;}#yiv6580020930 #yiv6580020930activity span span {color:#ff7900;}#yiv6580020930 #yiv6580020930activity span .yiv6580020930underline {text-decoration:underline;}#yiv6580020930 .yiv6580020930attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv6580020930 .yiv6580020930attach div a {text-decoration:none;}#yiv6580020930 .yiv6580020930attach img {border:none;padding-right:5px;}#yiv6580020930 .yiv6580020930attach label {display:block;margin-bottom:5px;}#yiv6580020930 .yiv6580020930attach label a {text-decoration:none;}#yiv6580020930 blockquote {margin:0 0 0 4px;}#yiv6580020930 .yiv6580020930bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv6580020930 .yiv6580020930bold a {text-decoration:none;}#yiv6580020930 dd.yiv6580020930last p a {font-family:Verdana;font-weight:700;}#yiv6580020930 dd.yiv6580020930last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6580020930 dd.yiv6580020930last p span.yiv6580020930yshortcuts {margin-right:0;}#yiv6580020930 div.yiv6580020930attach-table div div a {text-decoration:none;}#yiv6580020930 div.yiv6580020930attach-table {width:400px;}#yiv6580020930 div.yiv6580020930file-title a, #yiv6580020930 div.yiv6580020930file-title a:active, #yiv6580020930 div.yiv6580020930file-title a:hover, #yiv6580020930 div.yiv6580020930file-title a:visited {text-decoration:none;}#yiv6580020930 div.yiv6580020930photo-title a, #yiv6580020930 div.yiv6580020930photo-title a:active, #yiv6580020930 div.yiv6580020930photo-title a:hover, #yiv6580020930 div.yiv6580020930photo-title a:visited {text-decoration:none;}#yiv6580020930 div#yiv6580020930ygrp-mlmsg #yiv6580020930ygrp-msg p a span.yiv6580020930yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6580020930 .yiv6580020930green {color:#628c2a;}#yiv6580020930 .yiv6580020930MsoNormal {margin:0 0 0 0;}#yiv6580020930 o {font-size:0;}#yiv6580020930 #yiv6580020930photos div {float:left;width:72px;}#yiv6580020930 #yiv6580020930photos div div {border:1px solid #66;min-height:62px;overflow:hidden;width:62px;}#yiv6580020930 #yiv6580020930photos div label {color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6580020930 #yiv6580020930reco-category {font-size:77%;}#yiv6580020930 #yiv6580020930reco-desc {font-size:77%;}#yiv6580020930 .yiv6580020930replbq {margin:4px;}#yiv6580020930 #yiv6580020930ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv6580020930 #yiv6580020930ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6580020930 #yiv6580020930ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6580020930 #yiv6580020930ygrp-mlmsg select, #yiv6580020930 input, #yiv6580020930 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv6580020930 #yiv6580020930ygrp-mlmsg pre, #yiv6580020930 code {font:115% monos
Re: [belajar-excel] insert row kosong
boleh tahu untuk apa insert row kosong di sheet data ? kenapa tidak di sheet output saja ? 2018-04-16 18:54 GMT+07:00 odong nando odongna...@yahoo.com [belajar-excel] : > > > hai rekan2 beExcel, > > mohon solusi menambahkan row kosong di antara data yang ada. > > utk lebih jelasnya mohon lihat di lampiran > > > br, > > odong nando > > >
[belajar-excel] insert row kosong
hai rekan2 beExcel, mohon solusi menambahkan row kosong di antara data yang ada. utk lebih jelasnya mohon lihat di lampiran br, odong nando insert row jika beda.xlsx Description: MS-Excel 2007 spreadsheet