Wa'alaikumsalam,dear Mba Zerlinda,menurut saya caranya,blok A4:B14Pencet tombol
F5Klik Specialklik Blank > klik Oklalu tekan ctrl+(-)Lalu pilih Shift cells
updonesemoga berhasil
Best Regards,
Fajar Fatahillah
On Friday, June 12, 2015 1:12 PM, "Zerlinda Seismica [email protected]
[belajar-excel]" <[email protected]> wrote:
Assalamualaikum wrwb
Selamat siang para expert dan sesepuh.
Ada yang ingin saya share dan minta petunjuk..adakah triknya supaya baris bawah
bisa naik keatas sehingga menjadi rapi seperti lampiran ini
Salam
Seismica
#yiv6475282303 #yiv6475282303 -- #yiv6475282303ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6475282303
#yiv6475282303ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6475282303
#yiv6475282303ygrp-mkp #yiv6475282303hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv6475282303 #yiv6475282303ygrp-mkp #yiv6475282303ads
{margin-bottom:10px;}#yiv6475282303 #yiv6475282303ygrp-mkp .yiv6475282303ad
{padding:0 0;}#yiv6475282303 #yiv6475282303ygrp-mkp .yiv6475282303ad p
{margin:0;}#yiv6475282303 #yiv6475282303ygrp-mkp .yiv6475282303ad a
{color:#0000ff;text-decoration:none;}#yiv6475282303 #yiv6475282303ygrp-sponsor
#yiv6475282303ygrp-lc {font-family:Arial;}#yiv6475282303
#yiv6475282303ygrp-sponsor #yiv6475282303ygrp-lc #yiv6475282303hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6475282303
#yiv6475282303ygrp-sponsor #yiv6475282303ygrp-lc .yiv6475282303ad
{margin-bottom:10px;padding:0 0;}#yiv6475282303 #yiv6475282303actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6475282303
#yiv6475282303activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6475282303
#yiv6475282303activity span {font-weight:700;}#yiv6475282303
#yiv6475282303activity span:first-child
{text-transform:uppercase;}#yiv6475282303 #yiv6475282303activity span a
{color:#5085b6;text-decoration:none;}#yiv6475282303 #yiv6475282303activity span
span {color:#ff7900;}#yiv6475282303 #yiv6475282303activity span
.yiv6475282303underline {text-decoration:underline;}#yiv6475282303
.yiv6475282303attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv6475282303 .yiv6475282303attach div a
{text-decoration:none;}#yiv6475282303 .yiv6475282303attach img
{border:none;padding-right:5px;}#yiv6475282303 .yiv6475282303attach label
{display:block;margin-bottom:5px;}#yiv6475282303 .yiv6475282303attach label a
{text-decoration:none;}#yiv6475282303 blockquote {margin:0 0 0
4px;}#yiv6475282303 .yiv6475282303bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv6475282303
.yiv6475282303bold a {text-decoration:none;}#yiv6475282303 dd.yiv6475282303last
p a {font-family:Verdana;font-weight:700;}#yiv6475282303 dd.yiv6475282303last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6475282303
dd.yiv6475282303last p span.yiv6475282303yshortcuts
{margin-right:0;}#yiv6475282303 div.yiv6475282303attach-table div div a
{text-decoration:none;}#yiv6475282303 div.yiv6475282303attach-table
{width:400px;}#yiv6475282303 div.yiv6475282303file-title a, #yiv6475282303
div.yiv6475282303file-title a:active, #yiv6475282303
div.yiv6475282303file-title a:hover, #yiv6475282303 div.yiv6475282303file-title
a:visited {text-decoration:none;}#yiv6475282303 div.yiv6475282303photo-title a,
#yiv6475282303 div.yiv6475282303photo-title a:active, #yiv6475282303
div.yiv6475282303photo-title a:hover, #yiv6475282303
div.yiv6475282303photo-title a:visited {text-decoration:none;}#yiv6475282303
div#yiv6475282303ygrp-mlmsg #yiv6475282303ygrp-msg p a
span.yiv6475282303yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6475282303
.yiv6475282303green {color:#628c2a;}#yiv6475282303 .yiv6475282303MsoNormal
{margin:0 0 0 0;}#yiv6475282303 o {font-size:0;}#yiv6475282303
#yiv6475282303photos div {float:left;width:72px;}#yiv6475282303
#yiv6475282303photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv6475282303
#yiv6475282303photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6475282303
#yiv6475282303reco-category {font-size:77%;}#yiv6475282303
#yiv6475282303reco-desc {font-size:77%;}#yiv6475282303 .yiv6475282303replbq
{margin:4px;}#yiv6475282303 #yiv6475282303ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv6475282303 #yiv6475282303ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6475282303
#yiv6475282303ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6475282303
#yiv6475282303ygrp-mlmsg select, #yiv6475282303 input, #yiv6475282303 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv6475282303
#yiv6475282303ygrp-mlmsg pre, #yiv6475282303 code {font:115%
monospace;}#yiv6475282303 #yiv6475282303ygrp-mlmsg *
{line-height:1.22em;}#yiv6475282303 #yiv6475282303ygrp-mlmsg #yiv6475282303logo
{padding-bottom:10px;}#yiv6475282303 #yiv6475282303ygrp-msg p a
{font-family:Verdana;}#yiv6475282303 #yiv6475282303ygrp-msg
p#yiv6475282303attach-count span {color:#1E66AE;font-weight:700;}#yiv6475282303
#yiv6475282303ygrp-reco #yiv6475282303reco-head
{color:#ff7900;font-weight:700;}#yiv6475282303 #yiv6475282303ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv6475282303 #yiv6475282303ygrp-sponsor
#yiv6475282303ov li a {font-size:130%;text-decoration:none;}#yiv6475282303
#yiv6475282303ygrp-sponsor #yiv6475282303ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv6475282303
#yiv6475282303ygrp-sponsor #yiv6475282303ov ul {margin:0;padding:0 0 0
8px;}#yiv6475282303 #yiv6475282303ygrp-text
{font-family:Georgia;}#yiv6475282303 #yiv6475282303ygrp-text p {margin:0 0 1em
0;}#yiv6475282303 #yiv6475282303ygrp-text tt {font-size:120%;}#yiv6475282303
#yiv6475282303ygrp-vital ul li:last-child {border-right:none
!important;}#yiv6475282303
