PASSWORD PROTECT YOUR WORD FILES

PASSWORD PROTECT YOUR WORD FILES

We all use Microsoft Word to create documents.
and some times we dont want other people to access our documents
specially when you are on a shared computer in your company and you may have your certain secret data stored in your word document that should not be accessed by your boss or other employee’s.

To deal with such a situation Microsoft word 2007 integrated a security feature in Microsoft word so that you can password protect your files.


just follow these simple steps to make your document protected


Click on the Microsoft Office Button present on the top left corner of the window.
Now Click on the Save As option
Now a new window will pop up.
Click on Tools option at the bottom of the window.
Now you will have two options.
You can select either one or both options
One is Password To Open it will ask for the password every time the document is opened.
So to view the document you have to enter the password first.
Second is Password To Modify it will ask for the password every time somebody tries to modify the document.

Read more »

Microsoft Excel Shortcut Keys

Microsoft Excel Shortcut Keys

The followings are Microsoft Excel shortcuts. Some short-cuts might be version specific.

Use at your own risk.

Mouse shortcuts

Shortcut	Description
Double-click (on a cell)	Edit the cell contents.
Double-click (on a row/column divider)	Adjust height/width to auto-fit
High-light headers of multiple rows/columns then Double-click on a row/column divider	Adjust height/width to auto-fit of all high-lighted rows/columns
Triple-click	Select the entire contents in the cell
Click on row/column divider then drag	Adjust height/width of the row/colunn
High-light headers of multiple rows/columns then Click on row/column divider then drag	Adjust height/width of the rows/colunns
Ctrl + Mouse wheel	Zooms in and out of document.
Hold Shift + Click the cells	Select multiple cells

Keyboard shortcuts

Shortcut	Description
F2	Edit the selected cell.
F5	Goto a specific cell. For example, C6.
F7	Spell check selected text and/or document.
F11	Create chart.
Ctrl + A	Select all.
Ctrl + B	Bold.
Ctrl + C	Copy.
Ctrl + F	Find (same as Shift + F5).
Ctrl + G	Go To.
Ctrl + H	Replace.
Ctrl + I	Italic.
Ctrl + K	Insert link.
Ctrl + N	New Workbook.
Ctrl + O	Open Workbook.
Ctrl + P	Print dialog.
Ctrl + S	Save.
Ctrl + U	Underline.
Ctrl + V	Paste.
Ctrl + Z	Undo.
Ctrl + Y	Redo.
Ctrl + X	Cut.
Ctrl + 5	Strikethrough text.
Ctrl + F3	Define Name.
Ctrl + F4	Exit Excel.
Ctrl + F6	Switch between open workbooks.
Ctrl + F9	Minimize current window.
Ctrl + F10	Maximize current window.
Shift + F1	Activate Help on Item.
Shift + F2	Insert Comments
Shift + F3	Insert Function.
Ctrl + Shift + ;	Enter the current time.
Ctrl + ;	Enter the current date.
Ctrl + Page down	Move to next worksheet.
Ctrl + Page up	Move to previous worksheet.
Ctrl + Shift + #	Number Format: Date
Ctrl + Shift + @	Number Format: Time.
Ctrl + Shift + !	Number Format: Commas.
Ctrl + Shift + $	Number Format: Currency
Ctrl + Shift + %	Number Format: Percentage
Ctrl + Shift + ^	Number Format: Scientific.
Ctrl + Space	Select entire column.
Shift + Space	Select entire row.
Ctrl + (Arrow key)	Move to next section.

Read more »

Microsoft Windows Shortcut Keys

Microsoft Windows Shortcut Keys

This is a listing of some common shortcut keys in different versions Microsoft Windows.

Some shortcut keys below are not supported in all versions of Windows.
The shortcut keys on this page are only applicable for Windows in general, if you are looking for shortcut keys for a specific application (i.e. Excel, Word, etc..) please see the links at the bottom of this page.

Use at your own risk.

