yoo tio, sepanjang pengetahuan saya itu adalah garis margin, akan muncul setelah kita masuk print preview, dan saat keluar dari print preview maka munculah garis tersebut. dimana garis margin tersebut adalah batas ahir suatu halaman baik atas bawah or kiri kanan. dan sifatnya tidak akan hilang kecuali kita tutup file dan keluar dari excel dan membukanya kembali tanpa melakukan print priview. br,
odong nando Pada Kamis, 17 Desember 2015 15:04, "Tio Adi Bayu Adjie tio.ad...@ptssb.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> menulis: Bang Hendrik, Maaf Bang, saya tidak pakai freeze pane, itu sudah saya lihat. Sebelumnya saya pikir itu page break atau print area tapi setelah saya “clear” kan, ternyata tidak berpengaruh. Kira2 apa ya master ? Terima kasih. | Best Regards, Tio Adi Bayu Adjie | | | | | | | | | | | From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com] Sent: Thursday, December 17, 2015 10:58 AM To: belajar-excel@yahoogroups.com Subject: Re: [belajar-excel] Gridline [1 Attachment] Hai Tio, Setahu saya itu adalah "Freeze Pane" mealalu menu View. Untuk menghilangkannya cukup "Unfreeze Pane", ga perlu VBA. Salam, HK From: "Tio Adi Bayu adjietio.ad...@ptssb.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> To: belajar-excel@yahoogroups.com Sent: Thursday, 17 December 2015, 10:10 Subject: [belajar-excel] Gridline Dear XL expert, Maaf mau nanya. Untuk masalah excel dibawah. Terima kasih sekali atas jawabannya. Semoga Tuhan YME membalas kebaikannya. Regards, Tio #yiv6209865097 #yiv6209865097 -- #yiv6209865097ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6209865097 #yiv6209865097ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6209865097 #yiv6209865097ygrp-mkp #yiv6209865097hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv6209865097 #yiv6209865097ygrp-mkp #yiv6209865097ads {margin-bottom:10px;}#yiv6209865097 #yiv6209865097ygrp-mkp .yiv6209865097ad {padding:0 0;}#yiv6209865097 #yiv6209865097ygrp-mkp .yiv6209865097ad p {margin:0;}#yiv6209865097 #yiv6209865097ygrp-mkp .yiv6209865097ad a {color:#0000ff;text-decoration:none;}#yiv6209865097 #yiv6209865097ygrp-sponsor #yiv6209865097ygrp-lc {font-family:Arial;}#yiv6209865097 #yiv6209865097ygrp-sponsor #yiv6209865097ygrp-lc #yiv6209865097hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6209865097 #yiv6209865097ygrp-sponsor #yiv6209865097ygrp-lc .yiv6209865097ad {margin-bottom:10px;padding:0 0;}#yiv6209865097 #yiv6209865097actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6209865097 #yiv6209865097activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6209865097 #yiv6209865097activity span {font-weight:700;}#yiv6209865097 #yiv6209865097activity span:first-child {text-transform:uppercase;}#yiv6209865097 #yiv6209865097activity span a {color:#5085b6;text-decoration:none;}#yiv6209865097 #yiv6209865097activity span span {color:#ff7900;}#yiv6209865097 #yiv6209865097activity span .yiv6209865097underline {text-decoration:underline;}#yiv6209865097 .yiv6209865097attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv6209865097 .yiv6209865097attach div a {text-decoration:none;}#yiv6209865097 .yiv6209865097attach img {border:none;padding-right:5px;}#yiv6209865097 .yiv6209865097attach label {display:block;margin-bottom:5px;}#yiv6209865097 .yiv6209865097attach label a {text-decoration:none;}#yiv6209865097 blockquote {margin:0 0 0 4px;}#yiv6209865097 .yiv6209865097bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv6209865097 .yiv6209865097bold a {text-decoration:none;}#yiv6209865097 dd.yiv6209865097last p a {font-family:Verdana;font-weight:700;}#yiv6209865097 dd.yiv6209865097last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6209865097 dd.yiv6209865097last p span.yiv6209865097yshortcuts {margin-right:0;}#yiv6209865097 div.yiv6209865097attach-table div div a {text-decoration:none;}#yiv6209865097 div.yiv6209865097attach-table {width:400px;}#yiv6209865097 div.yiv6209865097file-title a, #yiv6209865097 div.yiv6209865097file-title a:active, #yiv6209865097 div.yiv6209865097file-title a:hover, #yiv6209865097 div.yiv6209865097file-title a:visited {text-decoration:none;}#yiv6209865097 div.yiv6209865097photo-title a, #yiv6209865097 div.yiv6209865097photo-title a:active, #yiv6209865097 div.yiv6209865097photo-title a:hover, #yiv6209865097 div.yiv6209865097photo-title a:visited {text-decoration:none;}#yiv6209865097 div#yiv6209865097ygrp-mlmsg #yiv6209865097ygrp-msg p a span.yiv6209865097yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6209865097 .yiv6209865097green {color:#628c2a;}#yiv6209865097 .yiv6209865097MsoNormal {margin:0 0 0 0;}#yiv6209865097 o {font-size:0;}#yiv6209865097 #yiv6209865097photos div {float:left;width:72px;}#yiv6209865097 #yiv6209865097photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv6209865097 #yiv6209865097photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6209865097 #yiv6209865097reco-category {font-size:77%;}#yiv6209865097 #yiv6209865097reco-desc {font-size:77%;}#yiv6209865097 .yiv6209865097replbq {margin:4px;}#yiv6209865097 #yiv6209865097ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv6209865097 #yiv6209865097ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6209865097 #yiv6209865097ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6209865097 #yiv6209865097ygrp-mlmsg select, #yiv6209865097 input, #yiv6209865097 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv6209865097 #yiv6209865097ygrp-mlmsg pre, #yiv6209865097 code {font:115% monospace;}#yiv6209865097 #yiv6209865097ygrp-mlmsg * {line-height:1.22em;}#yiv6209865097 #yiv6209865097ygrp-mlmsg #yiv6209865097logo {padding-bottom:10px;}#yiv6209865097 #yiv6209865097ygrp-msg p a {font-family:Verdana;}#yiv6209865097 #yiv6209865097ygrp-msg p#yiv6209865097attach-count span {color:#1E66AE;font-weight:700;}#yiv6209865097 #yiv6209865097ygrp-reco #yiv6209865097reco-head {color:#ff7900;font-weight:700;}#yiv6209865097 #yiv6209865097ygrp-reco {margin-bottom:20px;padding:0px;}#yiv6209865097 #yiv6209865097ygrp-sponsor #yiv6209865097ov li a {font-size:130%;text-decoration:none;}#yiv6209865097 #yiv6209865097ygrp-sponsor #yiv6209865097ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv6209865097 #yiv6209865097ygrp-sponsor #yiv6209865097ov ul {margin:0;padding:0 0 0 8px;}#yiv6209865097 #yiv6209865097ygrp-text {font-family:Georgia;}#yiv6209865097 #yiv6209865097ygrp-text p {margin:0 0 1em 0;}#yiv6209865097 #yiv6209865097ygrp-text tt {font-size:120%;}#yiv6209865097 #yiv6209865097ygrp-vital ul li:last-child {border-right:none !important;}#yiv6209865097