Run Commands

To Access….	Run Command
Accessibility Controls	access.cpl
Accessibility Wizard	accwiz
Add Hardware Wizard	hdwwiz.cpl
Add/Remove Programs	appwiz.cpl
Administrative Tools	control admintools
Adobe Acrobat (if installed)	acrobat
Adobe Designer (if installed)	acrodist
Adobe Distiller (if installed)	acrodist
Adobe ImageReady (if installed)	imageready
Adobe Photoshop (if installed)	photoshop
Automatic Updates	wuaucpl.cpl
Bluetooth Transfer Wizard	fsquirt
Calculator	calc
Certificate Manager	certmgr.msc
Character Map	charmap
Check Disk Utility	chkdsk
Clipboard Viewer	clipbrd
Command Prompt	cmd
Component Services	dcomcnfg
Computer Management	compmgmt.msc
Control Panel	control
Date and Time Properties	timedate.cpl
DDE Shares	ddeshare
Device Manager	devmgmt.msc
Direct X Control Panel (If Installed)*	directx.cpl
Direct X Troubleshooter	dxdiag
Disk Cleanup Utility	cleanmgr
Disk Defragment	dfrg.msc
Disk Management	diskmgmt.msc
Disk Partition Manager	diskpart
Display Properties	control desktop
Display Properties	desk.cpl
Display Properties (w/Appearance Tab Preselected)	control color
Dr. Watson System Troubleshooting Utility	drwtsn32
Driver Verifier Utility	verifier
Event Viewer	eventvwr.msc
Files and Settings Transfer Tool	migwiz
File Signature Verification Tool	sigverif
Findfast	findfast.cpl
Firefox (if installed)	firefox
Folders Properties	control folders
Fonts	control fonts
Fonts Folder	fonts
Free Cell Card Game	freecell
Game Controllers	joy.cpl
Group Policy Editor (XP Prof)	gpedit.msc
Hearts Card Game	mshearts
Help and Support	helpctr
HyperTerminal	hypertrm
Iexpress Wizard	iexpress
Indexing Service	ciadv.msc
Internet Connection Wizard	icwconn1
Internet Explorer	iexplore
Internet Properties	inetcpl.cpl
Internet Setup Wizard	inetwiz
Java Control Panel (If Installed)	jpicpl32.cpl
Java Control Panel (If Installed)	javaws
Keyboard Properties	control keyboard
Local Security Settings	secpol.msc
Local Users and Groups	lusrmgr.msc
Logs You Out Of Windows	logoff
Malicious Software Removal Tool	mrt
Microsoft Access (if installed)	access.cpl
Microsoft Chat	winchat
Microsoft Excel (if installed)	excel
Microsoft Frontpage (if installed)	frontpg
Microsoft Movie Maker	moviemk
Microsoft Paint	mspaint
Microsoft Powerpoint (if installed)	powerpnt
Microsoft Word (if installed)	winword
Microsoft Syncronization Tool	mobsync
Minesweeper Game	winmine
Mouse Properties	control mouse
Mouse Properties	main.cpl
Nero (if installed)	nero
Netmeeting	conf
Network Connections	control netconnections
Network Connections	ncpa.cpl
Network Setup Wizard	netsetup.cpl
Notepad	notepad
Nview Desktop Manager (If Installed)	nvtuicpl.cpl
Object Packager	packager
ODBC Data Source Administrator	odbccp32.cpl
On Screen Keyboard	osk
Opens AC3 Filter (If Installed)	ac3filter.cpl
Outlook Express	msimn
Paint	pbrush
Password Properties	password.cpl
Performance Monitor	perfmon.msc
Performance Monitor	perfmon
Phone and Modem Options	telephon.cpl
Phone Dialer	dialer
Pinball Game	pinball
Power Configuration	powercfg.cpl
Printers and Faxes	control printers
Printers Folder	printers
Private Character Editor	eudcedit
Quicktime (If Installed)	QuickTime.cpl
Quicktime Player (if installed)	quicktimeplayer
Real Player (if installed)	realplay
Regional Settings	intl.cpl
Registry Editor	regedit
Registry Editor	regedit32
Remote Access Phonebook	rasphone
Removable Storage	ntmsmgr.msc
Removable Storage Operator Requests	ntmsoprq.msc
Resultant Set of Policy (XP Prof)	rsop.msc
Scanners and Cameras	sticpl.cpl
Scheduled Tasks	control schedtasks
Security Center	wscui.cpl
Services	services.msc
Shared Folders	fsmgmt.msc
Shuts Down Windows	shutdown
Sounds and Audio	mmsys.cpl
Spider Solitare Card Game	spider
SQL Client Configuration	cliconfg
System Configuration Editor	sysedit
System Configuration Utility	msconfig
System File Checker Utility (Set Cache Size to size x)	sfc /cachesize=x
System Information	msinfo32
System Properties	sysdm.cpl
Task Manager	taskmgr
TCP Tester	tcptest
Telnet Client	telnet
Tweak UI (if installed)	tweakui
User Account Management	nusrmgr.cpl
Utility Manager	utilman
Windows Address Book	wab
Windows Address Book Import Utility	wabmig
Windows Backup Utility (if installed)	ntbackup
Windows Explorer	explorer
Windows Firewall	firewall.cpl
Windows Magnifier	magnify
Windows Management Infrastructure	wmimgmt.msc
Windows Media Player	wmplayer
Windows Messenger	msmsgs
Windows Picture Import Wizard (need camera connected)	wiaacmgr
Windows System Security Tool	syskey
Windows Update Launches	wupdmgr
Windows Version (to show which version of windows)	winver
Windows XP Tour Wizard	tourstart
Wordpad	write

