CARA MENCARI RECENT FILE EXCEL DARI AWAL

When using Microsoft Excel, Word, or PowerPoint, you may notice that recent documents are automatically saved and displayed for easy reference in the future. While this can be convenient, it can also compromise your privacy and create clutter on your screen. Fortunately, there are simple ways to remove these recent documents and keep your files hidden.

Cara Menghapus Recent Document di Excel/Word/PowerPoint

One way to remove recent documents in Microsoft Excel, Word, and PowerPoint is by disabling the Recent Items feature. Here’s how:

  1. Open Excel, Word, or PowerPoint.
  2. Click on the File tab in the top left corner of the screen.
  3. Click on Options at the bottom of the menu.
  4. Select Advanced on the left sidebar.
  5. Scroll down to the Display section.
  6. Change the number of Recent Documents to 0.
  7. Click OK to save changes.

Once you have completed these steps, recent documents will no longer be displayed on the screen. However, this does not remove the documents from the computer entirely.

If you want to completely remove the recent documents from your computer, you can follow these steps:

  1. Open the Start menu.
  2. Type %appdata% in the search box.
  3. Press Enter.
  4. Double-click on Microsoft.
  5. Double-click on Office.
  6. Click on the Recent folder.
  7. Delete all files in the folder.
Baca Juga :  Cara Membuat File Excel Agar View Tidak Bisa Dibuka

Note that this will permanently delete all recent documents in Microsoft Excel, Word, and PowerPoint.

Cara Menghilangkan Recent Files di Windows 10

Windows 10 also has a feature that displays recent files, which can be useful but also compromising. To remove recent files in Windows 10, follow these steps:

  1. Open the Start menu.
  2. Click on Settings (gear icon).
  3. Click on Personalization.
  4. Click on Start on the left sidebar.
  5. Toggle off Show recently opened items in Jump Lists on Start or the taskbar.
  6. Toggle off Show recently added apps.
  7. Close the Settings menu.

Once complete, recent files will no longer be displayed on the Start menu or taskbar.

FAQs

Q: Will removing recent documents affect my file history?

A: No, removing recent documents does not delete or alter the files themselves. It only removes the shortcuts and references to those files.

Q: Can I still access recently used files after I remove them?

A: Yes, you can still access recently used files through the Recent Files folder. To access the Recent Files folder in Excel, Word, or PowerPoint, click on the File tab, then click on Open. The Recent Files folder will be visible on the left sidebar. In Windows 10, you can access recent files by searching for them in the Search bar on the taskbar or by navigating to the Recent folder in File Explorer.

Video Tutorial

Cara Mencari Data yang Sama di Excel dengan Vlookup

Excel users often need to find and match data in different columns or worksheets. Fortunately, Excel has a built-in function called Vlookup that makes this task easy and efficient. Here are six ways to use Vlookup to find data in Excel:

  1. Exact Match Vlookup
  2. Approximate Match Vlookup
  3. Two-Way Lookup
  4. Case-Sensitive Vlookup
  5. Vlookup with Multiple Criteria
  6. Vlookup with IF Function
Baca Juga :  Cara Membuat Control Di Excel 2007

Exact Match Vlookup

The first and most common way to use Vlookup is for exact matching. This means that the function will find and return the exact match for the lookup value in the table array. Here’s an example:

CARA MENCARI RECENT FILE EXCEL DARI AWAL

In this example, we want to find the exact match for the employee ID “E101”. We use the Vlookup formula =VLOOKUP(“E101”,A2:B6,2,FALSE), which looks for the lookup value “E101” in the first column of the table array (A2:B6) and returns the corresponding value in the second column.

Approximate Match Vlookup

The second way to use Vlookup is for approximate matching. This means that the function will find and return the closest match for the lookup value in the table array. Here’s an example:

Approximate Match Vlookup Example

In this example, we want to find the range that the score of 93 falls into. We use the Vlookup formula =VLOOKUP(93,B2:C7,2,TRUE), which looks for the lookup value 93 in the first column of the table array (B2:C7) and returns the corresponding value in the second column. Note that we set the fourth argument to TRUE to indicate that we want approximate matching.

Two-Way Lookup

The third way to use Vlookup is for two-way lookups, which means that the function will find and return a value that matches two criteria instead of one. Here’s an example:

Two-Way Lookup Vlookup Example

In this example, we want to find the salary of the employee with ID “E103” and designation “Developer”. We use the Vlookup formula =VLOOKUP(“E103”,A2:D8,MATCH(“Developer”,A1:D1,0),FALSE), which first uses the MATCH function to find the column index of “Developer” in the top row of the table array (A1:D1), then uses Vlookup to find the salary for the matching employee ID in the first column.

Baca Juga :  CARA MEMBERSIHKAN DAFTAR FILE EXCEL

Case-Sensitive Vlookup

The fourth way to use Vlookup is for case-sensitive matching, which means that the function will differentiate between uppercase and lowercase letters. Here’s an example:

Case-Sensitive Vlookup Example

In this example, we want to find the name of the employee with ID “e102”. We use the Vlookup formula =VLOOKUP(“e102”,A2:B6,2,FALSE), with the lookup value in lowercase letters, and get an error because Excel cannot find an exact match. We then use the Vlookup formula =VLOOKUP(“e102”,A2:B6,2,FALSE), with the lookup value in uppercase letters, and get the correct result.

Vlookup with Multiple Criteria

The fifth way to use Vlookup is for finding data that matches multiple criteria, such as two or more columns. Here’s an example:

Vlookup with Multiple Criteria Example

In this example, we want to find the experience of the employee who has ID “E102” and designation “Developer”. We use the Vlookup formula =VLOOKUP(“E102″&”Developer”,A2:D8,4,FALSE), which combines the two criteria into one lookup value and looks for it in the first column of the table array.

Vlookup with IF Function

The sixth way to use Vlookup is in combination with the IF function, which allows for more complex calculations and conditions. Here’s an example:

Vlookup with IF Function Example

In this example, we want to find the salary grade of the employee with ID “E104”. We use the IF function to create a condition that checks whether the salary falls within a certain range, then uses Vlookup to return the corresponding grade. The formula is =IF(F4<=40000,"G1",IF(F4<=60000,"G2",IF(F4<=80000,"G3","G4"))), where F4 is the cell with the Vlookup formula.

Video Tutorial