Open Spotlight search item in Finder

I use spotlight extensively. Use of CMD + Space is very convenient. I type the search word. It shows me a list of files. I select the item and hit enter. It opens the file. If it is a power point presentation then it opens powerpoint with the selected file. 

Now comes the tricky part. How can i see that file's path ? or Open the file's folder in a Finder window?

Here is the solution. 

With the item selected (highlighted in blue) press and hold Cmd button. It will show you the file's path. 

Similarly , With the item selected , just press Cmd + Enter. It will open the file's folder in a new Finder tab.

Worlds Toughest Job - Awesome Video

Windows 8.1 on Virtualbox does not show shared folders after upgrade - Solution

Hey Guys, Its been a long time i wrote in my blog. I thought this one needs a post so that some one like me struggling can solve this issue.

Here is my scenario. I had a Windows 8 virtual machine (Virtualbox) as a guest OS on my Windows 7 machine. Yesterday , i upgraded this to Windows 8.1. After restart, i could not see any of my shared folders from my windows 7 machine on Windows 8.1.

Solution: 

The quick solution was to rerun the Virtualbox guest additions. 

Moral , After the upgrades it is better to rerun the guest additions. I used to do it on my linux VMs.Normally, i see the screen size issue after the upgrade.I would then know i have to rerun the guest additions but on Windows i did not see the screen issue. So, it did not strike me till i hit the problem of not finding the shared folder.

Compare quickly between two excel sheets in the same workbook

Most of the time i have to compare the data between two sheets in the same Excel workbook. If it was in a different file, it would have been easier to do a Alt+Tab or Tile windows to check out the contents.Initially, i copied the content to the same sheet for easier reference or copied to a new workbook or used the keyboard shortcut to move between the sheets. But recently i found that Excel has this feature inbuilt. You can get second view of the same excel workbook. You can tile horizontally or vertically just like any other window. On top of it , it can also do a synchronized scrolling i.e if you move one record on the first view it moves one record on the second view. This helps a lot while comparing the data.

To do this. Go to View tab and click on new window. It would create another view of the same excel sheet.The first one would have <FileName>:1 as title and second with <FileName>:2. Now click on "view side by side" and "Synchronized scrolling" if required. If you don't like the view you can tile it differently by clicking on the "Arrange All " and select the view. You might have to select the "Windows of active workbook". 

Side by Side view of  same excel sheet

You can save the workspace so that you get the same view when you open the same file again. This helps if you work on the same excel sheet often.

There are so many features like this in excel which most of us don't use it a lot.

Keyboard shortcut to copy/paste formatting (Format Painter) Excel Mac

Am a lover of keyboard shortcuts. I want everything i do in keyboard shortcuts so that i don't take my hands off the keyboard. This week , i was trying to set a keyboard shortcut to just copy / paste the formatting (format painter) in Excel 2011 on my Mac. And my journey began there..

It is easy in Word 2011. The customized keyboard shortcut provides the commands copyFormat/pasteFormat to assign a shortcut. If you are not familiar , you can assign shortcuts to most of the commands you use in Word/Excel through the Tools->Customize Keyboard.  I tried to search the same copyFormat/pasteFormat commands in Excel but could not find it.  But digging a little further showed that this command is there in Excel 2011 Mac in a different name "Formatting". So , here is what i did to set the shortcut.

Go to Tools-> Customize Keyboard. Select  "Edit" from categories. On the right hand side select "Formatting". Go to "Press new shortcut key" and type in a new shortcut. I used Command + Shift + v. And , click on "Add" . Close the window. All set. Now i can just use the normal copy ( Command + c)  the cells from which i want to copy the formatting. Then go the cell where i want to paste the format and hit the keyboard shortcut (Command + Shift + v). BAM ! the format is copied.

End of Solution !

You can also add this command in your toolbar/menu. Just right click on the free space in worksheet toolbar ( space beside the Help ? symbol on top of any workbook or space before the quick search).  select the "Customize toolbars and menus". Go to "Commands" tab and select the formatting from "Edit" category. Click and drag the "Formatting" to the Worksheet toolbar or the Standard toolbar i.e your menu .