Shortcut Key	Supported Window Versions	Short Key Description
Alt + (double-click)	95, 98, ME, NT, 2000, XP, Vista	Open Properties dialog of selected item.
Alt + Enter	95, 98, ME, NT, 2000, XP, Vista	Opens properties window of selected item.
Alt + Esc	95, 98, ME, NT, 2000, XP, Vista	Switch Between open tasks available on the taskbar.
Alt + F4	95, 98, ME, NT, 2000, XP, Vista	Close the top (focused) window.
Alt + Tab	95, 98, ME, NT, 2000, XP, Vista	Switch between open windows.
Alt + Tab + Shift	95, 98, ME, NT, 2000, XP, Vista	Switch between open windows, backward.
Ctrl + Alt + Delete (or Del)	95, 98, ME, NT, 2000, XP, Vista	Bring up the Windows Task Manager, or reboot computer.
Ctrl + Esc	95, 98, ME, NT, 2000, XP, Vista	Bring up the Windows Start menu.
Ctrl + '+' ('+' key on the keypad)	98, ME, NT, 2000, XP, Vista	Autofit the widths of all columns (if available) in current window.
Ctrl + F4	95, 98, ME, NT, 2000, XP, Vista	Close sub window/tab.
Ctrl + Tab	95, 98, ME, NT, 2000, XP, Vista	Switch between existing tabs (within a window).
Ctrl + Tab + Shift	95, 98, ME, NT, 2000, XP, Vista	Switch between existing tabs (within a window), backward
F1	95, 98, ME, NT, 2000, XP, Vista	Open Help for Windows or focused application.
F2	95, 98, ME, NT, 2000, XP, Vista	Rename.
F3	95, 98, ME, NT, 2000, XP, Vista	Find/Search.
F4	95, 98, ME, NT, 2000, XP, Vista	Select drives or display the list of drives
F5	95, 98, ME, NT, 2000, XP, Vista	Refresh.
F6	95, 98, ME, NT, 2000, XP, Vista	Switch focus to the address bar (if exists).
F10	95, 98, ME, NT, 2000, XP, Vista	Switch focus to the top menu bar.
Shift + F10	95, 98, ME, NT, 2000, XP, Vista	Same as mouse right-click on the select item.
Print Screen	95, 98, ME, NT, 2000, XP, Vista	Capture a screenshot of the entire desktop to clipboard.
Print Screen + Alt	95, 98, ME, NT, 2000, XP, Vista	Capture a screenshot of just the top(focused) window to clipboard.
Shift + Delete (or Del)	95, 98, ME, NT, 2000, XP, Vista	Permanently delete selected file(s)/folder(s) (bypass recycle bin)
Shift (hold while inserting an audio CD to drive)	95, 98, ME, NT, 2000, XP, Vista	Prevent autoplay.
* (keypad) on Windows Explorer.	95, 98, ME, NT, 2000, XP, Vista	Expand all sub-directories from the selected item.
+ (keypad) on Windows Explorer.	95, 98, ME, NT, 2000, XP, Vista	Expand only the first level of selected item.
- (keypad) on Windows Explorer.	95, 98, ME, NT, 2000, XP, Vista	Collapse

Most keyboards have a Windows Key (key with a Windows icon). This key provides additional shortcuts for Microsoft Windows. Below is a list of the shortcut keys by combining the Windows key and other keys.

Shortcut Keys	Description
WINDOWS-KEY	Bring up the Windows Start menu.
WINDOWS-KEY + F1	Bring up the Windows Help.
WINDOWS-KEY + e	Open Microsoft Explorer.
WINDOWS-KEY + f	Windows Search.
WINDOWS-KEY + Ctrl + f	Search for computers
WINDOWS-KEY + d	Minimizes all and bring up desktop, or restore all
WINDOWS-KEY + l	Lock the computer (Windows XP & newer).
WINDOWS-KEY + m	Minimizes all windows.
WINDOWS-KEY + Shift + M	Restore all. Opposite with WINDOWS-KEY + M and WINDOWS-KEY + D.
WINDOWS-KEY + r	Open the run window.
WINDOWS-KEY + u	Utility Manager.
WINDOWS-KEY + Tab	Cycle through the programs on task bar.
WINDOWS-KEY + Pause/Break	Open the System Properties window.

Read more »