MS Excel Shortcut Keys

F2	Edit the selected cell.
F5	Go to a specific cell. For example, C6.
F7	Spell check selected text or document.
F11	Create chart.
Ctrl + Shift + ;	Enter the current time.
Ctrl + ;	Enter the current date.
Alt + Shift + F1	Insert New Worksheet.
Shift + F3	Open the Excel formula window.
Shift + F5	Bring up search box.
Ctrl + A	Select all contents of the worksheet.
Ctrl + B	Bold highlighted selection.
Ctrl + I	Italic highlighted selection.
Ctrl + K	Insert link.
Ctrl + U	Underline highlighted selection.
Ctrl + 5	Strikethrough highlighted selection.
Ctrl + P	Bring up the print dialog box to begin printing.
Ctrl + Z	Undo last action.
Ctrl + F9	Minimize current window.
Ctrl + F10	Maximize currently selected window.
Ctrl + F6	Switch between open workbooks / windows.
Ctrl + Page up	Move between Excel work sheets in the same Excel document.
Ctrl + Page down	Move between Excel work sheets in the same Excel document.
Ctrl + Tab	Move between Two or more open Excel files.
Alt + =	Create a formula to sum all of the above cells
Ctrl + '	Insert the value of the above cell into cell currently selected.
Ctrl + Shift + !	Format number in comma format.
Ctrl + Shift + $	Format number in currency format.
Ctrl + Shift + #	Format number in date format.
Ctrl + Shift + %	Format number in percentage format.
Ctrl + Shift + ^	Format number in scientific format.
Ctrl + Shift + @	Format number in time format.
Ctrl + Arrow key	Move to next section of text.
Ctrl + Space	Select entire column.
Shift + Space	Select entire row.

=CELL("filename",A1)
it shows the exact path and file name, sheet name
=MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,FIND("]",CELL("filename",A1))-FIND("[",CELL("filename",A1))-1)
Only file name
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,LEN(CELL("filename",A1))-FIND("]",CELL("filename",A1)))
Only sheet name
=LEFT(CELL("filename",A1),FIND("]",CELL("filename",A1)))
Only the path of that file

MS Word Shortcut Keys

