CARA MENGARSIKAN FILE EXCEL DI FOLDER

Welcome to our latest article where we will share some tips and tricks related to Microsoft Excel, Windows operating system, and Android Studio. In this article, you will learn how to recover a saved file in Excel, how to create a new folder in Windows, and how to share files or folders in Windows. Moreover, we will also guide you about how to unprotect a sheet in Microsoft Excel and how to display text and images in the assets folder of Android Studio. So, let’s get started!

Recovering a saved file in Excel

Have you ever lost an important Excel file that you spent hours creating and editing? If yes, then you know how frustrating it can be. Fortunately, there is a way to recover a saved file in Excel. Here’s how:

1. Open the Excel application and go to the File tab.
2. Select the Open option and navigate to the location where the file was saved.
3. Click on the dropdown arrow next to the “Open” button.
4. Select “Open and Repair” from the dropdown menu.
5. Choose either “Repair” or “Extract Data” depending on your needs. The “Repair” option attempts to recover the entire file, while “Extract Data” only recovers the data.
6. Click on “OK” to start the recovery process.

After the process completes, you should be able to access your file. If this process doesn’t restore your file, you may want to try searching for an unsaved version of the file. Excel creates a temporary copy of the file every few minutes. Here’s how to check for an unsaved version:

1. Open Excel and go to the File tab.
2. Select “Info” from the left-hand menu.
3. Click on “Manage Workbook.”
4. Choose “Recover Unsaved Workbooks.”
5. Select the unsaved file you want to restore, and click “Open.”
6. Save the file with a new name immediately to avoid losing any work.

Creating a new folder in Windows

If you are new to Windows or are still learning how to use it, creating a new folder can seem like a daunting task. Fortunately, creating a new folder in Windows is very easy. Here’s how:

1. Go to the location where you want to create the new folder.
2. Right-click on a blank area in the folder window.
3. Select the “New” option from the dropdown menu.
4. Select “Folder” from the next dropdown menu.
5. Type in a name for the new folder.
6. Press Enter to create the new folder.

You can now move files and other folders into your new folder. This can help you organize your files and keep your computer tidy.

Sharing files or folders in Windows

Sharing files or folders on your computer can be helpful if you need to collaborate with other people on a project or if you need to give someone access to important files. Windows makes it easy to share files or folders over a network. Here’s how:

1. Right-click on the file or folder you want to share.
2. Select “Properties” from the dropdown menu.
3. Select the “Sharing” tab.
4. Click “Advanced Sharing.”
5. Check the box next to “Share this folder.”
6. Type in a name for the share.
7. Click “Permissions” to set permissions for the share.
8. Click “OK” to save your changes.

Your file or folder is now shared over the network. The people you want to share the file or folder with will need to know the name of the share and have access to the network you’re sharing it on. They will also need the appropriate permissions to access the file or folder.

Unprotecting a sheet in Microsoft Excel

Protecting a sheet in Microsoft Excel can be helpful to prevent accidental deletion or modification of important data. However, if you forget the password or if you need to edit the protected sheet, you may need to unprotect it. Here’s how:

1. Open the protected Excel file and go to the Review tab.
2. Select “Unprotect Sheet” from the “Changes” group.
3. Enter the password if prompted.
4. Click “OK.”

The sheet is now unprotected, and you can make changes to it. Remember to protect the sheet again after you are done editing it to prevent accidental changes.

Displaying text and images in the assets folder of Android Studio

If you are an Android app developer, you may need to display text or images in the assets folder of your project. Here’s how:

1. Open Android Studio and create a new project.
2. Open the “app” folder and create a new folder called “assets.”
3. Right-click on the “assets” folder and select “New” > “File.”
4. Name the file and give it an appropriate extension (e.g., .txt for a text file or .jpg for an image).
5. Copy the text or image file you want to display into the “assets” folder.
6. In your code, use the AssetManager to access the file and display it. For example, to display a text file, you can use the following code:

“`java
AssetManager assetManager = getAssets();
InputStream input = assetManager.open(“filename.txt”);
int size = input.available();
byte[] buffer = new byte[size];
input.read(buffer);
input.close();
String text = new String(buffer);
“`

You can then display the text wherever you need it in your app.

Frequently Asked Questions (FAQs)

Q: Can I recover a file in Excel if I didn’t save it?

A: If you didn’t save an Excel file, there is a chance that you can still recover it. Here’s how:

1. Open Excel and go to the “File” tab.
2. Select “Options” from the left-hand menu.
3. Click on “Save.”
4. Copy the “AutoRecover file location” path.
5. Navigate to that path in Windows Explorer.
6. Look for a file with the .xar extension.
7. Open the file in Excel and save it with a new name immediately to avoid losing any work.

Q: How do I change the permissions on a shared file or folder in Windows?

A: To change the permissions on a shared file or folder in Windows, follow these steps:

1. Right-click on the file or folder you want to change the permissions for.
2. Select “Properties” from the dropdown menu.
3. Select the “Sharing” tab.
4. Click “Advanced Sharing.”
5. Click “Permissions” to change the permissions for the share.
6. Select the user or group you want to change the permissions for.
7. Click “Edit.”
8. Select the permissions you want to grant or deny.
9. Click “OK” to save your changes.

Conclusion

We hope you found this article helpful and learned something new. Recovering a saved file in Excel, creating a new folder in Windows, and sharing files or folders are fundamental skills that every computer user should know. Additionally, unprotecting a sheet in Microsoft Excel and displaying text and images in the assets folder of Android Studio can be helpful for developers. If you have any questions or comments, feel free to leave them in the comments section below.