Deleting file from Excel also from recently created documents.

Microsoft Office software developers have been paying more and more attention to the means of protecting users' information, and Microsoft Excel has not been overlooked. Recent versions of the program provide users with advanced features for protecting Microsoft Excel documents against unauthorized access of the information stored in them. The methods include completely blocking access to a document, forbidding saving changes to it. Besides, some expert team even designed Excel password recovery tool to recover Excel 2007 password for those who have lost Excel password.
Set a password to open or modify Excel 2007 password
Set a password to open Excel 2007

• 1. Click the Microsoft Office Button , point to Prepare, and then click Encrypt Document
• 
  
• 2. In the Password box, type a password, and then click OK.
• You can type up to 255 characters. By default, this feature uses AES 128-bit advanced encryption. Encryption is a standard method used to help make your file more secure.
• 3. In the Reenter password box, type the password again, and then click OK.
• 4. To save the password, save the file.

Set a password to modify a Excel 2007 Spreadsheet

• In addition to setting a password to open an Excel spreadsheet, you can set a password to allow others to modify the spreadsheet.
• 1. Click the Microsoft Office Button , click Save As, and on the bottom of the Save As dialog, click Tools.
• 2. On the Tools menu, click General Options. The General Options dialog opens.
• 3. Under File sharing, in the Password to modify box, type a password.
• 4. In the Confirm Password dialog, re-type the password. Click OK.
• 5. Click Save.

Remove password protection from an Excel spreadsheet

• 1. Use the password to open the spreadsheet. (Note: If you don't know the open password, you have to recover Excel password with the third Excel password recovery tool)
• 2. Click the Microsoft Office Button , point to Prepare, and then click Encrypt Document.
• 
  
• 3. In the Encrypt Document dialog box, in the Password box, delete the encrypted password, and then click OK.
  
• 4. Save the spreadsheet.
  

Recover Excel 2007 password with Excel Password Unlocker Excel Password Unlocker is a popular Excel password recovery tool that can recover Excel password from Excel 97 to Excel 2007

Microsoft Office software developers have been paying more and more attention to the means of protecting users' information, and Microsoft Excel has not been overlooked. Recent versions of the program provide users with advanced features for protecting Microsoft Excel documents against unauthorized access of the information stored in them. The methods include completely blocking access to a document, forbidding saving changes to it. Besides, some expert team even designed Excel password recovery tool to recover Excel 2007 password for those who have lost Excel password.
Set a password to open or modify Excel 2007 password Set a password to open Excel 2007

1. Click the Microsoft Office Button , point to Prepare, and then click Encrypt Document.
2. In the Password box, type a password, and then click OK. You can type up to 255 characters. By default, this feature uses AES 128-bit advanced encryption. Encryption is a standard method used to help make your file more secure.
   
3. In the Reenter password box, type the password again, and then click OK.
4. To save the password, save the file.

Set a password to modify a Excel 2007 Spreadsheet In addition to setting a password to open an Excel spreadsheet, you can set a password to allow others to modify the spreadsheet.

1. Click the Microsoft Office Button , click Save As, and on the bottom of the Save As dialog, click Tools.
2. On the Tools menu, click General Options. The General Options dialog opens.
3. Under File sharing, in the Password to modify box, type a password.
4. In the Confirm Password dialog, re-type the password. Click OK.
5. Click Save.

Remove password protection from an Excel spreadsheet

1. Use the password to open the spreadsheet. (Note: If you don't know the open password, you have to recover Excel password with the third Excel password recovery tool)
2. Click the Microsoft Office Button , point to Prepare, and then click Encrypt Document.
   
   
   
   
3. In the Encrypt Document dialog box, in the Password box, delete the encrypted password, and then click OK.
4. Save the spreadsheet.

Recover Excel 2007 password with Excel Password Unlocker Excel Password Unlocker is a popular Excel password recovery tool that can recover Excel password from Excel 97 to Excel 2007
Related Office 2007 document password tips:
How to set, modify, remove and recover Word 2007 password?
How to set, modify, remove and recover PowerPoint 2007 password?

Auto sum shortcut key
Quickly create a Microsoft Excel formula to get the sum of all cells by highlighting the cells you wish to know the value of and pressing ALT and = .
Create hyper links in Excel
Quickly create hyper links in your Microsoft Word, Excel, or Front Page document by highlighting text and pressing "CTRL + K".
Close all open files at once
Close all open Microsoft Word and/or Excel files by holding down the shift key and clicking "File" and then "Close All".
Quickly open recently opened files
Quickly open the recent files by first pressing "ALT + F" to open the file Menu and press 1, 2, 3, or 4.
Create underlines without any text
This tip works with the majority of Microsoft Office applications. Easily create an underlined space by pressing CTRL + U to start the underline, then press SHIFT + Space for each underlined space you wish to create. An example of how this could be used is for printable forms, for example: Name: .
Print only sections of a document
Save on your printer ink by selectively printing in Windows programs such as Microsoft Word, Internet Explorer, WordPad, Outlook, etc. To do this highlight portions of text you wish to print and click print. In the printer dialog window under Page Range choose the option Selection. It is important to realize that not all programs or printer drivers support this feature.
Repeat recent action
Using the F4 key in Microsoft Office 2000 and above allows the user to repeat the last used action. For example, if you have changed the font of a selected text and wish to change another portion of text to the same font, pressing F4 will do this for you automatically.
Quickly undo
Quickly undo mistakes in the majority of most PC Windows program by pressing CTRL + Z.
Quickly above cell contents
In Microsoft Excel press CTRL + SHIFT + " to copy the above cells contents.
Using the Microsoft Excel Auto filter
Organize cells quickly by using Microsoft Auto filter. Columns that contains long listing of data can be easily sorted by using the Auto filter option, to use this option select the top rows of the columns you want to be used and select Data / Filter and Auto Filter. Once successfully completed you can use drop down arrows to filter the data automatically.