Sunday, April 24, 2011

Tracing Excel Cell Precedents

When we talk about functions in Excel, sometimes they are quite easy to understand what cells are used in them, but I faced situations where complex functions are too complicated to understand them with a view.

It is the opportunity to use one useful Excel feature which have helped me a lot at work.

Let's consider a function which use cells from another sheet. The first thing is to select the cell to be evaluated, in this case is in the C column. Once you are there, select the tab "Formulas" and inside this click on the "Trace precedents" item.

This will show an arrow indicating that the selected cell requires data from another cell located in another sheet, to go to this cell you just have to double click on the arrow.

With the double click Excel will show a dialog giving you the list of Excel sheets that the cell we are reviewing use for its calculation, select the sheet you want to go to and press "OK".

Then you will be translated to the sheet you selected, once you finish working there, how could you come back to the original cell? Well, what I do is using the "Go To" (accessible through "F5" key) and without doing nothing I just press "OK".

Quickly you will come back to the beginning of this procedure.

To finish this auditing you will erase these arrows by using the "Remove arrows" option.

In this moment, you are going to have your Excel as usual to be used.

Keeping Last Page You Saw in Adobe Reader

When you are with a pdf file, and you star reading it, you can notice that it's sometimes not possible to read all pages, so you decide to stop at certain point and close it to continue another time.

But, at the moment I needed this I realized that Adobe Reader didn't keep the last page I had read, therefore I had to pass through the pages until find the one I had reached before.

To avoid this situation, there's an option in the application that will help you with that.

Once you are in "Preferences" windows, put yourself on "Documents" section and check the "Restore last view settings when reopening documents" square, and press "OK" button.

With this, the next time you open a file you will appear at the last page you have read, able to continue.

How to Use PC Inspector File Recovery

When I have problems with files missed in my PC I always use PC Inspector File Recovery to recover these  files. But, since my point of view, it's not so easy to use, but with the step shown here you will be able to use it with no problems.

When you run the application, the first thing to do is to select the language you are going to use, remember tu execute with administrator credentials.

Close the window showed after selecting the language.

Once you have done that, select the "search" icon located at first place in the left panel.

With this, the application will show a dialog where you have to select the "Physical drive" tab to force the program to find any logical drives. This is because we could find a formatted partition even in the chosen physical drive.

But finding logical drives requires a command indicating what disk physical sector will be scanned, you ca in this moment to choice all disk sectors or limited range of them, after selecting sectors, click on the "check" button.

Now you only have to wait until searching finalize, it could takes many minutes depending on your disk size.

In this point you will have all the logical drives (partitions) found on your disk, to check what missed files could be inside them, you have to select one by selecting it and clicking on the "check" button.

While the application is listing all files found in the logical driver you will see this dialog box.

As you will see, the program will list all files, the missing files will be shown in green, having the possibility to recover them.

If you want to recover one of these recovered files, you have to use the "Save to..." option which is in the right click menu on the file.

Just select the destination folder, and you will have your file recovered.

Remember that not always a file is recovered as it was before deleting process so it's possible to have a non working file.

Saturday, April 23, 2011

Searching Text Inside Files

Many times I have faced a situation where I had to find which Excel files have inside them a specific code, and that meant I had to open all Excel files (more than 30) to look at inside if the code was there.

For these opportunities it's very useful to use a Windows 7 characteristic which allows you to find inside all the Excel files that are within a folder. Honestly, I haven't proved if it works with any kind of files.

As I explained before, the aim of these procedure is to find what Excel files have a code inside, considering that we are just looking for the files contained in a particular folder.

First you have to select the folder you know files inside have the code you are looking for, after that in the text box located at the right corner type the code and press "Enter", you will notice that explorer shows a message pointing that there was not successful results ("No items match your search"), this is because no files have a name like the code you entered.

In this case you have to select the "File Contents" option at the right, which will force Windows to look into all the files contained in the folder.

Once you make this selection you will have to wait until the progress bar finishes the loading, this progress will be visible in the path box in green color.

Finally, the files which contain the code will be listed one by one until all the files got checked, having in this way the results from your search.

It depends on you to select which file you require.

Sunday, April 3, 2011

Installing SQL Server 2008 Without Rebooting

When I realized that I needed it SQL Server Management Studio 2008 to explore my new databases I got the installer and proceed with the installation.

But this installer made some validations before its execution, and the "Restart computer" item was not checked.

Well, all you have to do in this case is reboot your computer, but in my case I was with a lot of documents, applications and rebooting was not an option, therefore I had to simulated this action by modifying the register, the trick here is to change the name of the "PendingFileRenameOperations" key which is located in "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager".

Changing this key to another name will produce SQL Server installer to assume that your computer was rebooted allowing you to continue with the installation, after installing it you have to change back the name of the key.

Saturday, April 2, 2011

Paging in Word

Actually, giving your pages a number in Word is very easy and probably you know how to do it. In this case, I figured out that one of my documents where with a bad structure, just see the image and you will notice that the total of pages is incorrect because the document has more than one page.

To modify this situation it's necessary to edit the field which is responsible of showing the total of pages, you have to situate over the total and use the right click to show the menu, where you'll have to select "Edit Field...".

This option will show a dialog where we are going to reset this counter by using the field "NumPages" and he can set some properties depending on our likes.

And this is how the counter will show the reality of the document.