In between , i also tried some other alternatives from this post. It provided a simple Macro script to paste only the format. It was simple and did the job. 

ok, now i have to get this macro for all my excel sheets. So , i added this macro in an new excel workbook and saved it as Excel Add-in (.xlam). Close the workbook and open a new one. Then go to Tools -> Add-ins and use select to find the .xlam file you stored the macro. Check it and close it. Thats it. The macro is available all across the excel sheets. 

It is a good learning.

Any security is as strong as its weakest point !

I was discussing with some of my friends today on cloud security. The friend who initiated the topic, discussed about Dropbox security how the unencrypted files might be vulnerable for unauthorized access by drop box employees etc., There were discussions about  encryption tools like boxcryptor , datalocker, axcrypt  and other secure cloud providers like spideroak etc., His concern was not to trust these cloud providers. My friend was really paranoid with all these security issues. He said he makes sure everything is secured and encrypted etc., So, i asked him is he sure about it. He said yes. I asked him few questions. 

1. Do you transfer documents as attachments on gmail ? 
Answer : Yes

2. Do you encrypt them ?
Answer : No

3. Do you use flickr, picassa and other photo sharing tools ?
Answer: Yes


4. Do you use social networking sites like facebook, google+ , twitter etc.,?
Answer: Yes

So, i asked him how he is sure that all his data is safe when the data in any of the services mentioned above can be accessed by the employees of that respective company ? Am not saying employees of these firm would check these files. When talking about security , you have to consider all the possible aspects. After all "Any Security  is as strong as its weakest point".

Ok, Don't get me wrong. Am not trying to offend my friend here or trying to make him more paranoid or trying to say that the data in gmail , flickr would be seen by its employees. Even though theoretically its possible , they have standard security process to follow. My only point is , when we go online we have our data out in the cloud. It is not just about the Dropbox, skydrive, box, icloud . Even before these things existed , we started to put our data in the cloud. 

So, whats the point ?

Ok, let me get to it. Just BoxCryptor, truecrypt or any encryption tool might not help or in the same sense only your anti virus/ anti spyware can not alone protect you. 

Cloud is inevitable in this generation. So , when thinking of security , it is all common sense and that should be applied in everything. Eg., You keep all the files secured and send a mail to yourself the password so that you don't forget it. This is a real life example and i have seen people doing it.  or people would use all the good encryption tool but keep the password as "test123" or "password" or their name. Hope you are getting the point.

 Any Security is as strong as its Weakest point.  It is not only for cloud storage. 

Have you checked the document properties of your CV/Resume ?

I have to deal with lot of word documents , presentations , excels in my Professional life. I get to see a common mistake done by most of us even by professionals . They over look the document properties ( Ok, i do not know how many of you ever seen that window/detail). We all copy from different articles, documents from all over. We do not start anything from scratch. We just start from what is currently available  or what we get from other resources . We change the contents according to our requirement. While doing such changes , the one thing which we overlook is the document properties. The Document properties has some basic info about the details such as the Author, Title of the document , tags, Company details etc., For those who does not know where to check this "File -> Properties" on Microsoft office for Mac and Office Button on top left corner -> Prepare -> Properties on Microsoft Office for Windows. You can select Advance properties from the drop down from the document properties appearing on the top.

Document Properties Menu - Windows

Sample Document Properties - Windows

Sample Document Properties - Mac

Ok, what is so fuzzy about it ?  

When we copy a document it retains the old properties. We change the content of the document but forget to change the properties of the document. This would create very embarrassing situations sometimes. I had a colleague who had created a document to be sent to the client. When it came for an internal review , i found he had forgotten to change the document properties and it had our competitor company name in the Author/Company field. My friend had copied some materials from his earlier life when he was working with our competitor. Think of what would have happened if our client would have seen this. This is just an example. I have seen many such mistakes. 

 This is a very common mistake everybody had done or still doing (including myself). For Eg., i hope everybody would have their CV/Resume on a word document. Am sure this would have been prepared by taking some samples from internet or copied from a friend/colleague. How many of you checked the document properties before using it ? If you haven't done yet. I would strongly advise you to check and correct it if required. 


Have a nice day !