Oia, saya pake excel 2013
Best Regards, Fajar Fatahillah
On Thursday, November 26, 2015 1:43 PM, Fajar Fatahillah
<[email protected]> wrote:
Dear Mr Kid,kalau pilihan tersebut disable kenapa ya?gak bisa di centang
Best Regards, Fajar Fatahillah
On Thursday, November 26, 2015 12:28 PM, "'Mr. Kid' [email protected]
[belajar-excel]" <[email protected]> wrote:
Hai Fajar,
klik kanan nama field -> pilih Field Settings -> centang opsi 'Include new
items in manual filter' atau bunyi yang semacamnya -> tekan OK
Setiap field yang ada dalam daftar fields bisa diatur karena disediakan
setting. Setting setiap field dilakukan dengan klik kanan nama field dan pilih
field settings.
Salah satu opsi yang ada dalam setting setiap fields adalah 'Include new items
in manual filter' atau bunyi yang semacamnya.
Jika opsi ini dicentang, maka setiap item baru akan dalam keadaan ter-select di
manual filter alias dalam keadaan tercentang.
Lebih detil di coretan yang ada disini.
Wassalam,
Kid
On Thu, Nov 26, 2015 at 11:51 AM, Fajar Fatahillah [email protected]
[belajar-excel] <[email protected]> wrote:
Dear Master Excel,Mau tanya cara untuk cek otomatis pada report filter di
pivot table saat data bertambah gimana ya?
contoh pada gambar berikut
yang seharusnya di uncheck yang namanya SMARTBOX aja,
tapi tiap ada penambahan data, yang lain jadi ke uncheck juga.mohon masukannya
Best Regards, Fajar Fatahillah
On Friday, September 4, 2015 3:18 PM, "Sony Ario [email protected]
[belajar-excel]" <[email protected]> wrote:
Yup. Setelah baca petunjuk dari Mr. Kid, langsung saya lakukan :)
Terima kasih atas petunjuknya.
WassalamSony
2015-09-03 6:13 GMT+07:00 'Mr. Kid' [email protected] [belajar-excel]
<[email protected]>:
Hai Sony,
Sudahkah uncheck opsi Autofit column blabla dalam pivot table options ?
(klik kanan pivot table -> pivot table options -> tab layout & format ->
uncheck Autofit column blabla -> OK)
Wassalam,
Kid
2015-09-01 17:30 GMT+07:00 Sony Ario [email protected] [belajar-excel]
<[email protected]>:
Dear be excelers,Mohon bantuan. Saya punya sebuah pivot table yang sering
kali harus direfresh. Saya sudah set lebar kolom dengan lebar tertentu. Tapi
pada saat di refresh, lebar kolom berubah lagi. Sehingga data nya terlihat
####.Mohon dibantu caranya supaya lebar kolom tsb tidak berubah saat di
refresh.Terima kasih sebelumnya.Rgds
Sony
#yiv0885726107 -- #yiv0885726107ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0885726107
#yiv0885726107ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0885726107
#yiv0885726107ygrp-mkp #yiv0885726107hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv0885726107 #yiv0885726107ygrp-mkp #yiv0885726107ads
{margin-bottom:10px;}#yiv0885726107 #yiv0885726107ygrp-mkp .yiv0885726107ad
{padding:0 0;}#yiv0885726107 #yiv0885726107ygrp-mkp .yiv0885726107ad p
{margin:0;}#yiv0885726107 #yiv0885726107ygrp-mkp .yiv0885726107ad a
{color:#0000ff;text-decoration:none;}#yiv0885726107 #yiv0885726107ygrp-sponsor
#yiv0885726107ygrp-lc {font-family:Arial;}#yiv0885726107
#yiv0885726107ygrp-sponsor #yiv0885726107ygrp-lc #yiv0885726107hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0885726107
#yiv0885726107ygrp-sponsor #yiv0885726107ygrp-lc .yiv0885726107ad
{margin-bottom:10px;padding:0 0;}#yiv0885726107 #yiv0885726107actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0885726107
#yiv0885726107activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0885726107
#yiv0885726107activity span {font-weight:700;}#yiv0885726107
#yiv0885726107activity span:first-child
{text-transform:uppercase;}#yiv0885726107 #yiv0885726107activity span a
{color:#5085b6;text-decoration:none;}#yiv0885726107 #yiv0885726107activity span
span {color:#ff7900;}#yiv0885726107 #yiv0885726107activity span
.yiv0885726107underline {text-decoration:underline;}#yiv0885726107
.yiv0885726107attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv0885726107 .yiv0885726107attach div a
{text-decoration:none;}#yiv0885726107 .yiv0885726107attach img
{border:none;padding-right:5px;}#yiv0885726107 .yiv0885726107attach label
{display:block;margin-bottom:5px;}#yiv0885726107 .yiv0885726107attach label a
{text-decoration:none;}#yiv0885726107 blockquote {margin:0 0 0
4px;}#yiv0885726107 .yiv0885726107bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv0885726107
.yiv0885726107bold a {text-decoration:none;}#yiv0885726107 dd.yiv0885726107last
p a {font-family:Verdana;font-weight:700;}#yiv0885726107 dd.yiv0885726107last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0885726107
dd.yiv0885726107last p span.yiv0885726107yshortcuts
{margin-right:0;}#yiv0885726107 div.yiv0885726107attach-table div div a
{text-decoration:none;}#yiv0885726107 div.yiv0885726107attach-table
{width:400px;}#yiv0885726107 div.yiv0885726107file-title a, #yiv0885726107
div.yiv0885726107file-title a:active, #yiv0885726107
div.yiv0885726107file-title a:hover, #yiv0885726107 div.yiv0885726107file-title
a:visited {text-decoration:none;}#yiv0885726107 div.yiv0885726107photo-title a,
#yiv0885726107 div.yiv0885726107photo-title a:active, #yiv0885726107
div.yiv0885726107photo-title a:hover, #yiv0885726107
div.yiv0885726107photo-title a:visited {text-decoration:none;}#yiv0885726107
div#yiv0885726107ygrp-mlmsg #yiv0885726107ygrp-msg p a
span.yiv0885726107yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0885726107
.yiv0885726107green {color:#628c2a;}#yiv0885726107 .yiv0885726107MsoNormal
{margin:0 0 0 0;}#yiv0885726107 o {font-size:0;}#yiv0885726107
#yiv0885726107photos div {float:left;width:72px;}#yiv0885726107
#yiv0885726107photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv0885726107
#yiv0885726107photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0885726107
#yiv0885726107reco-category {font-size:77%;}#yiv0885726107
#yiv0885726107reco-desc {font-size:77%;}#yiv0885726107 .yiv0885726107replbq
{margin:4px;}#yiv0885726107 #yiv0885726107ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv0885726107 #yiv0885726107ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0885726107
#yiv0885726107ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0885726107
#yiv0885726107ygrp-mlmsg select, #yiv0885726107 input, #yiv0885726107 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv0885726107
#yiv0885726107ygrp-mlmsg pre, #yiv0885726107 code {font:115%
monospace;}#yiv0885726107 #yiv0885726107ygrp-mlmsg *
{line-height:1.22em;}#yiv0885726107 #yiv0885726107ygrp-mlmsg #yiv0885726107logo
{padding-bottom:10px;}#yiv0885726107 #yiv0885726107ygrp-msg p a
{font-family:Verdana;}#yiv0885726107 #yiv0885726107ygrp-msg
p#yiv0885726107attach-count span {color:#1E66AE;font-weight:700;}#yiv0885726107
#yiv0885726107ygrp-reco #yiv0885726107reco-head
{color:#ff7900;font-weight:700;}#yiv0885726107 #yiv0885726107ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv0885726107 #yiv0885726107ygrp-sponsor
#yiv0885726107ov li a {font-size:130%;text-decoration:none;}#yiv0885726107
#yiv0885726107ygrp-sponsor #yiv0885726107ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv0885726107
#yiv0885726107ygrp-sponsor #yiv0885726107ov ul {margin:0;padding:0 0 0
8px;}#yiv0885726107 #yiv0885726107ygrp-text
{font-family:Georgia;}#yiv0885726107 #yiv0885726107ygrp-text p {margin:0 0 1em
0;}#yiv0885726107 #yiv0885726107ygrp-text tt {font-size:120%;}#yiv0885726107
#yiv0885726107ygrp-vital ul li:last-child {border-right:none
!important;}#yiv0885726107
