lihat di attachment pada tabel asal di sheet sebelum beri tanda silang (X) pada row yang ingin disembunyikan selanutnya lihat hasilnya di sheet setelah
wassalam Ghozi Alkatiri -------------------------------------------- Pada Sel, 14/2/17, Aku Ary akuar...@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com> menulis: Judul: [belajar-excel] Hide row, Nomor urut otomatis berubah [1 Attachment] Kepada: belajar-excel@yahoogroups.com Tanggal: Selasa, 14 Februari, 2017, 2:35 PM Dear Para Suhu, Mohon bimbingannya..Apabila melakukan hide pada baris tertentu, maka nomor urut secara otomatis akan ikut berubah mengikuti sesuai urutan yang ada (hanya tampil urutan dari data yang tidak di hidden). Terima kasih atas bantuan dan pencerahannya. Mohon maaf apabila sudah pernah dibahas sebelumnya.. salam,ary *terlampir contoh kasus sederhana #yiv3269378210 #yiv3269378210 -- #yiv3269378210ygrp-mkp { border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;} #yiv3269378210 #yiv3269378210ygrp-mkp hr { border:1px solid #d8d8d8;} #yiv3269378210 #yiv3269378210ygrp-mkp #yiv3269378210hd { color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;} #yiv3269378210 #yiv3269378210ygrp-mkp #yiv3269378210ads { margin-bottom:10px;} #yiv3269378210 #yiv3269378210ygrp-mkp .yiv3269378210ad { padding:0 0;} #yiv3269378210 #yiv3269378210ygrp-mkp .yiv3269378210ad p { margin:0;} #yiv3269378210 #yiv3269378210ygrp-mkp .yiv3269378210ad a { color:#0000ff;text-decoration:none;} #yiv3269378210 #yiv3269378210ygrp-sponsor #yiv3269378210ygrp-lc { font-family:Arial;} #yiv3269378210 #yiv3269378210ygrp-sponsor #yiv3269378210ygrp-lc #yiv3269378210hd { margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;} #yiv3269378210 #yiv3269378210ygrp-sponsor #yiv3269378210ygrp-lc .yiv3269378210ad { margin-bottom:10px;padding:0 0;} #yiv3269378210 #yiv3269378210actions { font-family:Verdana;font-size:11px;padding:10px 0;} #yiv3269378210 #yiv3269378210activity { background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;} #yiv3269378210 #yiv3269378210activity span { font-weight:700;} #yiv3269378210 #yiv3269378210activity span:first-child { text-transform:uppercase;} #yiv3269378210 #yiv3269378210activity span a { color:#5085b6;text-decoration:none;} #yiv3269378210 #yiv3269378210activity span span { color:#ff7900;} #yiv3269378210 #yiv3269378210activity span .yiv3269378210underline { text-decoration:underline;} #yiv3269378210 .yiv3269378210attach { clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;} #yiv3269378210 .yiv3269378210attach div a { text-decoration:none;} #yiv3269378210 .yiv3269378210attach img { border:none;padding-right:5px;} #yiv3269378210 .yiv3269378210attach label { display:block;margin-bottom:5px;} #yiv3269378210 .yiv3269378210attach label a { text-decoration:none;} #yiv3269378210 blockquote { margin:0 0 0 4px;} #yiv3269378210 .yiv3269378210bold { font-family:Arial;font-size:13px;font-weight:700;} #yiv3269378210 .yiv3269378210bold a { text-decoration:none;} #yiv3269378210 dd.yiv3269378210last p a { font-family:Verdana;font-weight:700;} #yiv3269378210 dd.yiv3269378210last p span { margin-right:10px;font-family:Verdana;font-weight:700;} #yiv3269378210 dd.yiv3269378210last p span.yiv3269378210yshortcuts { margin-right:0;} #yiv3269378210 div.yiv3269378210attach-table div div a { text-decoration:none;} #yiv3269378210 div.yiv3269378210attach-table { width:400px;} #yiv3269378210 div.yiv3269378210file-title a, #yiv3269378210 div.yiv3269378210file-title a:active, #yiv3269378210 div.yiv3269378210file-title a:hover, #yiv3269378210 div.yiv3269378210file-title a:visited { text-decoration:none;} #yiv3269378210 div.yiv3269378210photo-title a, #yiv3269378210 div.yiv3269378210photo-title a:active, #yiv3269378210 div.yiv3269378210photo-title a:hover, #yiv3269378210 div.yiv3269378210photo-title a:visited { text-decoration:none;} #yiv3269378210 div#yiv3269378210ygrp-mlmsg #yiv3269378210ygrp-msg p a span.yiv3269378210yshortcuts { font-family:Verdana;font-size:10px;font-weight:normal;} #yiv3269378210 .yiv3269378210green { color:#628c2a;} #yiv3269378210 .yiv3269378210MsoNormal { margin:0 0 0 0;} #yiv3269378210 o { font-size:0;} #yiv3269378210 #yiv3269378210photos div { float:left;width:72px;} #yiv3269378210 #yiv3269378210photos div div { border:1px solid #666666;height:62px;overflow:hidden;width:62px;} #yiv3269378210 #yiv3269378210photos div label { color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;} #yiv3269378210 #yiv3269378210reco-category { font-size:77%;} #yiv3269378210 #yiv3269378210reco-desc { font-size:77%;} #yiv3269378210 .yiv3269378210replbq { margin:4px;} #yiv3269378210 #yiv3269378210ygrp-actbar div a:first-child { margin-right:2px;padding-right:5px;} #yiv3269378210 #yiv3269378210ygrp-mlmsg { font-size:13px;font-family:Arial, helvetica, clean, sans-serif;} #yiv3269378210 #yiv3269378210ygrp-mlmsg table { font-size:inherit;font:100%;} #yiv3269378210 #yiv3269378210ygrp-mlmsg select, #yiv3269378210 input, #yiv3269378210 textarea { font:99% Arial, Helvetica, clean, sans-serif;} #yiv3269378210 #yiv3269378210ygrp-mlmsg pre, #yiv3269378210 code { font:115% monospace;} #yiv3269378210 #yiv3269378210ygrp-mlmsg * { line-height:1.22em;} #yiv3269378210 #yiv3269378210ygrp-mlmsg #yiv3269378210logo { padding-bottom:10px;} #yiv3269378210 #yiv3269378210ygrp-msg p a { font-family:Verdana;} #yiv3269378210 #yiv3269378210ygrp-msg p#yiv3269378210attach-count span { color:#1E66AE;font-weight:700;} #yiv3269378210 #yiv3269378210ygrp-reco #yiv3269378210reco-head { color:#ff7900;font-weight:700;} #yiv3269378210 #yiv3269378210ygrp-reco { margin-bottom:20px;padding:0px;} #yiv3269378210 #yiv3269378210ygrp-sponsor #yiv3269378210ov li a { font-size:130%;text-decoration:none;} #yiv3269378210 #yiv3269378210ygrp-sponsor #yiv3269378210ov li { font-size:77%;list-style-type:square;padding:6px 0;} #yiv3269378210 #yiv3269378210ygrp-sponsor #yiv3269378210ov ul { margin:0;padding:0 0 0 8px;} #yiv3269378210 #yiv3269378210ygrp-text { font-family:Georgia;} #yiv3269378210 #yiv3269378210ygrp-text p { margin:0 0 1em 0;} #yiv3269378210 #yiv3269378210ygrp-text tt { font-size:120%;} #yiv3269378210 #yiv3269378210ygrp-vital ul li:last-child { border-right:none !important; } #yiv3269378210
ghozi 15022017 Hide row Nomor urut otomatis berubah.xls
Description: MS-Excel spreadsheet