Shortcut Keys	Action in MS Word
CTRL and A	Selects all in the current document.
CTRL and B	Bold text.
CTRL and C	Copies the item or text to the Clipboard and can be pasted using CTRL and V.
CTRL and D	Displays the Font dialogue box.
CTRL and E	Centre Alignment.
CTRL and F	Displays the Find dialog box, to search the current document.
CTRL and G	Displays the Go to dialog box, to go to a specific location in the current document.
CTRL and H	Displays the Replace dialogue box.
CTRL and I	Italic text.
CTRL and J	Full Justification.
CTRL and K	Create Hyperlink
CTRL and L	Left Alignment
CTRL and M	Tab
CTRL and N	Creates a new document.
CTRL and O	Displays the Open File dialogue box.
CTRL and P	Displays the Print dialog box.
CTRL and R	Right Alignment.
CTRL and S	Displays the Save dialog box.
CTRL and U	Underline text
CTRL and V	Pastes the copied item or text from the Clipboard into the current position in the document.
CTRL and X	Cuts the item or text selected to the Clipboard.
CTRL and Y	Redo the last undone action.
CTRL and Z	Undoes the last action.
CTRL and ENTER	Insert Page Break.
CTRL and F2	Show Print preview.
CTRL and F4	Closes the active document window.
CTRL and F6	Opens the next document window.
CTRL and A	Selects all in the current document.
CTRL and B	Bold text.
CTRL and C	Copies the item or text to the Clipboard and can be pasted using CTRL and V.
CTRL and D	Displays the Font dialogue box.
CTRL and E	Centre Alignment.
CTRL and F	Displays the Find dialog box, to search the current document.
CTRL and G	Displays the Go to dialog box, to go to a specific location in the current document.
CTRL and H	Displays the Replace dialogue box.
CTRL and I	Italic text.
CTRL and J	Full Justification.
CTRL and K	Create Hyperlink
CTRL and L	Left Alignment
CTRL and M	Tab
CTRL and N	Creates a new document.
CTRL and O	Displays the Open File dialogue box.
CTRL and P	Displays the Print dialog box.
CTRL and R	Right Alignment.
CTRL and S	Displays the Save dialog box.
CTRL and U	Underline text
CTRL and V	Pastes the copied item or text from the Clipboard into the current position in the document.
CTRL and X	Cuts the item or text selected to the Clipboard.
CTRL and Y	Redo the last undone action.
CTRL and Z	Undoes the last action.
CTRL and ENTER	Insert Page Break.
CTRL and F2	Show Print preview.
CTRL and F4	Closes the active document window.
CTRL and F6	Opens the next document window.

Shortcut Keys	Action in MS Word
F1 key	Get help or use the Office assistant.
SHIFT and F1 Key	Context sensitive help.
F2 Key	Move text or image.
SHIFT and F2 Key	Copy Text.
F3 Key	Insert an autotext entry.
SHIFT and F3 Key	Change the case of the selected text.
F4 Key	Perform last action again.
SHIFT and F4 Key	Perform a Find or Go to action again.
F5 Key	Displays the Go to dialogue box, from here you can also Find and Replace.
SHIFT and F5 Key	Move to a previous revision.
F6 Key	Go to the next frame or pane.
SHIFT and F6 Key	Go to the previous frame or pane.
F7 Key	Launch the Spell checker.
SHIFT and F7 Key	Launch the Thesaurus.
F8 Key	Extend the current selection.
SHIFT and F8 Key	Shrink the current selection.
F9 Key	Update the selected fields.
SHIFT and F9 Key	Switch between a field code and its result.
F10 Key	Activate the menu bar.
SHIFT and F10 Key	Display a Shortcut Menu. Same as right clicking.
F11 Key	Go to the next field.
SHIFT and F11 Key	Go to the previous field.
F12 Key	Save file As, equivalent to tools menu.
SHIFT and F12 Key	Save document, equivalent to tools menu

