[en] Show Deletion Tools

With this feature you can easily delete things.

Before you press Okay, you first have to choose what area that will effect:

• Selected Range
• Active Sheet
• Active Book

Then select from the available options:

1. Conditional formatting: remove conditional formats
2. Data Validation: delete data validation
3. Formulas: delete the formula and change the formula into value
4. Values: delete the value (become empty cells)
5. Format: deleting formats
6. Hyperlinks: remove hyperlinks and turn it into value
7. Names: Clear Names definition

Read More

[id] Show Deletion Tools

Dengan fitur ini Anda dapat dengan sangat mudah menghapus banyak hal.

Sebelum Anda menekan tombol Okay, Anda harus memilih terlebih dahulu area mana saja yang akan efek pada perintah yang akan dijalankan:

• Selected Range: range yang terseleksi
• Active Sheet: sheet yang sedang aktif
• Active Book: workbook yang sedang aktif

Kemudian pilih dari opsi yang tersedia:

1. Conditional Formatting: menghapus format kondisional
2. Data Validation: menghapus validasi data
3. Formulas: menghapus rumus dan merubahnya menjadi nilai value
4. Values: menghapus nilai (menjadi sel kosong)
5. Format: menghapus format
6. Hyperlinks: menghapus link dan merubahnya menjadi nilai value
7. Names: menghapus definisi Names

Read More

[en] Show Calculation Tools

Is your Excel is additional Add-Ins that require you to select manual calculation? With this feature you can select the calculation you want. Is it only a range, entire sheet, a workbook, or even entire workbook?

The following options are available:

1. Calculate Selected Range
2. Calculate Active Sheet
3. Calculate Active Workbook
4. Calculate All Workbooks

Note:
If you chose the 3rd option, you will be asked which sheets that will be calculated as the following picture:

Read More

[id] Show Calculation Tools

Apakah Anda menggunakan Add-Ins tambahan yang mengharuskan Anda untuk memilih kalkulasi manual (Manual Calculation)? Dengan perintah ini Anda bisa memilih kalkulasi yang ingin Anda lakukan. Apakah hanya sebatas range, seluruh sheet, satu workbook, atau bahkan seluruh workbook?

Berikut opsi yang tersedia:

1. Calculate Selected Range: Hanya mengkalkulasi range
2. Calculate Active Sheet: Mengkalkukasi sheet yang aktif
3. Calculate Active Workbook: Mengkalkulasi workbook yang aktif
4. Calculate All Workbooks: Mengkalkulasi seluruh workbook

Catatan:
Jika Anda memilih pilihan ke-3, Anda akan ditanya sheet mana saja yang akan dikalkulasi seperti gambar berikut:

Read More

[en] Save Sheet As Workbook

This feature helps you when you want to save the active sheet as a separate workbook. It's easier than doing the command Move or Copy ... > (New book)> File Save As. You will be asked to specify the directory and file name.

Read More

[id] Save Sheet As Workbook

Fitur ini bisa Anda gunakan saat Anda ingin menyimpan sheet yang sedang aktif menjadi file workbook yang terpisah. Lebih mudah daripada melakukan perintah Move or Copy... > (new book) > File Save As. Anda akan diminta untuk menentukan direktori dan nama filenya.

Read More

[en] Rename Active Workbook While Open

Do you ever feel want to change the current's workbook file name you are opening? Of course, without this feature it can not be done instantly. You certainly have to close the first file, open Windows Explorer, find the directory and then change its name.

When you run this command you must first find the directory where the file is located, and then rename the file in the File name field.

Tips: You can use the the Open Dialog Box With Current's Files folder feature and select Cancel, and run this feature again.

Read More