CARA BUKA FILE FINGERPRINT DI EXCEL

Have you ever encountered a ZIP file that is password protected? It can be quite frustrating to not be able to access the contents of the file, especially if it contains important information. But fret not, in this article we will guide you on how to open a password protected ZIP file on both your mobile phone and laptop.

Opening a Password Protected ZIP File on Mobile Phone

It is quite easy to open a password protected ZIP file on your mobile phone. All you need is a file manager app and an app to unzip the file.

Baca Juga :  CARA MEMBUAT TULISAN MIRING DI MICROSOFT EXCEL

Step 1: Download a File Manager App

You can download a file manager app from the Google Play Store or App Store. Some popular file manager apps are:

  • ES File Explorer
  • Astro File Manager
  • File Manager

Step 2: Download an App to Unzip the File

There are many apps on the Google Play Store and App Store that can unzip files. Some popular apps are:

  • WinZip
  • ZArchiver
  • RAR

Step 3: Open the File Manager App

Open the file manager app and locate the ZIP file that you want to unzip. Tap and hold on the file to select it.

Step 4: Unzip the File

After selecting the file, tap on the “Unzip” or “Extract” button on the app. You will then be prompted to enter the password. Once you have entered the correct password, the file will be unzipped and you can access its contents.

Opening a Password Protected ZIP File on Laptop

Opening a password protected ZIP file on your laptop requires you to have software that can unzip the file. Here are the steps to do that:

Step 1: Download a ZIP File Extractor Software

You can download software to extract ZIP files from the internet. Some popular software are:

  • WinZip
  • 7-Zip
  • WinRAR

Step 2: Install the Software

Once you have downloaded the software, install it on your laptop.

Step 3: Open the ZIP File Extractor Software

Open the ZIP file extractor software and locate the password protected ZIP file that you want to unzip by clicking on the “File” tab and selecting “Open”.

Baca Juga :  Cara Menghitung Diskon Di Excel Menggunakan If

Step 4: Enter the Password

You will be prompted to enter the password. Once you have entered the correct password, click on the “Extract” or “Unzip” button and the file will be extracted.

Cara Buka Password Excel | How to Open Password Protected Excel File

Excel is a widely used software for data analysis and storage. It is important to secure the data stored in Excel sheets by protecting it with a password. However, sometimes we may forget the password and not be able to access the data. In this section, we will guide you on how to open a password protected Excel file.

Step 1: Create a Duplicate Copy of the Excel File

Create a duplicate copy of the password protected Excel file by selecting the file and pressing “Ctrl + C” to copy and “Ctrl + V” to paste it.

Step 2: Rename the File Extension

Right click on the duplicate copy and select “Rename”. Change the file extension from .xlsx to .zip and click “Enter”.

Step 3: Extract the ZIP File

Open the ZIP file extractor software and select the .zip file that you just renamed. Extract the contents of the file to a specific folder.

Step 4: Edit the XML File

Open the extracted folder and go to the folder named “xl”. Inside that folder, you will find a file named “workbook.xml”. Open the file in any text editor and search for the tag “<sheetProtection”. You will find the password that you have set for the Excel file.

Step 5: Remove the Password

Delete the “<sheetProtection” tag and save the file. This will remove the password protection from the Excel file.

Baca Juga :  Cara Mencari Jangkauan Data Kelompok Di Excel

Cara Buka File SHP | How to Open Shapefile

Shapefile is a popular file format for storing geospatial data. It is commonly used in GIS software. If you have a shapefile that you want to open, you can follow these steps:

Step 1: Download AutoCAD Map 3D

AutoCAD Map 3D is a software that can be used to open shapefiles. You can download it from the official Autodesk website.

Step 2: Install AutoCAD Map 3D

After downloading the software, install it on your laptop.

Step 3: Open AutoCAD Map 3D

Open AutoCAD Map 3D and click on the “Insert” tab. Select “Import” from the drop-down menu and then click on “Import SHP”.

Step 4: Locate the SHP File

Locate the SHP file that you want to open and click on “Open”. The shapefile will then be imported into the software.

FAQ

1. What should I do if I forgot the password for a ZIP file?

If you forgot the password for a ZIP file, you can try using a password recovery tool. Some popular tools are:

  • Zip Password Recovery
  • Accent ZIP Password Recovery
  • Passware Kit

2. Can I open a password protected Excel file on my mobile phone?

Yes, you can open a password protected Excel file on your mobile phone by downloading an app that can open Excel files. Some popular apps are:

  • Microsoft Excel
  • Google Sheets
  • WPS Office

Video Tutorial: How to Open a Password Protected ZIP File on Laptop