Shortcut Keys	Action in MS Word
CTRL and A	Selects all in the current document.
CTRL and B	Bold text.
CTRL and C	Copies the item or text to the Clipboard and can be pasted using CTRL and V.
CTRL and D	Displays the Font dialogue box.
CTRL and E	Centre Alignment.
CTRL and F	Displays the Find dialog box, to search the current document.
CTRL and G	Displays the Go to dialog box, to go to a specific location in the current document.
CTRL and H	Displays the Replace dialogue box.
CTRL and I	Italic text.
CTRL and J	Full Justification.
CTRL and K	Create Hyperlink
CTRL and L	Left Alignment
CTRL and M	Tab
CTRL and N	Creates a new document.
CTRL and O	Displays the Open File dialogue box.
CTRL and P	Displays the Print dialog box.
CTRL and R	Right Alignment.
CTRL and S	Displays the Save dialog box.
CTRL and U	Underline text
CTRL and V	Pastes the copied item or text from the Clipboard into the current position in the document.
CTRL and X	Cuts the item or text selected to the Clipboard.
CTRL and Y	Redo the last undone action.
CTRL and Z	Undoes the last action.
CTRL and ENTER	Insert Page Break.
CTRL and F2	Show Print preview.
CTRL and F4	Closes the active document window.
CTRL and F6	Opens the next document window.
F1 key	Get help or use the Office assistant.
SHIFT and F1 Key	Context sensitive help.
F2 Key	Move text or image.
SHIFT and F2 Key	Copy Text.
F3 Key	Insert an autotext entry.
SHIFT and F3 Key	Change the case of the selected text.
F4 Key	Perform last action again.
SHIFT and F4 Key	Perform a Find or Go to action again.
F5 Key	Displays the Go to dialogue box, from here you can also Find and Replace.
SHIFT and F5 Key	Move to a previous revision.
F6 Key	Go to the next frame or pane.
SHIFT and F6 Key	Go to the previous frame or pane.
F7 Key	Launch the Spell checker.
SHIFT and F7 Key	Launch the Thesaurus.
F8 Key	Extend the current selection.
SHIFT and F8 Key	Shrink the current selection.
F9 Key	Update the selected fields.
SHIFT and F9 Key	Switch between a field code and its result.
F10 Key	Activate the menu bar.
SHIFT and F10 Key	Display a Shortcut Menu. Same as right clicking.
F11 Key	Go to the next field.
SHIFT and F11 Key	Go to the previous field.
F12 Key	Save file As, equivalent to tools menu.
SHIFT and F12 Key	Save document, equivalent to tools menu

Eclipse Shortcut Keys

