CARA MENGEMBALIKAN FILE YANG DI HIDE PADA EXCEL

Microsoft Office applications such as MS Word and Excel are widely used by individuals and businesses alike for various purposes such as writing documents, creating spreadsheets, and analyzing data. However, one of the most frustrating things that can happen while working on these applications is losing unsaved work. In this article, we will discuss ways to recover unsaved files in MS Word and Excel as well as how to hide columns and rows in Excel.

Recovering Unsaved Files in MS Word and Excel

Have you ever been working on a document in MS Word or a spreadsheet in Excel only to realize that you forgot to save it? Or maybe the application crashed before you could save your work? Don’t worry, there are ways to recover unsaved files in both MS Word and Excel.

Recovering Unsaved Files in MS Word

If you are using MS Word 2010 or newer versions, the application has an AutoRecover feature that automatically saves a copy of your work every few minutes. You can recover unsaved files by following these steps:

1. Open MS Word
2. Click on “File” on the top-left corner of the window
3. Click on “Info”
4. Click on “Manage Document”
5. Select “Recover Unsaved Documents” if you are using MS Word 2010; select “Recover Unsaved Workbooks” if you are using Excel
6. Find the unsaved file and click “Open”
7. Save the file with a new name

If you are using an older version of MS Word that does not have the AutoRecover feature, you can try the following steps:

1. Open MS Word
2. Click on “File”
3. Click on “Recent”
4. Scroll to the bottom of the page and click “Recover Unsaved Documents”
5. Select the unsaved file and click “Open”
6. Save the file with a new name

Recovering Unsaved Files in Excel

If you are using Excel 2010 or newer versions, the application has an AutoRecover feature similar to MS Word. You can recover unsaved files by following these steps:

1. Open Excel
2. Click on “File” on the top-left corner of the window
3. Click on “Info”
4. Click on “Manage Workbook”
5. Select “Recover Unsaved Workbooks”
6. Find the unsaved file and click “Open”
7. Save the file with a new name

If you are using an older version of Excel that does not have the AutoRecover feature, you can try the following steps:

1. Open Excel
2. Click on “File”
3. Click on “Recent”
4. Scroll to the bottom of the page and click “Recover Unsaved Workbooks”
5. Select the unsaved file and click “Open”
6. Save the file with a new name

Hiding Columns and Rows in Excel

In Excel, you might want to hide certain columns or rows to make your spreadsheet look cleaner or to hide sensitive information from others who do not need to see it. Hiding columns and rows in Excel is a relatively simple process that can be done in a few clicks. Here’s how:

1. Select the columns or rows you want to hide by clicking on the column or row letters or numbers
2. Right-click on the selection and click on “Hide” from the drop-down menu
3. The selected columns or rows will now be hidden

If you want to unhide the hidden columns or rows, you can do so by following these steps:

1. Select the columns or rows that are adjacent to the hidden columns or rows
2. Right-click on the selection and click on “Unhide” from the drop-down menu
3. The hidden columns or rows will now be visible again

Frequently Asked Questions (FAQ)

1. Can I recover an Excel file that was deleted?

Yes, you can recover an Excel file that was deleted by looking in the Recycle Bin or using a file recovery software. In the Recycle Bin, you can right-click on the deleted file and click on “Restore” to recover it. If the file is not in the Recycle Bin, you can try using a file recovery software such as Recuva or EaseUS Data Recovery to recover the file.

2. Can I recover an MS Word document that I accidentally closed without saving?

If you accidentally closed an MS Word document without saving it, you may still be able to recover it using the AutoRecover feature. Open MS Word and click on “File”, “Info”, “Manage Document,” and select “Recover Unsaved Documents” or use the steps mentioned earlier in the article. If the AutoRecover feature did not save a copy of the document, unfortunately, there is no way to recover the unsaved work.

Conclusion

Working with MS Word and Excel can be a breeze until you lose unsaved work or accidentally reveal sensitive information. However, as we’ve seen in this article, there are ways to recover unsaved files using the AutoRecover feature and to hide columns and rows in Excel. By following these tips, you can save yourself a lot of time and frustration in the future.