How to set workbook password in excel 2007

Protect your excel sheet with password

Set password for workbook in Excel 2007: Go to File->Prepare->Encrypt Document. Type your password. Retype your password and Press Enter. At times it becomes necessary to set password for microsoft excel sheet or for the workbook. You might not want others to use your excel sheet or access the workbook. To  ..

Shortcut to inser row n column

How to insert Row and Column in MS-Excel

There are different methods to add a row or column in microsoft office excel. For Inserting a row Press Alt+i+r For Inserting a column Press Alt+i+c   ..

How to remove url or hyperlink in excel

Remove hyperlink from columns

How to Remove URL hyperlink from multiple cells or columns in Microsoft Excel? To remove a url or a hyperlink is ver simple. In a blank cell, enter the number 1) Copy that cell. 2) Select the cells with the hyperlinks (click the first cell, shift+down arrow to select multiple  ..

Password protection doc

Protect your docx with password

How to protect a ms-word document with password? It is very safe to have secure document so that there is no need to afraid when others use your computer. If your system is shared in a network where multiple users access your machine, if is good idea to protect your word  ..

Clear pagefile on shutdown

Protect your windows document

Windows uses this file as extra ram. Lets say that you are working on a confidential MS Word doc. When you load this document it is loaded into ram. To save ram windows places certain items in the page file. The page file can then be opened and the document  ..

How to scan a document and edit in word ocr

OCR - Optical Character Recognition program

How to scan and edit a MS office word document - Optical Character Recognition program ( OCR ) Confirm that your computer and your scanner are working properly. The Optical Character Recognition program ( OCR ) which translates images to text. Most computer scanners come with some sort of OCR.  ..

Short cut to fill color excel cells

Execute previous command in worksheet

Short cut to Fill color on MS Excel cells There is no any specific shortcut key to fill color on your excel worksheet. - On the Excel worksheet select the first cell and fill a color. - To fill the same color on different Excel cell - press F4 key which  ..

How to add macro in excel sheet

How to use a Macro in Worksheet

How to Add and use Macro in Microsoft Office Excel or Worksheet One of the most used package in Microsoft office Excel. Macros is an exrodinary feature included in Excel, It will be ver useful when you want yourself to do the same repeated task on different cells or on excel  ..