Liza Afra Blog

<div dir="ltr" style="text-align: left;" trbidi="on">
Halo semua..<br />
<div class="MsoNormal">
Anda ingin melindungi file anda dari orang yang tidak anda
kehendaki?<span style="mso-spacerun: yes;">   </span>Pada bagian ini kita
membahas file Excel.</div>
<div class="MsoNormal">
Kita langsung aja yok … bagaimana cara membuat password pada
file Excel /menyimpan file Excel dengan password. Begini cara nya…</div>
<div class="MsoNormal">
Udah siap..? 1,,,,2,,,3 ,,, Mulai,,,,,,,,,,</div>
<div class="Default" style="margin-left: .25in; mso-list: l0 level1 lfo1; text-indent: -.25in;">
<br />
<span style="font-size: 11.5pt; mso-fareast-font-family: Calibri;"><span style="mso-list: Ignore;">1.<span style="font: 7.0pt "Times New Roman";">      
</span></span></span><span style="font-size: 11.5pt;">Klik <i>Office
Button > Open. </i></span></div>
<div class="Default" style="margin-left: .25in; mso-list: l0 level1 lfo1; text-indent: -.25in;">
<span style="font-size: 11.5pt; mso-fareast-font-family: Calibri;"><span style="mso-list: Ignore;">2.<span style="font: 7.0pt "Times New Roman";">      
</span></span></span><span style="font-size: 11.5pt;"><span style="mso-spacerun: yes;"> </span>Buka kembali file yang anda inginkan…..</span></div>
<div class="Default" style="margin-left: .25in;">
<br />
<span style="font-size: 11.5pt;">misalnya
:“<i>EXCEL”<span style="mso-spacerun: yes;">            </span></i></span></div>
<div class="Default" style="margin-left: .25in;">
<i><span style="font-size: 11.5pt;"></span></i></div>
<div class="separator" style="clear: both; text-align: center;">
<i><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi6iRuDi0L-ciFpp0NYJpM_Ov5h0zEhyphenhyphengZOSbXEiEU2Z7nWydYt0mIkTnnzbbR1CvnpjZGapdfbxKRzsaPirSwcbeEub8Whd3b7w5tMGfWNp_adItuNVBOntajTlBGhzR_uT172P3yr1Nc/s1600/1.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="400" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi6iRuDi0L-ciFpp0NYJpM_Ov5h0zEhyphenhyphengZOSbXEiEU2Z7nWydYt0mIkTnnzbbR1CvnpjZGapdfbxKRzsaPirSwcbeEub8Whd3b7w5tMGfWNp_adItuNVBOntajTlBGhzR_uT172P3yr1Nc/s400/1.jpg" width="398" /></a></i></div>
<br />
<div class="Default" style="margin-left: .25in; mso-list: l0 level1 lfo1; text-indent: -.25in;">
<span style="font-size: 11.5pt; mso-fareast-font-family: Calibri;"><span style="mso-list: Ignore;">3.<span style="font: 7.0pt "Times New Roman";">      
</span></span></span><span style="font-size: 11.5pt;">Klik <i>Office
Button > Save As > Excel Workbook. </i></span></div>
<div class="separator" style="clear: both; text-align: center;">
<i><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjLsU2Oic57vdNvZvebquQxd9ZQQ0xC4kDHs6Mc-uh7J-fx9GbN1Orzfx0crmvHAAxSDeFlj2nx42DjDO9OTRcC4bq6x8QIWXhqv9YswmHKQSZX3Z7ltn9a4D3EaZ81MjFkwaqDU_KhJA0/s1600/2.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="260" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjLsU2Oic57vdNvZvebquQxd9ZQQ0xC4kDHs6Mc-uh7J-fx9GbN1Orzfx0crmvHAAxSDeFlj2nx42DjDO9OTRcC4bq6x8QIWXhqv9YswmHKQSZX3Z7ltn9a4D3EaZ81MjFkwaqDU_KhJA0/s400/2.jpg" width="400" /></a></i></div>
<br />
<div class="Default" style="margin-left: .25in; mso-list: l0 level1 lfo1; text-indent: -.25in;">
<span style="font-size: 11.5pt; mso-fareast-font-family: Calibri;"><span style="mso-list: Ignore;">4.<span style="font: 7.0pt "Times New Roman";">      
</span></span></span><span style="font-size: 11.5pt;">Pada kotak dialog
yang muncul, klik tombol <i>Tools > General Option. </i></span></div>
<div class="Default" style="margin-left: .25in;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<i><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg4zA2Ykl_A6SGZ3NRMDAyQJiH-DF4Ym2xwXC3iokf679A8OwrMf5GMdWztGIxxzk-M2ma1txveulLgQU0kMtHP81-4Gsdfy__RGZ5Zrbg0NURm4TV0qdi4bNCG90nEYWBAumVhSvCuUSY/s1600/3.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="366" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg4zA2Ykl_A6SGZ3NRMDAyQJiH-DF4Ym2xwXC3iokf679A8OwrMf5GMdWztGIxxzk-M2ma1txveulLgQU0kMtHP81-4Gsdfy__RGZ5Zrbg0NURm4TV0qdi4bNCG90nEYWBAumVhSvCuUSY/s400/3.jpg" width="400" /></a></i></div>
<div class="Default" style="margin-left: .25in; mso-list: l0 level1 lfo1; text-indent: -.25in;">
<br />
<span style="font-size: 11.5pt; mso-fareast-font-family: Calibri;"><span style="mso-list: Ignore;">5.<span style="font: 7.0pt "Times New Roman";">      
</span></span></span><span style="font-size: 11.5pt;">Ketikkan <i>Password
to open : </i>misalnya <i>123456, </i>kemudian ketikkan <i>Password to modify :
</i>misalnya </span><span style="font-size: 11.5pt;"><i><span style="font-size: 11.5pt;"><i>123456</i></span>, </i>kemudian klik tombol <i>OK. (Password to open dan
Password to modify bole sama / berbeda,,, sesuai selera ya gan,,, hehehee)</i></span></div>
<div class="Default" style="margin-left: .25in;">
<br /></div>
<div class="Default" style="margin-left: .25in; mso-list: l0 level1 lfo1; text-indent: -.25in;">
<br />
<span style="font-size: 11.5pt; mso-fareast-font-family: Calibri;"><span style="mso-list: Ignore;">6.<span style="font: 7.0pt "Times New Roman";">      
</span></span></span><span style="font-size: 11.5pt;">Masukkan sekali
lagi/ Ulangi <span style="mso-spacerun: yes;"> </span><i>password to open 123456,
</i>kemudian klik tombol <i>OK. </i></span></div>
<div class="MsoListParagraph">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiG3XmGGBJ55Rx5rduEVnU_H_rrHrSYz-dKMaqst6j2XyQgHVwK96IL3jQaU7AueComj2M0adif58Tn3FowcZ3rerBTTf09u0Hq1jipNanZBDtVGyg5kl8CLwBoFHMeaz7yMch8iPeE1j0/s1600/5.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="379" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiG3XmGGBJ55Rx5rduEVnU_H_rrHrSYz-dKMaqst6j2XyQgHVwK96IL3jQaU7AueComj2M0adif58Tn3FowcZ3rerBTTf09u0Hq1jipNanZBDtVGyg5kl8CLwBoFHMeaz7yMch8iPeE1j0/s400/5.jpg" width="400" /></a></div>
<div class="Default">
<span style="font-size: 11.5pt;"><br /></span></div>
<div class="Default" style="margin-left: .25in; mso-list: l0 level1 lfo1; text-indent: -.25in;">
<br />
<span style="font-size: 11.5pt; mso-fareast-font-family: Calibri;"><span style="mso-list: Ignore;">7.<span style="font: 7.0pt "Times New Roman";">      
</span></span></span><span style="font-size: 11.5pt;">Masukkan sekali
lagi/ Ulangi <i>password to modify</i></span><span style="font-size: 11.5pt;"><i><span style="font-size: 11.5pt;"><i>123456</i></span> , </i>kemudian klik tombol <i>OK, </i>dan
klik tombol <i>Save. </i></span></div>
<div class="Default" style="margin-left: .25in;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<i><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhKyiICZWJ2GIh1xqU_zRyuzpg2EzBMr-UYWylwvIC8wXn56bYAVdc1h4EXhdY-zRFcvB4uujULg_BMGz2-dCAC-7tRKDSLaULKotdPvSCYQoEB23bBS80UsyLE_AtRN52JV2LDjfItmQk/s1600/6.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="318" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhKyiICZWJ2GIh1xqU_zRyuzpg2EzBMr-UYWylwvIC8wXn56bYAVdc1h4EXhdY-zRFcvB4uujULg_BMGz2-dCAC-7tRKDSLaULKotdPvSCYQoEB23bBS80UsyLE_AtRN52JV2LDjfItmQk/s320/6.jpg" width="320" /></a></i></div>
<br />
<div class="Default" style="margin-left: .25in; mso-list: l0 level1 lfo1; text-indent: -.25in;">
<span style="font-size: 11.5pt; mso-fareast-font-family: Calibri;"><span style="mso-list: Ignore;">8.<span style="font: 7.0pt "Times New Roman";">      
</span></span></span><span style="font-size: 11.5pt;">Close file
tersebut</span></div>
<div class="MsoListParagraph">
<br />
<br /></div>
<div class="Default" style="margin-left: .25in; mso-list: l0 level1 lfo1; text-indent: -.25in;">
<span style="font-size: 11.5pt; mso-fareast-font-family: Calibri;"><span style="mso-list: Ignore;">9.<span style="font: 7.0pt "Times New Roman";">      
</span></span></span><span style="font-size: 11.5pt;">Klik <i>Office
Button > Open dan </i>Buka kembali file yang sudah tersimpan dengan password
</span></div>
<div class="Default" style="margin-left: .25in;">
<span style="font-size: 11.5pt;">Maka
akan muncul seperti ini:</span></div>
<div class="Default">
<br /></div>
<div class="Default">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhzRrab0swi7k7M5kzZzOynA56HS9WMQkgd7TPB8e6XaGeL85Z0yBX23B-V25fziY1de-6euIlZBiYEZesDOpbiUl0XVLtfcHasmN3eqXaVkQM4asUsR3eO33zdzt1ztFlAnKpCcn7cFlo/s1600/9.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="250" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhzRrab0swi7k7M5kzZzOynA56HS9WMQkgd7TPB8e6XaGeL85Z0yBX23B-V25fziY1de-6euIlZBiYEZesDOpbiUl0XVLtfcHasmN3eqXaVkQM4asUsR3eO33zdzt1ztFlAnKpCcn7cFlo/s400/9.jpg" width="400" /></a></div>
<div class="Default">
<span style="font-size: 11.5pt;">Maka gan,, kamu telah berhasil
menyimpan file excelnya dengan password.</span></div>
<div class="Default">
<span style="font-size: 11.5pt;">Selamat mencoba ya gan… </span></div>
</div>

