Where Deleted MS Excel Files Go, If it is not in Recycle Bin?

If you are the regular user of MS Excel application, then you must have face the problem of unintentional deletion of Excel file. Generally, the deleted files get in to the Recycle Bin but if your deleted file is not in Recycle Bin then this creates a problem for you. In this blog, you will read how you can recover your deleted files which are not in Recycle Bin. If you want more assistance, then you can contact to the expert of MS Office through www.office.com/setup.

Recover Deleted MS Excel File, When not in Recycle Bin:Office.com/setup

Method 1: Retrieve unsaved Excel File or Workbook:

MS Excel has inbuilt file recovery tools through which you can recover Excel data.

1: Auto Recover File Location:

For this, you have to open your Excel workbook and then click on File tab. Then you should select the Options which are at the bottom. In the next Window, you have to click on the Save option. Now, there is a Auto Recover file location. And it has the path of your auto saved document. You just have to copy this path. After this, open your File Explorer and paste the path and hit enter key. Here you will see the last save of your document and it starts with the name “MYDOC.” Just click on it to open the file. You have to right-click on the Microsoft Excel Binary file and then select Open option. At the end, select Excel and click on Ok button.

2: Recover From Recent File Option:

First, open your Excel file and click on “File” option. Now from the File menu, you have to choose the Open. In the opened Window, you will see the option “Recover Unsaved Workbooks” and just click on it. Here you have to Search for the Excel file which you need to recover. When you get it, just click on save option. This helps to retrieve your Excel workbook. #Office.Com/Myaccount

Method 2: Retrieve The Deleted Excel File That Has Been Saved:

1: Try Automatic Solution For Deleted Excel File Recovery:

If you want to recover deleted Excel file which you do not found in Recycle Bin then you should use the Excel Recovery tool. This tool helps to recover corrupt/deleted Excel files in few minutes and this tool also helps in fixing Excel error. Through this, you can recover your deleted chart sheet, table, cell comment, image, cell comment, formula etc.

2: Restoring Files From Backup:

For this, first you should go to your system Control Panel and then select Backup and Restore option. After this, click on Restore my files option and follow the instructions in the wizard.

3: Restoring Excel Files From Previous Version:

For this, first you have to go to the folder, which contains your deleted Excel file. You have to right click on it and just click on ‘Restore previous versions’. You will see the list file version and you have to choose Excel version from that list.

This method helps to recover your files when it is not in Recycle bin. But if you want more information then just visits to the site of MS Office via www.office.com/setup.

Advanced MS Excel Skills You Should Know

Microsoft Office is the excellent software which is consists of many applications like MS Word, MS Excel, MS PowerPoint and Outlook. You can install this excellent software through office.com/setup. This software helps the common computer user, a professional. It gives user friendly interface and supports all the gadgets like Window OS, Mac, Computers, Laptops and Android Phones. It saves lot of time and money of the customer. It increases the productivity of the organization and helps the employees to do their work efficiently and effectively. MS Excel is the very useful application of MS Office and it is used for creating spreadsheets. Those who are the regular user of MS Excel must know the advanced skills of MS Excel. In this blog, you will read the advanced skills of MS Excel which everybody should know.

Read Also – How to Repair Corrupt MS PowerPoint File?

What are the Advanced Skills of MS Excel?

  1. Choose the Right Layout: The first thing for creating a spreadsheet, you should do a little planning. Then you should understand your data, and make a layout of your spreadsheet so that you can achieve what you want. This will make your work easier and accurate.
  2. Use Fill Function: This function makes your work easier and less time-consuming. For creating a complex report, you can make use of the Excel’s “Fill Across Sheets” tool. Through this you can duplicate one sheet across many others quickly.
  3. Use Named Ranges: You should use named ranges, in this you do not have to put the symbols on anchor refs. You can use names in formulas, or you can select a named range. Through this, you can create a named range on one sheet and you can also use that name on other sheet.
  4. Formatting: When you create your spreadsheet, first you have to enter data or review data. You can select the fonts, sizes and colors, so that your spreadsheet becomes easy to understand. You can use Bold or Italics, for the headers so that there is a difference between the data and the header. Use this formatting till last one.
  5. Protecting Your Work: It is very important to protect your Excel file. You can prevent others for making any changes in your Excel sheet. You can secure formula cells by stop any other changes, and also stop the rows and columns from being resized. It stops the user from making any changes in the structure of the workbook.
  6. Use Keyword Shortcuts: Basically, users use mouse to do action in Excel, but if you use the keyboard it will make your work easy and also speed up your work and saves time.
  7. Converting to PDF: If you really want your client to look at the data of your spreadsheet, then you should convert your spreadsheet to PDF. You do not require any software for converting spreadsheet to PDF.

If you want to know more about MS Excel, then you can visit to the official website of MS Office through www.office.com/setup.  #Office.Com/Myaccount

Excel Filter to Save Time and Money

Microsoft Office is the famous software which is used for homes and businesses. It has amazing applications which make the work of the user easy. You can install this well known software through www.office.com/setup. It provide user friendly interface and it is developed by Microsoft. Its apps are MS Excel, MS Word, MS PowerPoint and MS Outlook etc. It supports many devices like Window OS, Mac, Laptop, Computers and Android Phones. This software helps the user in formatting, editing, creating text document and making presentation etc. In this blog, how you can filter data in Excel.

Easy Method to Filter Data in MS Excel:

  1. Enter In The Search Bar: For this, first you have to add filters to your data. Then, you have to open the filter drop down and just click on the search bar. Now in the search bar, you have to type the name which you want to filter. When you do this, it will filter the entire values where word is presented. At last, you have to click OK button.
  2. Filter by Color: Filter by color is used to filter values. If you highlight some cells in the worksheet with color, it can be easily filtered out. For this, first you have to apply a filter to your data. Then you have to open the filter drop-down. After this, go to Filter by color and then you should choose the color for which you want to filter. When you click on the color, this will filter the whole cells with the red color.
  3. Add a Condition with OR: It works well with more than one situation. For this, first you have to add filters to your data. Then for the column where you want to filter data and after this, open filter drop down. Now you have to select go to and then choose Text Filters and then click on Custom Filters. Here you will see the window appears to select filters options. Now from this window you have to choose “contains” from both the drop downs. After this, in the input bar you have to type “name” and in second input bar enter “other option”. Now from the options button you have to choose “Or”. At the end, click on OK button.
  4. Pre-Defined Date Parameters: Here there are so many options where you can filter date. There are 21 filter options for dates. If you want to filter custom data, then you can use custom filters. Year to Date: This is used if you want to filter the whole data from the year starting to till date. All Dates in a Period: This is used to filter whole dates in a particular month or quarter.
  5. Filter Top 10 Values: First you have to apply filters. Then from the column where you want to filter and then open filter drop down. After this, you have to select Go to and then you have to select Number Filters. After this, click on Top 10. Then the pop-up window will open up. From that window, you have to choose the following things like Top or Bottom Values, Number of Values, and Type of Filter. After this, click on OK button.

Read Also – Problem with Microsoft ATP’s Phishing Detection which Put Users at Risk

These are some of the tips which help to filter data, for more details you can visit to the site of MS Office via office.com/setup.