Shortcut Keys	Action in Eclipse
FILE
CTRL + S	Save
CTRL + SHIFT + S	Save All
CTRL + P	Print
F2	Rename
ALT + ENTER	Properties
F5	Refresh
CTRL + N	New Wizard
EDIT
CTRL + C	Copy
CTRL + X	Cut
CTRL + V	Paste
CTRL + Z	Undo
CTRL + Y	Redo
CTRL + A	Select All
SHIFT + END	Select to End of Line
SHIFT + HOME	Select to Beginning of Line
ALT + SHIFT + UP	Select Enclosing Element
ALT + SHIFT + DOWN	Restore Last Selection
ALT + SHIFT + RIGHT	Select Next Element
ALT + SHIFT + LEFT	Select Previous Element
CTRL + SHIFT + RIGHT	Select Next Word
CTRL + SHIFT + LEFT	Select Previous Word
ALT + SHIFT + INSERT	Toggle Column Mode
CTRL + SHIFT + INSERT	Toggle Insert Mode
SHIFT + ENTER	Insert Line below Current Line
CTRL + SHIFT + ENTER	Insert line above Current Line
CTRL + SHIFT + Y	To Lower Case
CTRL + SHIFT + X	To Upper Case
CTRL + ALT + DOWN	Copy Lines
CTRL + ALT + UP	Duplicate lines
CTRL + D	Delete line
CTRL + DELETE	Delete Next word
CTRL + BACKSPACE	Delete Previous word
CTRL + SHIFT +F	Format
CTRL + I /td>	Indent line
CTRL + ALT + J	Join Lines
Window
CTRL + PAGEUP	Next Editor
CTRL + PAGEDOWN	Previous Editor
CTRL + F6	Next Editor
CTRL + SHIFT + F6	Previous Editor
CTRL + F7	Next View
CTRL + SHIFT + F7	Previous View
CTRL + F8	Next Perspective
CTRL + SHIFT + F8	Previous Perspective
F12	Activate Editor
CTRL + E	Open Editor Drop Down
CTRL + SHIFT + E	Switch to Editor
ALT + -	Show System Menu
SHIFT + F10	Show Context Menu
CTRL + F10	Show Ruler Context Menu
CTRL + F10	Show View Menu
CTRL + M	Maximize Active View
CTRL + F4 (OR) CTRL + W	Close
CTRL + SHIFT + F4	Close All
CTRL + SHIFT + W	Close All
Refactoring
ALT + SHIFT + R	Rename – Refactoring
CTRL + 2, R	Rename in file
ALT + SHIFT + L	Extract local variable
CTRL + 2, L	Assign to local variable
ALT + SHIFT + F	Convert local variable to field
ALT + SHIFT + I	Inline
ALT + SHIFT + M	Extract method
ALT + SHIFT + V	Move
CTRL + 2, F	Assign to Var
ALT + SHIFT + C	Change Method Signature
ALT + SHIFT + T	Refactor Quick Menu
ALT + SHIFT + Z	Undo Refactoring
ALT + SHIFT + Y	Redo Refactoring
Search
CTRL + F	Find and Replace
CTRL + K	Find Next
CTRL + SHIFT + K	Find Previous
CTRL + J	Incremental Find
CTRL + SHIFT + J	Incremental Find Reverse
CTRL + G	Declaration in Workspace
CTRL + SHIFT + U	Occurrences in files
CTRL + SHIFT + G	Find References in Workspace
CTRL + ALT + G	Find Text in WorkSpace
ALT + SHIFT + O	Mark Occurrences
ALT + SHIFT + U	Remove Occurrence Annotation
CTRL + H	Open Search Window
CTRL + SHIFT + N	All Instances
CTRL + .	Next
CTRL + ,	Previous
Database Tools
CTRL + ALT + R	Run
CTRL + ALT + D	Debug
CTRL + ALT + X	Execute All
ALT + S	Execute Current Text
ALT + X	Execute Selected Text
ALT + C	Execute Selected text as one statement
ALT + Q	Edit in SQL Query Builder
CTRL + SHIFT + P	Goto Matching Token
Run / Debug
CTRL + B	Build All
CTRL + F11	Run Last Launched
F11	Debug Last launched
CTRL + R	Run to Line
CTRL + U	Run Snippet
ALT + SHIFT + X	Runs as Menu
ALT + SHIFT + D	Debug as Menu
F5	Step into
CTRL + F5	Step into Selection
F6	Step over
F7	Step Return
CTRL + SHIFT + B	Toggle Line BreakPoint
SHIFT + F5	Toggle Step Filters
F8	Resume
CTRL + SHIFT + I	Inspect
CTRL + F2	Terminate
Navigation
CTRL + RIGHT	Next Word
CTRL + LEFT	Previous Word
CTRL + DOWN	Scroll Line Down
CTRL + UP	Scroll Line Up
ALT + DOWN	Move Lines Down
ALT + UP	Move Lines Up
ALT + RIGHT	Forward History
ALT + LEFT	Backward History
CTRL + Q	Last Edit Location
CTRL + L	Go to Line
CTRL + SHIFT + P	Go To Matching Bracket
CTRL + SHIFT + DOWN	Go to Next Member
CTRL + SHIFT + >	Go to Matching Tag
CTRL + SHIFT + UP	Go to Previous Member
CTRL + ALT + H	Open Call Hierarchy
F3	Open Declaration
SHIFT + F2	Open External Javadoc
CTRL + SHIFT + R	Open Resource
CTRL + SHIFT + T	Open Type
F4	Open Type Hierarchy
CTRL + SHIFT + H	Open Type in Hierarchy
CTRL + T	Quick Hierarchy
CTRL + O	Quick Outline
CTRL + F3	Open Structure
ALT + SHIFT + B	Show in Breadcrumb
Views
ALT + SHIFT + W	Switch View Menu
ALT + SHIFT + Q	Switch View Popup
ALT + SHIFT + Q, P	Java Package Explorer
ALT + SHIFT + Q, O	Outline
ALT + SHIFT + Q, X	Problems
ALT + SHIFT + Q, S	Search
ALT + SHIFT + Q, Y	Synchronize
ALT + SHIFT + Q, T	Java Type Hierarchy
Source Code
CTRL + SPACE	Content Assist
CTRL + SHIFT + SPACE	Context Information
CTRL + 1	Quick Fix
ALT + SHIFT + Z	Surround with..
CTRL + SHIFT + /	Add Block Comment
CTRL + SHIFT + \	Remove Block Comment
CTRL + /	Add Comment
CTRL + \	Remove Comment
CTRL + / OR CTRL + 7	Toggle Comment
CTRL + SHIFT + M	Add Import
CTRL + SHIFT + O	Organize Imports
ALT + SHIFT + J	Add Javadoc Comment
CTRL + NUMPAD_SUBTRACT(-)	Collapse Fold
CTRL + NUMPAD_ADD(+)	Expand Fold
CTRL + NUMPAD_MULTIPLY(*)	Expand All Folds
CTRL + NUMPAD_DIVIDE(/)	Toggle Folding
F2	Show Tooltip Description
ALT + SHIFT + S	Source Quick Menu

