File Repair tools

MS Excel has huge number of users over the world and these numbers are increasing day by day because every time it comes with new features. People use the excel sheet to maintain the data in a good manner. Have you ever tried to apply the validation on the cell? If your answer is no, then read this blog to know about validation option in MS Excel. Suppose, you want to set the validation (restriction) on a cell that, when someone is trying to enter a data which is more than 15 characters or against the validation then, it will throw an error in the screen to warn the user. Steps to add validation: Step 1: Click on the Data tab. Unser the Data Tools option, Data Validation option is available. Step 2: Now select the cell which you want to validate. Click on the Data Validation option. When you will click on this option then, a window will appear on the screen with the different validation option. This window looks like this: You can see the different validati...

Today, when I was working with MS Excel then I used the AutoSum option many times to make sum of the numbers. I have noticed one thing about this option which was very interesting. This option is available in two places, first in Home tab and second in Formulas tab. Check the images below:       AutoSum in Home Tab                                           AutoSum in Formulas Tab Shortcut for AutoSum: In MS Excel, every formula and function have its own shortcut. You can use ALT+ as the shortcut of AutoSum option. To test this option, write down the numbers in the excel sheet and press ALT+ to make its AutoSum. Now I am describing my experience with this function. First I have created three columns named: Physics, Chemistry and English. Now I entered some numbers along with the columns. Test of AutoSum Option Vertically Up:  Excel u...

A hyperlink is important but in few cases it becomes tedious. Automatic creation of hyperlink is like a speed breaker in the document creation process. It creates with the following prefixes: http://  ftp:// file: www. mailto: news: \\ Suppose, you are working with large the number of excel files and each file consists of thousands of hyperlinks then what will do? I think you will try to remove manually but here, we are talking about thousands of hyperlinks. In this case, try these options: Apostrophe (‘) at the starting of the cell entry: To understand this option. Let’s take an example. Suppose you are trying to write www.google.com in the cell. When you write it then, it becomes hyperlink automatically. In this case, write an apostrophe (‘) at the beginning of the cell entry. ‘www.google.com  It won’t become hyperlink. This is the first way to prevention of automatic hyperlink. The second option is more interesting which is given below: Using autocorrect...

Adobe Photoshop is the perfect tool to create images and it is used by professionals as well as home users. Photoshop files or the layers sometimes for no apparent reason gets corrupted and refuses to open. As a result of the numerous situations like: sudden power failure, interruption while downloading and virus infection etc; can damage or corrupt the Photoshop files. In this blog, we will discuss the header corruption in .PSD file and solution to overcome from this issue. Header of any .PSD file contains all the vital information about PSD file such as size, colors, number of layers and other important details. When the header got corrupted of the Photoshop file then the operating system or other tools cannot access that file. Points to remember:  The header can corrupt by the following reasons – Memory in the bad sectors where the .PSD file is located. This memory works as storage device. system hard drive works as a storage device. Improper termination of the Adobe Ph...

MS Excel 2016 is more enhanced with its feature. For windows and OS X, MS office 2016 will release tomorrow (22-Sept-2015). You can easily download its preview from the official site and they are also providing the product key for office 2016 preview. This preview will be available on your system until you uninstall office 2016 preview or office 2016 is released. So get ready to know about few of them like Power-Query and Business Analytics. Read this post to know about them. Power Query Power query is not a new feature for Excel users but this time it is more integrated and available as an inbuilt feature of MS Excel 2016. This feature is available in Excel 2010 and 2013 as Add-in. In MS Excel 2016, this feature is available in Get & Transform section which provides fast, easy data gathering and shaping capabilities. Image courtesy: Microsoft I will discuss some important feature that you can achieve with power query in ...

Adobe Photoshop does not need an introduction because it is used by millions of people across the globe and available in the 25 different regional languages including English. This great tool is available in the market from last 25 years and growing day by day.You can read more about of this tool on Wikipedia . It has a very big market of the customer from the different fields but, sometimes you can face the corruption problems in your .PSD files. The sad news is, Adobe does not provide any tool to repair corrupt .PSD files but luckily few data recovery companies (like Stellar data recovery ) provide tools to repair these corrupt files. To know about these tools, stay with this blog. PSD recovery tools are very powerful and able to repair the layers of .PSD files. This kind of software can repair the various file formats and it can be found as free and paid. I have tested many tools before writing this article. I found these tools are good and appropriate for .PSD repair. Take a loo...

PowerPoint is a very well know tool that comes as a part of MS Office suite. Often people use it to create presentations for different purposes. Generally, PowerPoint files are larger in size and have a complicated file structure due to which they are prone to corruption. It takes a lot of efforts and hard work to create a PowerPoint presentation in MS PowerPoint, but due to corruption it could be useless. Like every other computer file, PowerPoint presentations can corrupt or also become inaccessible at any time. When a corrupt PPT file starts sending you error messages while opening, it is an indication of corruption, which could be major or minor. Let's check out some common solutions that you can perform on your corrupt PPT files in order to repair them or to retrieve the content. Solution 1 You can simply move the corrupt PowerPoint to a different location. This is a very simple and useful way to troubleshoot your corrupt PPT file and remove its problems. You...