Membuat Password Pada File Excel

Halo semua.. Anda ingin melindungi file anda dari orang yang tidak anda kehendaki? Pada bagian ini kita membahas file Excel. Kita la...

Baca selengkapnya »

<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
Halo sahabat semua,, kali ini kita akan membahas tentang
cara menampilkan tanggal dan waktu sekarang pada Microsoft Oficce Excel anda.<br />
<div class="MsoNormal">
Tanpa basi basi lagi kita langsung aja ya,, hehehe</div>
<div class="MsoNormal">
Oke,, sudah siap dengan excel nya,,, kita mulai,,,,1.. 2..
3..<br />
<ol>
<li>Tentukan pada cell mana ingin meletakkan tanggal
dan waktunya,</li>
<li>Pada cell tersebut ketiklah<b style="mso-bidi-font-weight: normal;"> </b></li>
</ol>
</div>
<b style="mso-bidi-font-weight: normal;">                                        =NOW()<span style="mso-spacerun: yes;">  </span>→ ENTER"</b><br />
<div class="MsoListParagraphCxSpLast" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj8Rm9M7trXA5SwKx-abxe1Jg0vysd_QKBNqQBSiWi6t1cUG527mZCNN3aWnQXE-afZ6kJff58EKEjtSIM14zCZts0KgvsvLdQiPCXGN-KPREINXFwLNHvfaAwf5m_8dqeWmgAMMCIOvfU/s1600/1.TANGGAL+SEKARANG..jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="216" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj8Rm9M7trXA5SwKx-abxe1Jg0vysd_QKBNqQBSiWi6t1cUG527mZCNN3aWnQXE-afZ6kJff58EKEjtSIM14zCZts0KgvsvLdQiPCXGN-KPREINXFwLNHvfaAwf5m_8dqeWmgAMMCIOvfU/s320/1.TANGGAL+SEKARANG..jpg" width="320" /></a> </div>
<div class="separator" style="clear: both; text-align: left;">
     </div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
 3.  Maka akan muncul hasil dari tanggal sekarang</div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhkpag7YHNZuTWPGsbl2fxaFt61nEzL5rh_OBH1gCql2T04iKAaieXmMEt9jX4GAtLcjSI2kRgmeMk9rqiR-ZnxJyx1hb2tztUw9ZWxhFcC7xG1VNPSQOSESoPJnzzuGj_yVsqsTPwh0DI/s1600/2+TANGGAL+SEKARANG..jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="206" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhkpag7YHNZuTWPGsbl2fxaFt61nEzL5rh_OBH1gCql2T04iKAaieXmMEt9jX4GAtLcjSI2kRgmeMk9rqiR-ZnxJyx1hb2tztUw9ZWxhFcC7xG1VNPSQOSESoPJnzzuGj_yVsqsTPwh0DI/s320/2+TANGGAL+SEKARANG..jpg" width="320" /></a></div>
<br />
Karena yang ditampilakan format standar maka
anda bole mengatur format tampilan dengan menggunakan<b style="mso-bidi-font-weight: normal;"> Format Cell</b></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoListParagraph">
<br /></div>
</div>

Menampilkan Tanggal Dan Waktu Sekarang Pada Microsoft Office Excel

Halo sahabat semua,, kali ini kita akan membahas tentang cara menampilkan tanggal dan waktu sekarang pada Microsoft Oficce Excel anda. T...

Baca selengkapnya »

Liza Afra Blog

Membuat Password Pada File Excel

Menampilkan Tanggal Dan Waktu Sekarang Pada Microsoft Office Excel

Popular

Categori