CARA BERBAGI FILE EXCEL TANPA BENTROK SAVE

Sharing files has never been easier with the availability of various cloud storage services. One of the popular services is iCloud, which is available for Apple users. In this article, we will discuss how to share files that are stored in iCloud folder.

Step by Step Guide to Share Files in iCloud

Follow these simple steps to share files in iCloud:

  1. Open the iCloud folder on your computer or device.
  2. Select the file you want to share.
  3. Right-click on the file and select “Share”.
  4. Enter the email address of the person you want to share the file with.
  5. Choose the permission level for the recipient: “Can make changes” or “View only”.
  6. Add a message (optional).
  7. Click “Share”.

That’s it! The recipient will receive an email with a link to the shared file. If the recipient doesn’t have an Apple ID, they can create one for free to access the file.

How to Open Locked Excel File without Application

Have you ever encountered a locked Excel file that you need to access urgently but don’t have the password? Don’t worry, we have a solution for you.

Follow these steps to open a locked Excel file without any application:

  1. Open the Excel file in a zip utility tool like WinZip or WinRAR.
  2. Locate the “xl” folder.
  3. Find the “workbook.xml” file in the “xl” folder and open it using a text editor like Notepad.
  4. Find the “sheetProtection” element and delete it.
  5. Save the “workbook.xml” file.
  6. Close the zip utility tool and open the Excel file as usual.
Baca Juga :  CARA BUAT ENTRI DATA DI EXCEL

That’s it! You can now access the previously locked Excel file without the password.

How to Create Class Schedule with Excel without Overlapping

Creating a class schedule can be a daunting task, especially if you have a lot of classes and limited time slots. However, with Excel, you can easily create a class schedule without any overlapping.

Follow these steps to create a class schedule without overlapping:

  1. Open a blank Excel sheet.
  2. Enter the days of the week in the first row and the time slots in the first column.
  3. Enter the class names in the corresponding cells.
  4. Select the range of cells where you want to insert the formula.
  5. Enter the formula “=COUNTIF(range,cell)=1” in the formula bar and press Enter.
  6. Copy the formula and paste it into the remaining cells in the range.
  7. Format the cells to highlight any overlaps.
  8. Save the Excel sheet and print the class schedule.

That’s it! You now have a class schedule without any overlapping.

Frequently Asked Questions

1. Is iCloud Storage Free?

Apple offers 5GB of free iCloud storage to all users. If you need more storage, you can upgrade to a paid plan.

2. Can I Access iCloud Files from a Windows Computer?

Yes, you can access iCloud files from a Windows computer by downloading and installing the iCloud for Windows app. The app allows you to access your iCloud Drive, Photos, and other iCloud services from your Windows PC.

Video Tutorial: How to Share Files in iCloud

Check out this video tutorial on how to share files in iCloud:

With these tips and tricks, you can easily share files in iCloud, open locked Excel files, and create class schedules without overlapping. Take advantage of these tools and simplify your work today!

Baca Juga :  cara membuat mail marge pake data excel Merge gambar hasilnya mailing melihat diperlihatkan privew ruanglaptop