CARA MERUBAH HARI BAHASA INGGRIS KE INDONESIA DI EXCEL

Do you need to change the language settings on Excel from English to Indonesian? If so, you’ve come to the right place! This article will guide you through the steps to change the language settings on your Excel program. Whether you need to change the month or day names, we’ve got you covered.

How to Change the Month Names from English to Indonesian in Excel

If you’re working on a spreadsheet and find that the month names are in English, but you prefer them in Indonesian, don’t worry! It’s easy to change them in Excel.

First, you should check which version of Excel you’re using. The steps to change the language settings differ between Excel 2016/2019 and Excel 2010/2013.

Excel 2016/2019

  1. Open a new or existing workbook in Excel.
  2. Click on the File tab in the top left corner of the screen.
  3. Click on Options.
  4. In the Excel Options dialog box, click on Language.
  5. From the Choose Editing Languages drop-down menu, select Indonesian.
  6. Click on the Set as Default button to make this your default language.
  7. Click on OK to save changes and close the Excel Options dialog box.
  8. Restart Excel for the changes to take effect.
Baca Juga :  CARA CEPAT SELECT ALL DATA DI SHEET EXCEL

Excel 2010/2013

  1. Open a new or existing workbook in Excel.
  2. Click on the File tab in the top left corner of the screen.
  3. Click on Options.
  4. In the Excel Options dialog box, click on Language.
  5. In the Choose Display Language section, click on Choose Editing Languages.
  6. From the Choose Editing Languages drop-down menu, select Indonesian.
  7. Click on Add.
  8. Click on the Set as Default button to make this your default language.
  9. Click on OK to save changes and close the Excel Options dialog box.
  10. Restart Excel for the changes to take effect.

How to Change the Day Names from English to Indonesian in Excel

If you need to change the day names in Excel from English to Indonesian, these steps will show you how.

Excel 2016/2019

  1. Open a new or existing workbook in Excel.
  2. Click on the File tab in the top left corner of the screen.
  3. Click on Options.
  4. In the Excel Options dialog box, click on Language.
  5. From the Choose Editing Languages drop-down menu, select Indonesian.
  6. Click on the Calendar tab.
  7. From the First day of week: drop-down menu, choose Senin.
  8. Click on OK to save changes and close the Excel Options dialog box.
  9. Restart Excel for the changes to take effect.

Excel 2010/2013

  1. Open a new or existing workbook in Excel.
  2. Click on the File tab in the top left corner of the screen.
  3. Click on Options.
  4. In the Excel Options dialog box, click on Language.
  5. In the Choose Display Language section, click on Choose Editing Languages.
  6. From the Choose Editing Languages drop-down menu, select Indonesian.
  7. Click on Add.
  8. Click on the Calendar tab.
  9. From the First day of week: drop-down menu, choose Senin.
  10. Click on OK to save changes and close the Excel Options dialog box.
  11. Restart Excel for the changes to take effect.
Baca Juga :  CARA MERUBAH FILE EXCEL KE CSV MANUAL

FAQ

Here are some frequently asked questions about changing the language settings on Excel:

Q: Why do I need to change the language settings on Excel?

A: If you’re working with a team of people who speak Indonesian, or if you’re based in Indonesia and need to use Indonesian names for months and days, changing the language settings can make your work easier and more efficient.

Q: Do I need to restart Excel after changing the language settings?

A: Yes, you do. These changes will not take effect until you restart Excel. Make sure to save any work before closing the program.

Here’s a video tutorial on how to change the language settings on Excel:

We hope this article has been helpful in guiding you through the steps to change the language settings on Excel. Whether you need to change the month or day names, these steps will allow you to work in Indonesian easily and efficiently. If you have any further questions, feel free to ask in the comments below.