Windows Shortcut Keys

Shortcut Keys	Action in Windows XP
CTRL + A	Select all the items in the active window.
CTRL + C	Copy the selected item.
CTRL + F	Displays the find all dialog box.
CTRL + G	Displays the Go to folder dialog box.
CTRL + N	Displays the New dialog box.
CTRL + O	Displays the Open dialog box
CTRL + P	Displays the Prints dialog box.
CTRL + S	Displays the Save dialog box.
CTRL + V	Paste the copied item.
CTRL + X	Cuts the selected item.
CTRL + Z	Undo the last action done.
CTRL + F4	Closes the active document window.
CTRL while dragging an item	Copy the selected item.
CTRL + SHIFT with arrow keys	Highlight a block of text
CTRL + ESC	Display the start menu.
CTTRL + F6	Opens the next document window in the active application.
ALT + F4	Close the active item or window.
ALT + SPACE BAR	Opens the shortcut menu for the active window.
ALT + TAB	Switch between the open items.
ALT + ESC	Cycle through items in the order that they had opened.
F1 Key	Gives help on the active window or selected item.
F2 Key	Rename the selected item.
F3 Key	Search for a file or a folder.
F4 Key	Display the address bar list in My Computer or Windows Explorer
F5 Key	Update the active window.
F6 Key	Cycle through the screen elements in the window or on the desktop
F10 Key	Activate the menu bar in the active program.
Windows Logo	Display or hide the start menu.
Shift + F10	Right click
Ctrl + Shift + Esc	Task Manager
Alt + Enter	View Properties for selected item
Windows Logo + B	Move focus to system tray icons
Windows Logo + Break/ Pause	Display the system properties dialog box.
Windows Logo + D	Display the desktop.
Windows Logo + M	Minimize all of the windows.
Windows Logo + SHIFT + M	Restore the minimized windows.
Windows Logo + E	Open My Computer.
Windows Logo + F	Search for a file or folder.
CTRL + Windows Logo + F	Search for computers.
Windows Logo + F1	Display windows Help.
Windows Logo + L	Lock the Keyboard.
Windows Logo + R	Open the RUN Dialog box.
Windows Logo + U	Open Utility Manager.
TAB	Move forward through the options
SHIFT + TAB	Move backward through the options
CTRL + TAB	Move forward through the tabs
CTRL + SHIFT + TAB	Move backward through the tabs
ALT + Underlined Letter	Perform the corresponding commands or select the corresponding option.
ENTER	Perform the command for the active option or button.
SPACEBAR	Select or clear the checkbox if the active option is the check box.
F1 Key	Display Help.
F4 Key	Display the items in the active list.
Arrow Key	Select a button if the active option is a group of option buttons.
BACKSPACE	Opens a folder one level up if a folder is selected in the SAVE AS or OPEN dialog box.
END	Display the bottom of the active window.
HOME	Display the top of the active window.
NUM LOCK + ASTERISK SIGN(*)	Display all of the sub folders that are under the selected folder.
NUM LOCK + PLUS SIGN(+)	Display the contents of the selected folder.
NUM LOCK + MINUS SIGN(-)	Collapse the selected folder.
LEFT ARROW	Collapse the current selection if it is expanded, or select the parent folder.
RIGHT ARROW	Display the current selection if it is collapsed, or select the first sub folder.