CARA MELIHAT FILE EXCEL TANPA HARUS DIBUKA

Working with Microsoft Excel is inevitable in the modern world. People utilize this application in their workplaces, schools, and even at their homes. Excel is widely used because it is incredibly user-friendly and can be employed for various applications. However, sometimes users face problems while utilizing Excel, such as printing issues, password protection, and file accessibility. In this article, we will discuss solutions to these common Excel problems.

How to Print Excel Sheets Without Trimming?

When printing Excel sheets, users often face problems with trimming. Meaning, the data from the sheet is not printed entirely in the final output. Here’s how to solve the problem:

  1. Initially, select the sheet from Excel that you intend to print.
  2. Click on the ‘Page Layout’ tab which is located at the top of your screen.
  3. Once you’ve clicked on the ‘Page Layout’ tab, there is a ‘Page Setup’ group. Here, select the small arrow located at the bottom-right of the group.
  4. Click on the ‘Page Setup Dialog Box’ to appear from the bottom-right of the screen.
  5. Once you click on it, select the ‘Margins’ tab from the top of the ‘Page Setup Dialog Box.’
  6. From the ‘Margins’ tab, ensure that the values within the ‘Left,’ ‘Right,’ ‘Top,’ and ‘Bottom’ are set to 0.33 inches.
  7. From the same ‘Margins’ tab, you can adjust the ‘Header’ and ‘Footer’ margins if required.
  8. Now, select the ‘Page’ tab from the top of the ‘Page Setup Dialog Box.’
  9. From the ‘Page’ tab, change the ‘Page Orientation’ to ‘Landscape’
  10. After this, set the ‘Scaling’ option to ‘Adjust to ____% normal size.’
  11. Finally, click on the ‘Print Preview’ button to ensure that your sheet will be printed accurately.

How to Open a Password-Protected Excel File?

Opening a password-protected Excel file can be challenging if you don’t remember the password. But don’t worry, there are several ways that you can bypass Excel’s password protection. Here are a few methods that you can try:

Method 1: Use VBA Code to Bypass Password Protection

Visual Basic for Applications (VBA) is an integral part of Excel and can be utilized to bypass its password protection. Here’s how:

  1. Open the password-protected Excel file.
  2. Press ALT + F11 to open the VBA editor.
  3. Once the VBA editor is open, navigate to ‘Insert’ on the top menu bar and select ‘Module.’
  4. Once you have selected ‘Module,’ the VBA editor will open a new blank module.
  5. Type in the following code:

Sub PasswordBreaker()
‘Breaks worksheet password protection.
Dim i As Integer, j As Integer, k As Integer
Dim l As Integer, m As Integer, n As Integer
Dim i1 As Integer, i2 As Integer, i3 As Integer
Dim i4 As Integer, i5 As Integer, i6 As Integer
On Error Resume Next
For i = 65 To 66: For j = 65 To 66: For k = 65 To 66
For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66
For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66
For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126
ActiveSheet.Unprotect Chr(i) & Chr(j) & Chr(k) & _
Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
If ActiveSheet.ProtectContents = False Then
MsgBox “One usable password is ” & Chr(i) & Chr(j) & _
Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _
Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
Exit Sub
End If
Next: Next: Next: Next: Next: Next
Next: Next: Next: Next: Next: Next
End Sub

  1. After you have pasted the code, exit the ‘VBA Editor’ and then click on ‘Run (play button icon)’
  2. If the process works successfully, the password will now be displayed on the screen.
Baca Juga :  CARA MEMBUAT FORMAT KOLOM DI EXCEL

Method 2: Use an Excel Password Recovery Tool

If you find method 1 to be difficult, you can employ third-party Excel password recovery tools. Here are a few of the most widely used:

  • Stellar Phoenix Excel Password Recovery – This tool is user-friendly and allows you to extract the passwords of Excel files. You can download the free trial version from the company’s website.
  • Excel Key – This tool allows you to remove the open and write passwords as well as VBA password protection from Excel files. You can download the free trial version from the company’s website.
  • Accent EXCEL Password Recovery – This tool is an excellent choice for those who forgot their password. Accent EXCEL password recovery uses several mode-based attacks to restore that credential. The tool is not free; you have to pay a one-time fee for a lifetime user license.

Why Can’t I Open My Excel File?

Many reasons could prevent you from opening an Excel file, such as Virus attacks, system updates, incomplete upgrades, storage issues, and others. Here are a few methods to open your Excel file:

Method 1: Open Excel in Safe Mode

Opening Excel in safe mode is helpful if you have add-ins that are causing the sheet not to open. Simply follow these steps:

  1. Close the Excel app if it’s on your display.
  2. Hold down the ‘Ctrl’ key while opening Excel by clicking on its icon.
  3. A warning message will appear. Click on ‘Yes.’
  4. You will enter Safe Mode. Navigate to the ‘File’ option at the top-left of your screen.
  5. Select ‘Open,’ and then select the Excel sheet you want to open.

Method 2: Repair Excel File

If the Excel sheet is damaged, you might fail to open it with the regular methods. Excel has an integrated recovery function that can fix a corrupted sheet. Here are the steps to follow:

  1. Open Excel.
  2. Click on the ‘File’ menu, and then select ‘Open.’
  3. Select the corrupted Excel sheet that you want to recover.
  4. When you select the damaged file, click on the arrow button next to the ‘Open’ button. Select ‘Open and Repair.’
  5. Excel will prompt you to back up the file before attempting recovery.
  6. Select ‘Repair,’ and then click ‘OK’ to begin the process. It could take a couple of minutes to complete.
  7. If the file is successfully fixed, save it to a new location to avoid any future issues.

FAQs:

1. Is there any risk in using online Excel password recovery tools?

There can be a risk when using online Excel password recovery tools as they can potentially exploit security vulnerabilities on the user’s device. Always research password recovery tools before utilizing them to digitize your Excel sheets.

2. Can I protect my Excel sheet without password protection?

Yes, you can protect your Excel sheet without password protection. Security is incredibly important, and password protecting your sheet is one of the ways to keep data safe and secure. However, you can also protect the sheet with the ‘Protect Sheet’ option or file protection straightforwardly. All of these options can be found in ‘File’ > ‘Protection’ > ‘Protect Sheet.’

Lastly, if you’re more of a visual learner, check out the video below for a step-by-step guide:

Video: