Change International Numbering Style to Indian Numbering Style in Excel

Our last post was based on sharing some information on adding a Windows Calculator to the MS Excel which was liked by many people. One of our readers then enquired us if there is some way to change the numbering system present in MS Excel by default to Indian style of numbering.

We have received this question from our viewers some time back too, in which they actually wish to use Indian Numbering system on their computers because since Accountants and other finance professionals from India deal with this system in their daily lives, it becomes difficult for them to operate. Continue reading “Change International Numbering Style to Indian Numbering Style in Excel”

Convert or Import Excel sheet to Access Database

One of our readers wanted to know how to convert the excel .xls spreadsheet into the MS Access .accdb file with all the tables remaining as it is in the Access file. If you also work between the two files and wanted to know the same procedure then here is way how it is done.

Steps:

1.    Create a new Access database file on your desktop or into a folder which will serve as the target file for us.

2.    Open this access file, go to the External Data tab and click Continue reading “Convert or Import Excel sheet to Access Database”

Grab all the URL links in a webpage with URLStringGrabber

While working on the internet it may happen that you come across some very important links on a webpage and want to save most of them with you. If this is the case then you don’t need to copy each and every link manually but with the help of a tool developed by Nirsoft called URLStringGrabber, you can do this easily.

URLStringGrabber is a small and free utility developed by Nirsoft which can help you in storing all the URL links present in all the opened windows of IE. The tool scans all opened windows of Internet Explorer and grabs the URLs stored in them, including clickable links, images, script files, CSS files, RSS feeds, and flash (.swf) files. Continue reading “Grab all the URL links in a webpage with URLStringGrabber”

Unlock Password Protected Cells in Excel Sheet

For all those people who work mostly on the Excel sheet, this article will come very useful. We come across sheets having some cells password protected by the admin of the document. Here are some ways to unlock the cells protected with password even if you don’t know the password.

Using Online Utilities

1.    Google Docs

Just upload your spreadsheet to your Google Docs account, open it online and you will be able to use the sheet without any restrictions. However the only thing to consider is that, it may Continue reading “Unlock Password Protected Cells in Excel Sheet”

Convert PDF to Word Doc and Excel Xls file

Editing .pdf file is not easy, right? Keeping this in mind and to be able to let our readers easily convert the pdf file to Word .doc or Excel .xls format, here is a cool solution.

Convert PDF to Doc

If anytime for your work or to edit, you wish to convert PDF file to Doc file then there is a cool site which lets you do the thing easily.

Zamzar is a great online and free site that can convert files of extensions like Continue reading “Convert PDF to Word Doc and Excel Xls file”

Steps to Enable/Disable Macro in Office 2007

I was supposed to work on the Microsoft Excel Document .xls yesterday and was required to enable the macro for that purpose. This is not a big problem as we used to do that by going to the Tools tab (Tools -> Macro) in earlier versions of Office than 2007.

Macros are one of the important features in Office application and especially for those using Excel. Enabling or disabling macros was easy till Excel 2003 but what in Excel 2007 where there is no tools tab?

We can see the Macro Security option in the Continue reading “Steps to Enable/Disable Macro in Office 2007”

The Use of ScrLk Key

Wondering what a key titled ScrLk is doing on our keyboards? Well, it’s a fact that most of us didn’t actually know the function of ScrLk key. I have asked many people but found that this is a key least used by them. Let’s see what this key is doing there:

ScrLk stands for Scroll Lock and is placed between the keys PrtScn and Break. This toggle key is also associated with a light indication, showing whether it’s on or off. The key has got something related to the arrow keys. It was developed to modify the work done by the arrow keys and even its working depends upon the software that is currently in use.

The primary work it used to do was Continue reading “The Use of ScrLk Key”