Bacn is an email that you receive that doesn;t qualify as spam. It is in your inbox because you signed up for it and could include newsletters, updates, bank statements etc. It is the email that you hope to receive but don't find time to read it.
Saturday, June 25, 2011
Monday, July 19, 2010
Some Technical Full Forms.
VS:-Visual Studio.
HP:-Hewlett Packcard.
XP:-Extrme Programing.
CE:-Civil Engineering.
CTB:-Computer Based Traning
CLR:-Common Language Runtime.
ADO:-Active Data Object.
VCF:-Visual C# Express.
CFM:-Common Fusion Foundation
ASP:-Active Server Pages.
SQL:-Structured Query Language.
XML:-Extensibal Markup Language.
SCM:- Software Configration Management.
VSS:- Visual Source Safe.
TFS:- TEAM Foundation Server.
SVN:- Subversion.
CVS:-Concurrent Version System.
CTS:-Common Type System.
RCS:-Revision Control System.
TFC:-Team Foundation Client.
SSL:-Source Socket Layer.
ISP:-Internet Server Providers.
AMD:-Advanced Micro-Device.
WAP:-Wireless Application Protocol.
SAP:-System Analysis And Programe Develoment.
PDA:-Personal Digital Assistent.
DNS:-Domain Name Server.
PPP:-Point-To-Point Protocol.
SDK:-Software Development Kit.
SAD:-System Analysis & Design.
FAT32:-File Allocation Table.
NTFS:-New Technology File System.
MMS:-Multimedia Masseging Service.
HCL:-Hindustan Computer Limited
WSDL:-Web Service description Language.
MISL:-Microsoft Intermediate Language.
HTTP:-Hyper Text Transfer Protocol.
HTML:-Hyper Text Markup Language..
HTTPs:-Hyper Text Transfer Protocol. Over SSL.
YAHOO:-Yet another Hierarchical Officious Oracle.
VIRUS:- Vital Information Resource.
INTEL:-Integrated Electronic Chip.
INSAT – Indian National Satellite.
JSP – Java Server Pages.
JPEG – Joint Photographic Expert Group.
LAN – Local Area Network.
LCD – Liquid Crystal Display.
LED – Light Emitting Diode.
MAN – Metropolitan Area Network.
SAN – Social Area Network.
MAR – Memory Address Register.
MBR – Memory Buffer Register.
MFT – Multiprogramming with Fixed Tasks.
MIDI – Musical Instrument Digital Interface.
MSDOS – MicroSoft Disk Operating System.
MSI – Medium Scale Integration.
MVT – Multiprogramming with Variable Tasks.
NIC – Network Interface Card.
JSP – Java Server Pages.
JPEG – Joint Photographic Expert Group.
LAN – Local Area Network.
LCD – Liquid Crystal Display.
LED – Light Emitting Diode.
MAN – Metropolitan Area Network.
SAN – Social Area Network.
MAR – Memory Address Register.
MBR – Memory Buffer Register.
MFT – Multiprogramming with Fixed Tasks.
MIDI – Musical Instrument Digital Interface.
MSDOS – MicroSoft Disk Operating System.
MSI – Medium Scale Integration.
MVT – Multiprogramming with Variable Tasks.
NIC – Network Interface Card.
NICNET – National Informatics Centre NETwork.
NOS – Network Operating System.
NTSC – National Television Standards Committee.
GPL – Graphical Public Licence.
GUI – Graphical User Interface.
HTTP – Hyper Text Transfer Protocol.
HTML – Hyper Text Mark up Language.
IBM – International Business Machine.
IDN – Integrated Digital Networks.
IEEE – Institute of Electrical and Electronics Engineers.
ISDN – Integrated Services Digital Network.
ISO – International Standard Organization.
OSI – Open System Interface.
ISP – Internet Service Provider.
AMD – Advanced Micro Device.
ARPANET – Advanced Research Project Agency NETwork.
ATM – Automatic Teller Machine.
CAD – Computer Aided Designer.
CRT – Cathode Ray Tube.
CU – Control Unit.
DAT – Digital Audio Tape.
DBMS – DataBase Management Systm.
FAT – File Allocation System.
FM – Frequency Modulation.
PAL - Phase Alternation line.
PCB - Process Control Block.
PDA - Personal Digital Assistant.
PDF - Portable Document Format.
POS - Point Of Scale.
PPM - Pages Per Minute, Parts Per Million.
PVC - Poly Vinyl Chloride.
SD - Secure Digital.
UDP - User Datagram Protocol.
UDT - User Data Type.
UPC - Universal Product Code.
CMOS - Complementary Metal Oxide Semiconductor.
UPS - Uninterrupted Power Supply.
URL - Uniform Resource Locator.
UTP - Unshielded Twisted Pair.
VAN - Value Added Network.
VCR - Video Cassette Recorder.
VOIP - Voice Over Internet Protocol.
WAP - Wireless Application Protocol.
GPL – Graphical Public Licence.
GUI – Graphical User Interface.
HTTP – Hyper Text Transfer Protocol.
HTML – Hyper Text Mark up Language.
IBM – International Business Machine.
IDN – Integrated Digital Networks.
IEEE – Institute of Electrical and Electronics Engineers.
ISDN – Integrated Services Digital Network.
ISO – International Standard Organization.
OSI – Open System Interface.
ISP – Internet Service Provider.
AMD – Advanced Micro Device.
ARPANET – Advanced Research Project Agency NETwork.
ATM – Automatic Teller Machine.
CAD – Computer Aided Designer.
CRT – Cathode Ray Tube.
CU – Control Unit.
DAT – Digital Audio Tape.
DBMS – DataBase Management Systm.
FAT – File Allocation System.
FM – Frequency Modulation.
PAL - Phase Alternation line.
PCB - Process Control Block.
PDA - Personal Digital Assistant.
PDF - Portable Document Format.
POS - Point Of Scale.
PPM - Pages Per Minute, Parts Per Million.
PVC - Poly Vinyl Chloride.
SD - Secure Digital.
UDP - User Datagram Protocol.
UDT - User Data Type.
UPC - Universal Product Code.
CMOS - Complementary Metal Oxide Semiconductor.
UPS - Uninterrupted Power Supply.
URL - Uniform Resource Locator.
UTP - Unshielded Twisted Pair.
VAN - Value Added Network.
VCR - Video Cassette Recorder.
VOIP - Voice Over Internet Protocol.
WAP - Wireless Application Protocol.
Thursday, July 8, 2010
Full Forms of Banks
IDBI - Industrial Developement Bank of India.
PNB - Punjab National Bank.
SBI - State Bank of India, State Bank of Indore.
HDFC - Housing Developmenmt Finance Corporation Limited.
UCO - United COmmercial Bank.
ICICI - Industrial Credit and Investment Corporation of India.
HSBC - Hongkong and Shangai Banking Corporation.
IOB - Indian Overseas Bank.
SCB - Standard Chartered Bank.
SBM - State Bank of Mauritius.
OIB - Oman International Bank.
MCB - Mizuho Corporate Bank.
IOIB - Indian Ocean International Bank.
BoB - Bank Of Baroda.
OBC - Oriental Bank of Commerce.
UBI - United Bank of America.
SBBJ - State Bank Of Bikaner and Jaipur.
SBT - State Bank Of Travancore.
SBP - State Bank of Patiala.
SBH - State Bank of Hyderabad.
SBM - State Bank of Mysore.
PNB - Punjab National Bank.
SBI - State Bank of India, State Bank of Indore.
HDFC - Housing Developmenmt Finance Corporation Limited.
UCO - United COmmercial Bank.
ICICI - Industrial Credit and Investment Corporation of India.
HSBC - Hongkong and Shangai Banking Corporation.
IOB - Indian Overseas Bank.
SCB - Standard Chartered Bank.
SBM - State Bank of Mauritius.
OIB - Oman International Bank.
MCB - Mizuho Corporate Bank.
IOIB - Indian Ocean International Bank.
BoB - Bank Of Baroda.
OBC - Oriental Bank of Commerce.
UBI - United Bank of America.
SBBJ - State Bank Of Bikaner and Jaipur.
SBT - State Bank Of Travancore.
SBP - State Bank of Patiala.
SBH - State Bank of Hyderabad.
SBM - State Bank of Mysore.
Wednesday, June 17, 2009
A Leader should know how to manage failure
(Former President of India APJ Abdul Kalam at Wharton India Economic forum , Philadelphia , March 22,2008 )Question: Could you give an example, from your own experience, of how leaders should manage failure?Kalam: Let me tell you about my experience. In 1973 I became the project director of India 's satellite launch vehicle program, commonly called the SLV-3. Our goal was to put India 's 'Rohini' satellite into orbit by 1980. I was given funds and human resources -- but was told clearly that by 1980 we had to launch the satellite into space. Thousands of people worked together in scientific and technical teams towards that goal. By 1979 -- I think the month was August -- we thought we were ready. As the project director, I went to the control center for the launch. At four minutes before the satellite launch, the computer began to go through the checklist of items that needed to be checked. One minute later, the computer program put the launch on hold; the display showed that some control components were not in order. My experts -- I had four or five of them with me -- told me not to worry; they had done their calculations and there was enough reserve fuel. So I bypassed the computer, switched to manual mode, and launched the rocket. In the first stage, everything worked fine. In the second stage, a problem developed. Instead of the satellite going into orbit, the whole rocket system plunged into the Bay of Bengal . It was a big failure.That day, the chairman of the Indian Space Research Organization, Prof. Satish D hawan, had called a press conference. The launch was at 7:00 am , and the press conference -- where journalists from around the world were present -- was at 7:45 am at ISRO's satellite launch range in Sriharikota [in Andhra Pradesh in southern India ]. Prof. Dhawan, the leader of the organization, conducted the press conference himself. He took responsibility for the failure -- he said that the team had worked very hard, but that it needed more technological support. He assured the media that in another year, the team would definitely succeed.. Now, I was the project director, and it was my failure, but instead, he took responsibility for the failure as chairman of the organization.The next year, in July 1980, we tried again to launch the satellite -- and this time we succeeded. The whole nation was jubilant. Again, there was a press conference. Prof. Dhawan called me aside and told me, 'You conduct the press conference today.'
I learned a very important lesson that day. When failure occurred, the leader of the organization owned that failure. When success came, he gave it to his team. The best management lesson I have learned did not come to me from reading a book; it came from that experience.
I learned a very important lesson that day. When failure occurred, the leader of the organization owned that failure. When success came, he gave it to his team. The best management lesson I have learned did not come to me from reading a book; it came from that experience.
Wednesday, September 24, 2008
Windows keyboard shortcuts
What is the allure of keyboard shortcuts? Do they really save time? Why bother since my mouse is permanently attached to my hand?
I like to use keyboard shortcuts, especially if someone is watching me, because they make me look like a pro. With just a few key strokes I can leave a mouser spinning his wheel! Whatever your motivation, here's a big list of keyboard shortcuts:
GENERAL SHORTCUTS
ALT- F4 - Quit a program / Shut down
ALT-TAB - Hold down the ALT key and hit tab to cycle through open windows.
CTL-ESCAPE - Display the Start menu
SHIFT - TAB - tab backwards through a form
CTRL - X - Cut
CTRL - C - Copy
CTRL - V - Paste
F1 - Help menu
CTRL - Z - Undo
SHIFT & Restart - To restart just windows and not your whole computer, hold down the shift key when you click the OK button on the shutdown screen. Saves lots of time. (not for XP)
CRTL-TAB - Navigate tabs on a tabbed screen
FILE & DESKTOP SHORTCUTS
Hold SHIFT while inserting a CD - Prevents the CD from "autorunning"
If an item is selected:
CTRL while dragging a file - Copies the file
CTRL - SHIFT while dragging a file - Creates a shortcut to the file
SHIFT - DELETE - Deletes an item without sending it to the recycle bin.
ALT-ENTER - Display a file's properties.
F2 - To rename the file
In Windows Explorer:
LEFT ARROW - Collapse the current selection if it is expanded
NUM LOCK-MINUS SIGN (-) - Collapse the selected folder
RIGHT ARROW - Expand the current selection if it is collapsed -Or- Select the first subfolder
NUM LOCK- * Expand all folders below the current selection
NUM LOCK- PLUS SIGN (+) - Expand the selected folder
F6 - Switch between left and right panes
In My Computer:
BACKSPACE - View the folder one level up
ALT- RIGHT ARROW - Move forward to a previous view
ALT- LEFT ARROW -Move backward to a previous view
INTERNET BROWSER SHORTCUTS
For Internet Explorer 6 and Netscape 7 (may work in older versions)
Open History Window
Ctrl+H
Reload
Ctrl+R
Back (Previous Page)
Alt+Left Arrow or Alt+Backspace
Forward (Next Page)
Alt+Right Arrow
Stop
Esc
Home
Alt+Home
Go to Bottom of Page
End
Go to Top of Page
Home
New Window
Ctrl+N
Close WIndow
Ctrl+W
Go Up one Line
Up Arrow
Go Down One Line
Down Arrow
Full Screen (toggle)
F11
Find on Page
Ctrl+F
Add Current Page to Favorites
Ctrl+D
Print Current Pageor Active Frame
Ctrl+P
Organize Favorites (IE)/Manage Bookmarks (NS)
Ctrl+B
Maximize a Window
Alt+Space+x
Minimize a window
Alt+Space+N
Scroll page up
Alt+Up Arrow
Scroll page down
Alt+Down Arrow
Internet Explorer ONLY
Open Favorites Bar
Ctrl+I
Select text in address bar
Alt+D
Force Reload (not from cache)
Ctrl+F5
A faster way to type in addresses with IE is to just type in the name of the site:
worldstart
and hit CTRL + Enter. The "http://www. " and ".com" will be added for you!
Netscape ONLY
Open / Close Sidebar Panel (toggle)
F9
Select text in Location Bar
Ctrl+L
Force Reload (not from Cache)
Ctrl+Shift+R
Zoom Text Smaller
Ctrl+- (minus)
Zoom text larger
Ctrl+= (plus sign)
WINDOWS KEY SHORTCUTS
The Windows key can be used in conjunction with other keys to act as a keyboard shortcut for faster access to menu commands. Now, while the Alt key tends to open program menus (ex: Alt+F opens the File menu and Alt+E opens the Edit menu) and the Ctrl key performs actual operations (ex: Ctrl+C will copy and Ctrl+V will paste), the Windows key will open various Windows tools...
Win key + R will open the Start menu's Run boxWin key + F will open the Start menu's Find windowWin key + E will quickly launch ExplorerWin key + Pause/Break will open the System Properties windowWin key + M will Minimize all windowsWin key + Shift + M will undo Minimize all windowsWin key + D will switch between minimizing all open programs and showing them allWin key + Tab will cycle through items on the taskbarWin key by itself will open the Start menu
You can also open programs or folders on your desktop by pressing the Windows key + the first letter of the program/folder/ shortcut + Enter . Sounds kinda tedious, but if you're in a bind with your mouse, it can come in quite handy.
ARROW TRICKS
Here's a cool little arrow trick to try with word processing programs. Next time you're using your arrow keys to go from one area of a sentence to another (left and right arrows), hold down your CTRL key. Instead of moving one space at a time, you'll go one word at a time.
If you're using the up and down arrows to go from line to line, holding down the CTRL key will make your cursor jump from paragraph to paragraph (well, from carriage return to carriage return anyway).
One last thing, if you hold down the SHIFT key while you do this (i.e. hold down SHIFT + CTRL at the same time), you select text as you arrow along.
I've tested this in MS Word and Wordpad, but it *should* work no matter what word processing program you use.
HOME / END KEY FUN
Do you ever find yourself scrolling through a huge folder ? Well, if you need to get to the beginning or the end quickly, just press Ctrl+Home . If you want to get to the end, click Ctrl+End.
Hey, that's not all!
This little trick works on more than just folders. If you use the Home key in a word processor, it goes to the beginning of the line you're currently working on. If you hit the END key, it should head to the end of the current line. If you pair Home & End up with the Ctrl key in a word processor, you will be whisked away to the beginning or end of the document. Again, this should work, but it depends on your word processor.
Speedup your work by using keyboard more and mouse less.
Useful Shortcut:
Start + M: Minimizes all open windows
Start + Shift + M: Maximizes All Windows
Start + E: Runs Windows Explorer
Start + R: Open the RUN Dialog Box
Start + F: Open the Search Results Dialog box
Start + CTRL + F: Opens the Search Results-Computer dialog Box (if the computer is connected to a network)
Start + Pause (Break): Opens the System Properties Dialog BoxWindows System Key Combinations:
F1: Help
CTRL + ESC: Open Start menu
ALT + TAB: Switch between open programs
ALT + F4: Quit program
SHIFT + DELETE: Delete item permanently
Windows Program Key Combinations:
CTRL + C: Copy
CTRL + X: Cut
CTRL + V: Paste
CTRL + Z: Undo
CTRL + B: Bold
CTRL + U: Underline
CTRL + I: ItalicMouse Click/Keyboard Modifier Combinations for Shell Objects:
SHIFT + right click: Displays a shortcut menu containing alternative commands
SHIFT + double click: Runs the alternate default command (the second item on the menu)
ALT + double click: Displays properties
SHIFT + DELETE: Deletes an item immediately without placing it in the Recycle Bin
General Keyboard-Only Commands:
F1: Starts Windows Help
F10: Activates menu bar options
SHIFT + F10: Opens a shortcut menu for the selected item (this is the same as right-clicking an object
CTRL + ESC: Opens the Start menu (use the ARROW keys to select an item)
CTRL + ESC or ESC: Selects the Start button (press TAB to select the taskbar, or press SHIFT+F10 for a context menu)
ALT + DOWN ARROW: Opens a drop-down list box
ALT + TAB: Switch to another running program (hold down the ALT key and then press the TAB key to view the task-switching window)
SHIFT: Press and hold down the SHIFT key while you insert a CD-ROM to bypass the automatic-run feature
ALT + SPACE: Displays the main window's System menu (from the System menu, you can restore, move, resize, minimize, maximize, or close the window)
ALT +- (ALT + hyphen): Displays the Multiple Document Interface (MDI)child window's System menu (from the MDI child window's System menu, you can restore, move, resize, minimize, maximize, or close the child window)
CTRL + TAB: Switch to the next child window of a Multiple Document Interface (MDI) program
ALT + underlined letter in menu: Opens the menu
ALT + F4: Closes the current window
CTRL + F4: Closes the current Multiple Document Interface (MDI) window
ALT + F6: Switch between multiple windows in the same program (for example, when the Notepad Find dialog box is displayed
ALT + F6: switches between the Find dialog box and the main Notepad window)
Shell Objects and General Folder/Windows Explorer Shortcuts For a selected object:
F2: Rename objectF3: Find all files
CTRL + X: Cut
CTRL + C: Copy
CTRL + V: Paste
SHIFT + DELETE: Delete selection immediately, without moving the item to the Recycle Bin
ALT + ENTER: Open the properties for the selected object
To Copy a File: Press and hold down the CTRL key while you drag the file to another folder.
To Create a Shortcut: Press and hold down CTRL+SHIFT while you drag a file to the desktop or a folder.
General Folder/Shortcut Control:
F4: Selects the Go To A Different Folder box and moves down the entries in the box (if the toolbar is active in Windows Explorer)
F5: Refreshes the current window.
F6: Moves among panes in Windows Explorer
CTRL + G: Opens the Go To Folder tool (in Windows 95 Windows Explorer only)
CTRL + Z: Undo the last command
CTRL + A: Select all the items in the current window
BACKSPACE: Switch to the parent folder
SHIFT + click + Close button: For folders, close the current folder plus all parent foldersWindows Explorer Tree Control:Numeric Keypad *: Expands everything under the current selectionNumeric Keypad +: Expands the current selectionNumeric Keypad -: Collapses the current selection.RIGHT ARROW: Expands the current selection if it is not expanded, otherwise goes to the first childLEFT ARROW: Collapses the current selection if it is expanded, otherwise goes to the parentProperties Control:CTRL + TAB/CTRL + SHIFT + TAB: Move through the property tabsAccessibility Shortcuts:Press SHIFT five times: Toggles StickyKeys on and offPress down and hold the right SHIFT key for eight seconds: Toggles FilterKeys on and offPress down and hold the NUM LOCK key for five seconds: Toggles ToggleKeys on and offLeft ALT + left SHIFT+NUM LOCK: Toggles MouseKeys on and offLeft
ALT + left SHIFT+PRINT SCREEN: Toggles high contrast on and offMicrosoft Natural Keyboard Keys:Windows Logo: Start menuWindows Logo + R: Run dialog boxWindows Logo + M: Minimize allSHIFT + Windows Logo+M: Undo minimize allWindows Logo + F1: HelpWindows Logo + E: Windows ExplorerWindows Logo + F: Find files or foldersWindows Logo + D: Minimizes all open windows and displays the desktopCTRL + Windows Logo + F: Find computerCTRL + Windows Logo + TAB: Moves focus from Start, to the Quick Launch toolbar, to the system tray (use RIGHT ARROW or LEFT ARROW to move focus to items on the Quick Launch toolbar and the system tray)Windows Logo + TAB: Cycle through taskbar buttonsWindows Logo + Break: System Properties dialog boxApplication key: Displays a shortcut menu for the selected itemMicrosoft Natural Keyboard with IntelliType Software Installed:Windows Logo + L: Log off WindowsWindows Logo + P: Starts Print ManagerWindows Logo + C: Opens Control PanelWindows Logo + V: Starts ClipboardWindows Logo + K: Opens Keyboard Properties dialog boxWindows Logo + I: Opens Mouse Properties dialog boxWindows Logo + A: Starts Accessibility Options (if installed)Windows Logo + SPACEBAR: Displays the list of Microsoft IntelliType shortcut keysWindows Logo + S: Toggles CAPS LOCK on and offDialog Box Keyboard Commands:TAB: Move to the next control in the dialog boxSHIFT + TAB: Move to the previous control in the dialog boxSPACEBAR: If the current control is a button, this clicks the button. If the current control is a check box, this toggles the check box. If the current control is an option, this selects the option.
ENTER: Equivalent to clicking the selected button (the button with the outline)
ESC: Equivalent to clicking the Cancel button
ALT + underlined letter in dialog box item: Move to the corresponding item
I like to use keyboard shortcuts, especially if someone is watching me, because they make me look like a pro. With just a few key strokes I can leave a mouser spinning his wheel! Whatever your motivation, here's a big list of keyboard shortcuts:
GENERAL SHORTCUTS
ALT- F4 - Quit a program / Shut down
ALT-TAB - Hold down the ALT key and hit tab to cycle through open windows.
CTL-ESCAPE - Display the Start menu
SHIFT - TAB - tab backwards through a form
CTRL - X - Cut
CTRL - C - Copy
CTRL - V - Paste
F1 - Help menu
CTRL - Z - Undo
SHIFT & Restart - To restart just windows and not your whole computer, hold down the shift key when you click the OK button on the shutdown screen. Saves lots of time. (not for XP)
CRTL-TAB - Navigate tabs on a tabbed screen
FILE & DESKTOP SHORTCUTS
Hold SHIFT while inserting a CD - Prevents the CD from "autorunning"
If an item is selected:
CTRL while dragging a file - Copies the file
CTRL - SHIFT while dragging a file - Creates a shortcut to the file
SHIFT - DELETE - Deletes an item without sending it to the recycle bin.
ALT-ENTER - Display a file's properties.
F2 - To rename the file
In Windows Explorer:
LEFT ARROW - Collapse the current selection if it is expanded
NUM LOCK-MINUS SIGN (-) - Collapse the selected folder
RIGHT ARROW - Expand the current selection if it is collapsed -Or- Select the first subfolder
NUM LOCK- * Expand all folders below the current selection
NUM LOCK- PLUS SIGN (+) - Expand the selected folder
F6 - Switch between left and right panes
In My Computer:
BACKSPACE - View the folder one level up
ALT- RIGHT ARROW - Move forward to a previous view
ALT- LEFT ARROW -Move backward to a previous view
INTERNET BROWSER SHORTCUTS
For Internet Explorer 6 and Netscape 7 (may work in older versions)
Open History Window
Ctrl+H
Reload
Ctrl+R
Back (Previous Page)
Alt+Left Arrow or Alt+Backspace
Forward (Next Page)
Alt+Right Arrow
Stop
Esc
Home
Alt+Home
Go to Bottom of Page
End
Go to Top of Page
Home
New Window
Ctrl+N
Close WIndow
Ctrl+W
Go Up one Line
Up Arrow
Go Down One Line
Down Arrow
Full Screen (toggle)
F11
Find on Page
Ctrl+F
Add Current Page to Favorites
Ctrl+D
Print Current Pageor Active Frame
Ctrl+P
Organize Favorites (IE)/Manage Bookmarks (NS)
Ctrl+B
Maximize a Window
Alt+Space+x
Minimize a window
Alt+Space+N
Scroll page up
Alt+Up Arrow
Scroll page down
Alt+Down Arrow
Internet Explorer ONLY
Open Favorites Bar
Ctrl+I
Select text in address bar
Alt+D
Force Reload (not from cache)
Ctrl+F5
A faster way to type in addresses with IE is to just type in the name of the site:
worldstart
and hit CTRL + Enter. The "http://www. " and ".com" will be added for you!
Netscape ONLY
Open / Close Sidebar Panel (toggle)
F9
Select text in Location Bar
Ctrl+L
Force Reload (not from Cache)
Ctrl+Shift+R
Zoom Text Smaller
Ctrl+- (minus)
Zoom text larger
Ctrl+= (plus sign)
WINDOWS KEY SHORTCUTS
The Windows key can be used in conjunction with other keys to act as a keyboard shortcut for faster access to menu commands. Now, while the Alt key tends to open program menus (ex: Alt+F opens the File menu and Alt+E opens the Edit menu) and the Ctrl key performs actual operations (ex: Ctrl+C will copy and Ctrl+V will paste), the Windows key will open various Windows tools...
Win key + R will open the Start menu's Run boxWin key + F will open the Start menu's Find windowWin key + E will quickly launch ExplorerWin key + Pause/Break will open the System Properties windowWin key + M will Minimize all windowsWin key + Shift + M will undo Minimize all windowsWin key + D will switch between minimizing all open programs and showing them allWin key + Tab will cycle through items on the taskbarWin key by itself will open the Start menu
You can also open programs or folders on your desktop by pressing the Windows key + the first letter of the program/folder/ shortcut + Enter . Sounds kinda tedious, but if you're in a bind with your mouse, it can come in quite handy.
ARROW TRICKS
Here's a cool little arrow trick to try with word processing programs. Next time you're using your arrow keys to go from one area of a sentence to another (left and right arrows), hold down your CTRL key. Instead of moving one space at a time, you'll go one word at a time.
If you're using the up and down arrows to go from line to line, holding down the CTRL key will make your cursor jump from paragraph to paragraph (well, from carriage return to carriage return anyway).
One last thing, if you hold down the SHIFT key while you do this (i.e. hold down SHIFT + CTRL at the same time), you select text as you arrow along.
I've tested this in MS Word and Wordpad, but it *should* work no matter what word processing program you use.
HOME / END KEY FUN
Do you ever find yourself scrolling through a huge folder ? Well, if you need to get to the beginning or the end quickly, just press Ctrl+Home . If you want to get to the end, click Ctrl+End.
Hey, that's not all!
This little trick works on more than just folders. If you use the Home key in a word processor, it goes to the beginning of the line you're currently working on. If you hit the END key, it should head to the end of the current line. If you pair Home & End up with the Ctrl key in a word processor, you will be whisked away to the beginning or end of the document. Again, this should work, but it depends on your word processor.
Speedup your work by using keyboard more and mouse less.
Useful Shortcut:
Start + M: Minimizes all open windows
Start + Shift + M: Maximizes All Windows
Start + E: Runs Windows Explorer
Start + R: Open the RUN Dialog Box
Start + F: Open the Search Results Dialog box
Start + CTRL + F: Opens the Search Results-Computer dialog Box (if the computer is connected to a network)
Start + Pause (Break): Opens the System Properties Dialog BoxWindows System Key Combinations:
F1: Help
CTRL + ESC: Open Start menu
ALT + TAB: Switch between open programs
ALT + F4: Quit program
SHIFT + DELETE: Delete item permanently
Windows Program Key Combinations:
CTRL + C: Copy
CTRL + X: Cut
CTRL + V: Paste
CTRL + Z: Undo
CTRL + B: Bold
CTRL + U: Underline
CTRL + I: ItalicMouse Click/Keyboard Modifier Combinations for Shell Objects:
SHIFT + right click: Displays a shortcut menu containing alternative commands
SHIFT + double click: Runs the alternate default command (the second item on the menu)
ALT + double click: Displays properties
SHIFT + DELETE: Deletes an item immediately without placing it in the Recycle Bin
General Keyboard-Only Commands:
F1: Starts Windows Help
F10: Activates menu bar options
SHIFT + F10: Opens a shortcut menu for the selected item (this is the same as right-clicking an object
CTRL + ESC: Opens the Start menu (use the ARROW keys to select an item)
CTRL + ESC or ESC: Selects the Start button (press TAB to select the taskbar, or press SHIFT+F10 for a context menu)
ALT + DOWN ARROW: Opens a drop-down list box
ALT + TAB: Switch to another running program (hold down the ALT key and then press the TAB key to view the task-switching window)
SHIFT: Press and hold down the SHIFT key while you insert a CD-ROM to bypass the automatic-run feature
ALT + SPACE: Displays the main window's System menu (from the System menu, you can restore, move, resize, minimize, maximize, or close the window)
ALT +- (ALT + hyphen): Displays the Multiple Document Interface (MDI)child window's System menu (from the MDI child window's System menu, you can restore, move, resize, minimize, maximize, or close the child window)
CTRL + TAB: Switch to the next child window of a Multiple Document Interface (MDI) program
ALT + underlined letter in menu: Opens the menu
ALT + F4: Closes the current window
CTRL + F4: Closes the current Multiple Document Interface (MDI) window
ALT + F6: Switch between multiple windows in the same program (for example, when the Notepad Find dialog box is displayed
ALT + F6: switches between the Find dialog box and the main Notepad window)
Shell Objects and General Folder/Windows Explorer Shortcuts For a selected object:
F2: Rename objectF3: Find all files
CTRL + X: Cut
CTRL + C: Copy
CTRL + V: Paste
SHIFT + DELETE: Delete selection immediately, without moving the item to the Recycle Bin
ALT + ENTER: Open the properties for the selected object
To Copy a File: Press and hold down the CTRL key while you drag the file to another folder.
To Create a Shortcut: Press and hold down CTRL+SHIFT while you drag a file to the desktop or a folder.
General Folder/Shortcut Control:
F4: Selects the Go To A Different Folder box and moves down the entries in the box (if the toolbar is active in Windows Explorer)
F5: Refreshes the current window.
F6: Moves among panes in Windows Explorer
CTRL + G: Opens the Go To Folder tool (in Windows 95 Windows Explorer only)
CTRL + Z: Undo the last command
CTRL + A: Select all the items in the current window
BACKSPACE: Switch to the parent folder
SHIFT + click + Close button: For folders, close the current folder plus all parent foldersWindows Explorer Tree Control:Numeric Keypad *: Expands everything under the current selectionNumeric Keypad +: Expands the current selectionNumeric Keypad -: Collapses the current selection.RIGHT ARROW: Expands the current selection if it is not expanded, otherwise goes to the first childLEFT ARROW: Collapses the current selection if it is expanded, otherwise goes to the parentProperties Control:CTRL + TAB/CTRL + SHIFT + TAB: Move through the property tabsAccessibility Shortcuts:Press SHIFT five times: Toggles StickyKeys on and offPress down and hold the right SHIFT key for eight seconds: Toggles FilterKeys on and offPress down and hold the NUM LOCK key for five seconds: Toggles ToggleKeys on and offLeft ALT + left SHIFT+NUM LOCK: Toggles MouseKeys on and offLeft
ALT + left SHIFT+PRINT SCREEN: Toggles high contrast on and offMicrosoft Natural Keyboard Keys:Windows Logo: Start menuWindows Logo + R: Run dialog boxWindows Logo + M: Minimize allSHIFT + Windows Logo+M: Undo minimize allWindows Logo + F1: HelpWindows Logo + E: Windows ExplorerWindows Logo + F: Find files or foldersWindows Logo + D: Minimizes all open windows and displays the desktopCTRL + Windows Logo + F: Find computerCTRL + Windows Logo + TAB: Moves focus from Start, to the Quick Launch toolbar, to the system tray (use RIGHT ARROW or LEFT ARROW to move focus to items on the Quick Launch toolbar and the system tray)Windows Logo + TAB: Cycle through taskbar buttonsWindows Logo + Break: System Properties dialog boxApplication key: Displays a shortcut menu for the selected itemMicrosoft Natural Keyboard with IntelliType Software Installed:Windows Logo + L: Log off WindowsWindows Logo + P: Starts Print ManagerWindows Logo + C: Opens Control PanelWindows Logo + V: Starts ClipboardWindows Logo + K: Opens Keyboard Properties dialog boxWindows Logo + I: Opens Mouse Properties dialog boxWindows Logo + A: Starts Accessibility Options (if installed)Windows Logo + SPACEBAR: Displays the list of Microsoft IntelliType shortcut keysWindows Logo + S: Toggles CAPS LOCK on and offDialog Box Keyboard Commands:TAB: Move to the next control in the dialog boxSHIFT + TAB: Move to the previous control in the dialog boxSPACEBAR: If the current control is a button, this clicks the button. If the current control is a check box, this toggles the check box. If the current control is an option, this selects the option.
ENTER: Equivalent to clicking the selected button (the button with the outline)
ESC: Equivalent to clicking the Cancel button
ALT + underlined letter in dialog box item: Move to the corresponding item
Excel Keys
CTRL+SHIFT+ (
Unhides any hidden rows within the selection.
CTRL+SHIFT+ )
Unhides any hidden columns within the selection.
CTRL+SHIFT+&
Applies the outline border to the selected cells.
CTRL+SHIFT_
Removes the outline border from the selected cells.
CTRL+SHIFT+~
Applies the General number format.
CTRL+SHIFT+$
Applies the Currency format with two decimal places (negative numbers in parentheses) .
CTRL+SHIFT+%
Applies the Percentage format with no decimal places.
CTRL+SHIFT+^
Applies the Exponential number format with two decimal places.
CTRL+SHIFT+#
Applies the Date format with the day, month, and year.
CTRL+SHIFT+@
Applies the Time format with the hour and minute, and AM or PM.
CTRL+SHIFT+!
Applies the Number format with two decimal places, thousands separator, and minus sign (-) for negative values.
CTRL+SHIFT+*
Selects the current region around the active cell (the data area enclosed by blank rows and blank columns).
In a PivotTable, it selects the entire PivotTable report.
CTRL+SHIFT+:
Enters the current time.
CTRL+SHIFT+"
Copies the value from the cell above the active cell into the cell or the Formula Bar.
CTRL+SHIFT+Plus (+)
Displays the Insert dialog box to insert blank cells.
CTRL+Minus (-)
Displays the Delete dialog box to delete the selected cells.
CTRL+;
Enters the current date.
CTRL+`
Alternates between displaying cell values and displaying formulas in the worksheet.
CTRL+'
Copies a formula from the cell above the active cell into the cell or the Formula Bar.
CTRL+1
Displays the Format Cells dialog box.
CTRL+2
Applies or removes bold formatting.
CTRL+3
Applies or removes italic formatting.
CTRL+4
Applies or removes underlining.
CTRL+5
Applies or removes strikethrough.
CTRL+6
Alternates between hiding objects, displaying objects, and displaying placeholders for objects.
CTRL+8
Displays or hides the outline symbols.
CTRL+9
Hides the selected rows.
CTRL+0
Hides the selected columns.
CTRL+A
Selects the entire worksheet.
If the worksheet contains data, CTRL+A selects the current region. Pressing CTRL+A a second time selects the current region and its summary rows. Pressing CTRL+A a third time selects the entire worksheet.
When the insertion point is to the right of a function name in a formula, displays the Function Arguments dialog box.
CTRL+SHIFT+A inserts the argument names and parentheses when the insertion point is to the right of a function name in a formula.
CTRL+B
Applies or removes bold formatting.
CTRL+C
Copies the selected cells.
CTRL+C followed by another CTRL+C displays the Clipboard.
CTRL+D
Uses the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below.
CTRL+F
Displays the Find and Replace dialog box, with the Find tab selected.
SHIFT+F5 also displays this tab, while SHIFT+F4 repeats the last Find action.
CTRL+SHIFT+F opens the Format Cells dialog box with the Font tab selected.
CTRL+G
Displays the Go To dialog box.
F5 also displays this dialog box.
CTRL+H
Displays the Find and Replace dialog box, with the Replace tab selected.
CTRL+I
Applies or removes italic formatting.
CTRL+K
Displays the Insert Hyperlink dialog box for new hyperlinks or the Edit Hyperlink dialog box for selected existing hyperlinks.
CTRL+N
Creates a new, blank workbook.
CTRL+O
Displays the Open dialog box to open or find a file.
CTRL+SHIFT+O selects all cells that contain comments.
CTRL+P
Displays the Print dialog box.
CTRL+SHIFT+P opens the Format Cells dialog box with the Font tab selected.
CTRL+R
Uses the Fill Right command to copy the contents and format of the leftmost cell of a selected range into the cells to the right.
CTRL+S
Saves the active file with its current file name, location, and file format.
CTRL+T
Displays the Create Table dialog box.
CTRL+U
Applies or removes underlining.
CTRL+SHIFT+U switches between expanding and collapsing of the formula bar.
CTRL+V
Inserts the contents of the Clipboard at the insertion point and replaces any selection. Available only after you have cut or copied an object, text, or cell contents.
CTRL+ALT+V displays the Paste Special dialog box. Available only after you have cut or copied an object, text, or cell contents on a worksheet or in another program.
CTRL+W
Closes the selected workbook window.
CTRL+X
Cuts the selected cells.
CTRL+Y
Repeats the last command or action, if possible.
CTRL+Z
Uses the Undo command to reverse the last command or to delete the last entry that you typed.
CTRL+SHIFT+Z uses the Undo or Redo command to reverse or restore the last automatic correction when AutoCorrect Smart Tags are displayed.
Function keys
Key
Description
F1
Displays the Microsoft Office Excel Help task pane.
CTRL+F1 displays or hides the Ribbon, a component of the Microsoft Office Fluent user interface.
ALT+F1 creates a chart of the data in the current range.
ALT+SHIFT+F1 inserts a new worksheet.
F2
Edits the active cell and positions the insertion point at the end of the cell contents. It also moves the insertion point into the Formula Bar when editing in a cell is turned off.
SHIFT+F2 adds or edits a cell comment.
CTRL+F2 displays the Print Preview window.
F3
Displays the Paste Name dialog box.
SHIFT+F3 displays the Insert Function dialog box.
F4
Repeats the last command or action, if possible.
CTRL+F4 closes the selected workbook window.
F5
Displays the Go To dialog box.
CTRL+F5 restores the window size of the selected workbook window.
F6
Switches between the worksheet, Ribbon, task pane, and Zoom controls. In a worksheet that has been split (View menu, Manage This Window, Freeze Panes, Split Window command), F6 includes the split panes when switching between panes and the Ribbon area.
SHIFT+F6 switches between the worksheet, Zoom controls, task pane, and Ribbon.
CTRL+F6 switches to the next workbook window when more than one workbook window is open.
F7
Displays the Spelling dialog box to check spelling in the active worksheet or selected range.
CTRL+F7 performs the Move command on the workbook window when it is not maximized. Use the arrow keys to move the window, and when finished press ENTER, or ESC to cancel.
F8
Turns extend mode on or off. In extend mode, Extended Selection appears in the status line, and the arrow keys extend the selection.
SHIFT+F8 enables you to add a nonadjacent cell or range to a selection of cells by using the arrow keys.
CTRL+F8 performs the Size command (on the Control menu for the workbook window) when a workbook is not maximized.
ALT+F8 displays the Macro dialog box to create, run, edit, or delete a macro.
F9
Calculates all worksheets in all open workbooks.
SHIFT+F9 calculates the active worksheet.
CTRL+ALT+F9 calculates all worksheets in all open workbooks, regardless of whether they have changed since the last calculation.
CTRL+ALT+SHIFT+ F9 rechecks dependent formulas, and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated.
CTRL+F9 minimizes a workbook window to an icon.
F10
Turns key tips on or off.
SHIFT+F10 displays the shortcut menu for a selected item.
ALT+SHIFT+F10 displays the menu or message for a smart tag. If more than one smart tag is present, it switches to the next smart tag and displays its menu or message.
CTRL+F10 maximizes or restores the selected workbook window.
F11
Creates a chart of the data in the current range.
SHIFT+F11 inserts a new worksheet.
ALT+F11 opens the Microsoft Visual Basic Editor, in which you can create a macro by using Visual Basic for Applications (VBA).
F12
Displays the Save As dialog box.
Top of Page
Other useful shortcut keys
Key
Description
ARROW KEYS
Move one cell up, down, left, or right in a worksheet.
CTRL+ARROW KEY moves to the edge of the current data region (data region: A range of cells that contains data and that is bounded by empty cells or datasheet borders.) in a worksheet.
SHIFT+ARROW KEY extends the selection of cells by one cell.
CTRL+SHIFT+ARROW KEY extends the selection of cells to the last nonblank cell in the same column or row as the active cell, or if the next cell is blank, extends the selection to the next nonblank cell.
LEFT ARROW or RIGHT ARROW selects the tab to the left or right when the Ribbon is selected. When a submenu is open or selected, these arrow keys switch between the main menu and the submenu. When a Ribbon tab is selected, these keys navigate the tab buttons.
DOWN ARROW or UP ARROW selects the next or previous command when a menu or submenu is open. When a Ribbon tab is selected, these keys navigate up or down the tab group.
In a dialog box, arrow keys move between options in an open drop-down list, or between options in a group of options.
DOWN ARROW or ALT+DOWN ARROW opens a selected drop-down list.
BACKSPACE
Deletes one character to the left in the Formula Bar.
Also clears the content of the active cell.
In cell editing mode, it deletes the character to the left of the insertion point.
DELETE
Removes the cell contents (data and formulas) from selected cells without affecting cell formats or comments.
In cell editing mode, it deletes the character to the right of the insertion point.
END
Moves to the cell in the lower-right corner of the window when SCROLL LOCK is turned on.
Also selects the last command on the menu when a menu or submenu is visible.
CTRL+END moves to the last cell on a worksheet, in the lowest used row of the rightmost used column. If the cursor is in the formula bar, CTRL+END moves the cursor to the end of the text.
CTRL+SHIFT+END extends the selection of cells to the last used cell on the worksheet (lower-right corner). If the cursor is in the formula bar, CTRL+SHIFT+END selects all text in the formula bar from the cursor position to the end�this does not affect the height of the formula bar.
ENTER
Completes a cell entry from the cell or the Formula Bar, and selects the cell below (by default).
In a data form, it moves to the first field in the next record.
Opens a selected menu (press F10 to activate the menu bar) or performs the action for a selected command.
In a dialog box, it performs the action for the default command button in the dialog box (the button with the bold outline, often the OK button).
ALT+ENTER starts a new line in the same cell.
CTRL+ENTER fills the selected cell range with the current entry.
SHIFT+ENTER completes a cell entry and selects the cell above.
ESC
Cancels an entry in the cell or Formula Bar.
Closes an open menu or submenu, dialog box, or message window.
It also closes full screen mode when this mode has been applied, and returns to normal screen mode to display the Ribbon and status bar again.
HOME
Moves to the beginning of a row in a worksheet.
Moves to the cell in the upper-left corner of the window when SCROLL LOCK is turned on.
Selects the first command on the menu when a menu or submenu is visible.
CTRL+HOME moves to the beginning of a worksheet.
CTRL+SHIFT+HOME extends the selection of cells to the beginning of the worksheet.
PAGE DOWN
Moves one screen down in a worksheet.
ALT+PAGE DOWN moves one screen to the right in a worksheet.
CTRL+PAGE DOWN moves to the next sheet in a workbook.
CTRL+SHIFT+PAGE DOWN selects the current and next sheet in a workbook.
PAGE UP
Moves one screen up in a worksheet.
ALT+PAGE UP moves one screen to the left in a worksheet.
CTRL+PAGE UP moves to the previous sheet in a workbook.
CTRL+SHIFT+PAGE UP selects the current and previous sheet in a workbook.
SPACEBAR
In a dialog box, performs the action for the selected button, or selects or clears a check box.
CTRL+SPACEBAR selects an entire column in a worksheet.
SHIFT+SPACEBAR selects an entire row in a worksheet.
CTRL+SHIFT+SPACEBAR selects the entire worksheet.
If the worksheet contains data, CTRL+SHIFT+SPACEBAR selects the current region. Pressing CTRL+SHIFT+SPACEBAR a second time selects the current region and its summary rows. Pressing CTRL+SHIFT+SPACEBAR a third time selects the entire worksheet.
When an object is selected, CTRL+SHIFT+SPACEBAR selects all objects on a worksheet.
ALT+SPACEBAR displays the Control menu for the Microsoft Office Excel window.
TAB
Moves one cell to the right in a worksheet.
Moves between unlocked cells in a protected worksheet.
Moves to the next option or option group in a dialog box.
SHIFT+TAB moves to the previous cell in a worksheet or the previous option in a dialog box.
CTRL+TAB switches to the next tab in dialog box.
CTRL+SHIFT+TAB switches to the previous tab in a dialog box
Unhides any hidden rows within the selection.
CTRL+SHIFT+ )
Unhides any hidden columns within the selection.
CTRL+SHIFT+&
Applies the outline border to the selected cells.
CTRL+SHIFT_
Removes the outline border from the selected cells.
CTRL+SHIFT+~
Applies the General number format.
CTRL+SHIFT+$
Applies the Currency format with two decimal places (negative numbers in parentheses) .
CTRL+SHIFT+%
Applies the Percentage format with no decimal places.
CTRL+SHIFT+^
Applies the Exponential number format with two decimal places.
CTRL+SHIFT+#
Applies the Date format with the day, month, and year.
CTRL+SHIFT+@
Applies the Time format with the hour and minute, and AM or PM.
CTRL+SHIFT+!
Applies the Number format with two decimal places, thousands separator, and minus sign (-) for negative values.
CTRL+SHIFT+*
Selects the current region around the active cell (the data area enclosed by blank rows and blank columns).
In a PivotTable, it selects the entire PivotTable report.
CTRL+SHIFT+:
Enters the current time.
CTRL+SHIFT+"
Copies the value from the cell above the active cell into the cell or the Formula Bar.
CTRL+SHIFT+Plus (+)
Displays the Insert dialog box to insert blank cells.
CTRL+Minus (-)
Displays the Delete dialog box to delete the selected cells.
CTRL+;
Enters the current date.
CTRL+`
Alternates between displaying cell values and displaying formulas in the worksheet.
CTRL+'
Copies a formula from the cell above the active cell into the cell or the Formula Bar.
CTRL+1
Displays the Format Cells dialog box.
CTRL+2
Applies or removes bold formatting.
CTRL+3
Applies or removes italic formatting.
CTRL+4
Applies or removes underlining.
CTRL+5
Applies or removes strikethrough.
CTRL+6
Alternates between hiding objects, displaying objects, and displaying placeholders for objects.
CTRL+8
Displays or hides the outline symbols.
CTRL+9
Hides the selected rows.
CTRL+0
Hides the selected columns.
CTRL+A
Selects the entire worksheet.
If the worksheet contains data, CTRL+A selects the current region. Pressing CTRL+A a second time selects the current region and its summary rows. Pressing CTRL+A a third time selects the entire worksheet.
When the insertion point is to the right of a function name in a formula, displays the Function Arguments dialog box.
CTRL+SHIFT+A inserts the argument names and parentheses when the insertion point is to the right of a function name in a formula.
CTRL+B
Applies or removes bold formatting.
CTRL+C
Copies the selected cells.
CTRL+C followed by another CTRL+C displays the Clipboard.
CTRL+D
Uses the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below.
CTRL+F
Displays the Find and Replace dialog box, with the Find tab selected.
SHIFT+F5 also displays this tab, while SHIFT+F4 repeats the last Find action.
CTRL+SHIFT+F opens the Format Cells dialog box with the Font tab selected.
CTRL+G
Displays the Go To dialog box.
F5 also displays this dialog box.
CTRL+H
Displays the Find and Replace dialog box, with the Replace tab selected.
CTRL+I
Applies or removes italic formatting.
CTRL+K
Displays the Insert Hyperlink dialog box for new hyperlinks or the Edit Hyperlink dialog box for selected existing hyperlinks.
CTRL+N
Creates a new, blank workbook.
CTRL+O
Displays the Open dialog box to open or find a file.
CTRL+SHIFT+O selects all cells that contain comments.
CTRL+P
Displays the Print dialog box.
CTRL+SHIFT+P opens the Format Cells dialog box with the Font tab selected.
CTRL+R
Uses the Fill Right command to copy the contents and format of the leftmost cell of a selected range into the cells to the right.
CTRL+S
Saves the active file with its current file name, location, and file format.
CTRL+T
Displays the Create Table dialog box.
CTRL+U
Applies or removes underlining.
CTRL+SHIFT+U switches between expanding and collapsing of the formula bar.
CTRL+V
Inserts the contents of the Clipboard at the insertion point and replaces any selection. Available only after you have cut or copied an object, text, or cell contents.
CTRL+ALT+V displays the Paste Special dialog box. Available only after you have cut or copied an object, text, or cell contents on a worksheet or in another program.
CTRL+W
Closes the selected workbook window.
CTRL+X
Cuts the selected cells.
CTRL+Y
Repeats the last command or action, if possible.
CTRL+Z
Uses the Undo command to reverse the last command or to delete the last entry that you typed.
CTRL+SHIFT+Z uses the Undo or Redo command to reverse or restore the last automatic correction when AutoCorrect Smart Tags are displayed.
Function keys
Key
Description
F1
Displays the Microsoft Office Excel Help task pane.
CTRL+F1 displays or hides the Ribbon, a component of the Microsoft Office Fluent user interface.
ALT+F1 creates a chart of the data in the current range.
ALT+SHIFT+F1 inserts a new worksheet.
F2
Edits the active cell and positions the insertion point at the end of the cell contents. It also moves the insertion point into the Formula Bar when editing in a cell is turned off.
SHIFT+F2 adds or edits a cell comment.
CTRL+F2 displays the Print Preview window.
F3
Displays the Paste Name dialog box.
SHIFT+F3 displays the Insert Function dialog box.
F4
Repeats the last command or action, if possible.
CTRL+F4 closes the selected workbook window.
F5
Displays the Go To dialog box.
CTRL+F5 restores the window size of the selected workbook window.
F6
Switches between the worksheet, Ribbon, task pane, and Zoom controls. In a worksheet that has been split (View menu, Manage This Window, Freeze Panes, Split Window command), F6 includes the split panes when switching between panes and the Ribbon area.
SHIFT+F6 switches between the worksheet, Zoom controls, task pane, and Ribbon.
CTRL+F6 switches to the next workbook window when more than one workbook window is open.
F7
Displays the Spelling dialog box to check spelling in the active worksheet or selected range.
CTRL+F7 performs the Move command on the workbook window when it is not maximized. Use the arrow keys to move the window, and when finished press ENTER, or ESC to cancel.
F8
Turns extend mode on or off. In extend mode, Extended Selection appears in the status line, and the arrow keys extend the selection.
SHIFT+F8 enables you to add a nonadjacent cell or range to a selection of cells by using the arrow keys.
CTRL+F8 performs the Size command (on the Control menu for the workbook window) when a workbook is not maximized.
ALT+F8 displays the Macro dialog box to create, run, edit, or delete a macro.
F9
Calculates all worksheets in all open workbooks.
SHIFT+F9 calculates the active worksheet.
CTRL+ALT+F9 calculates all worksheets in all open workbooks, regardless of whether they have changed since the last calculation.
CTRL+ALT+SHIFT+ F9 rechecks dependent formulas, and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated.
CTRL+F9 minimizes a workbook window to an icon.
F10
Turns key tips on or off.
SHIFT+F10 displays the shortcut menu for a selected item.
ALT+SHIFT+F10 displays the menu or message for a smart tag. If more than one smart tag is present, it switches to the next smart tag and displays its menu or message.
CTRL+F10 maximizes or restores the selected workbook window.
F11
Creates a chart of the data in the current range.
SHIFT+F11 inserts a new worksheet.
ALT+F11 opens the Microsoft Visual Basic Editor, in which you can create a macro by using Visual Basic for Applications (VBA).
F12
Displays the Save As dialog box.
Top of Page
Other useful shortcut keys
Key
Description
ARROW KEYS
Move one cell up, down, left, or right in a worksheet.
CTRL+ARROW KEY moves to the edge of the current data region (data region: A range of cells that contains data and that is bounded by empty cells or datasheet borders.) in a worksheet.
SHIFT+ARROW KEY extends the selection of cells by one cell.
CTRL+SHIFT+ARROW KEY extends the selection of cells to the last nonblank cell in the same column or row as the active cell, or if the next cell is blank, extends the selection to the next nonblank cell.
LEFT ARROW or RIGHT ARROW selects the tab to the left or right when the Ribbon is selected. When a submenu is open or selected, these arrow keys switch between the main menu and the submenu. When a Ribbon tab is selected, these keys navigate the tab buttons.
DOWN ARROW or UP ARROW selects the next or previous command when a menu or submenu is open. When a Ribbon tab is selected, these keys navigate up or down the tab group.
In a dialog box, arrow keys move between options in an open drop-down list, or between options in a group of options.
DOWN ARROW or ALT+DOWN ARROW opens a selected drop-down list.
BACKSPACE
Deletes one character to the left in the Formula Bar.
Also clears the content of the active cell.
In cell editing mode, it deletes the character to the left of the insertion point.
DELETE
Removes the cell contents (data and formulas) from selected cells without affecting cell formats or comments.
In cell editing mode, it deletes the character to the right of the insertion point.
END
Moves to the cell in the lower-right corner of the window when SCROLL LOCK is turned on.
Also selects the last command on the menu when a menu or submenu is visible.
CTRL+END moves to the last cell on a worksheet, in the lowest used row of the rightmost used column. If the cursor is in the formula bar, CTRL+END moves the cursor to the end of the text.
CTRL+SHIFT+END extends the selection of cells to the last used cell on the worksheet (lower-right corner). If the cursor is in the formula bar, CTRL+SHIFT+END selects all text in the formula bar from the cursor position to the end�this does not affect the height of the formula bar.
ENTER
Completes a cell entry from the cell or the Formula Bar, and selects the cell below (by default).
In a data form, it moves to the first field in the next record.
Opens a selected menu (press F10 to activate the menu bar) or performs the action for a selected command.
In a dialog box, it performs the action for the default command button in the dialog box (the button with the bold outline, often the OK button).
ALT+ENTER starts a new line in the same cell.
CTRL+ENTER fills the selected cell range with the current entry.
SHIFT+ENTER completes a cell entry and selects the cell above.
ESC
Cancels an entry in the cell or Formula Bar.
Closes an open menu or submenu, dialog box, or message window.
It also closes full screen mode when this mode has been applied, and returns to normal screen mode to display the Ribbon and status bar again.
HOME
Moves to the beginning of a row in a worksheet.
Moves to the cell in the upper-left corner of the window when SCROLL LOCK is turned on.
Selects the first command on the menu when a menu or submenu is visible.
CTRL+HOME moves to the beginning of a worksheet.
CTRL+SHIFT+HOME extends the selection of cells to the beginning of the worksheet.
PAGE DOWN
Moves one screen down in a worksheet.
ALT+PAGE DOWN moves one screen to the right in a worksheet.
CTRL+PAGE DOWN moves to the next sheet in a workbook.
CTRL+SHIFT+PAGE DOWN selects the current and next sheet in a workbook.
PAGE UP
Moves one screen up in a worksheet.
ALT+PAGE UP moves one screen to the left in a worksheet.
CTRL+PAGE UP moves to the previous sheet in a workbook.
CTRL+SHIFT+PAGE UP selects the current and previous sheet in a workbook.
SPACEBAR
In a dialog box, performs the action for the selected button, or selects or clears a check box.
CTRL+SPACEBAR selects an entire column in a worksheet.
SHIFT+SPACEBAR selects an entire row in a worksheet.
CTRL+SHIFT+SPACEBAR selects the entire worksheet.
If the worksheet contains data, CTRL+SHIFT+SPACEBAR selects the current region. Pressing CTRL+SHIFT+SPACEBAR a second time selects the current region and its summary rows. Pressing CTRL+SHIFT+SPACEBAR a third time selects the entire worksheet.
When an object is selected, CTRL+SHIFT+SPACEBAR selects all objects on a worksheet.
ALT+SPACEBAR displays the Control menu for the Microsoft Office Excel window.
TAB
Moves one cell to the right in a worksheet.
Moves between unlocked cells in a protected worksheet.
Moves to the next option or option group in a dialog box.
SHIFT+TAB moves to the previous cell in a worksheet or the previous option in a dialog box.
CTRL+TAB switches to the next tab in dialog box.
CTRL+SHIFT+TAB switches to the previous tab in a dialog box
Tuesday, September 23, 2008
Famous Business Tycoons of India
Adi Godrej 
Adi Godrej is the present chairman of Godrej Group of companies. He left India at the age of 17 to enroll at the Massachusetts Institute of Technology. He received his Bachelor and Master degrees in Management from the Sloan School in 1963.
Aditya Mittal 
Aditya Mittal (born c. 1974) is a Member of the Board of Directors and President and Chief Financial Officer of the world's largest steel firm Mittal Steel, which is majoritly owned by his father Lakshmi Mittal, who was ranked the fifth richest person in the world by Forbes in 2006. He has a Bachelor's Degree of Science in Economics from the Wharton School of the University of Pennsylvania in the United States.
Anil Ambani 
Anil Ambani is chairman of Reliance - Anil Dhirubhai Ambani Group which includes Reliance Capital, Reliance Infocomm and Chairman & Managing Director, Reliance Energy Limited, and was formerly Vice Chairman and Managing Director of Reliance Industries Limited. Ambani holds a Bachelor of Science degree from the University of Bombay and an MBA degree from The Wharton School at the University of Pennsylvania. Currently, he serves as a member of the Wharton Board of Overseers.He is also the Chairman of Board of Governors of DA-IICT, Gandhinagar and a member of the Board of Governors of the Indian Institute of Technology, Kanpur. He is member of the Board of Governors, Indian Institute of Management, Ahmedabad.
Aroon Purie 
Aroon Purie is an Indian journalist and the founder and editor in chief of India Today, a leading newsmagazine of India. He has served as editor of the magazine since founding it in 1975.
Azim Premji
Azim Hashim Premji (born July 24, 1945) is an Indian businessman and Chairman & CEO of one of the largest software companies in India, Wipro Technologies (headquarters located at Bangalore). He was rated the richest person in the country from 1999 to 2005 by Forbes.
Bharat Goenka 
Bharat Goenka is the managing director of Tally Solutions, India's leading company in business accounting software.
Brijmohan Lall Munjal 
Brijmohan Lall Munjal is an Industrialist and founder of The Hero Group which owns the Hero Honda Motors in India.
Deepak Mohoni
Deepak Mohoni, the man behind the most popular word used in the Indian corporate circles "SENSEX" is exceptionally brilliant(B. Tech. IIT Kanpur, MBA - IIM Calcutta), and is rated as India's foremost market strategist by many investors.
Dhiru Bhai Ambani
Dhirajlal Hirachand Ambani (28 December 1932, - 6 July 2002), better known as Dhirubhai Ambani, was an Indian business tycoon and founder of Reliance Industries Limited.A film inspired by the life of Dhirubhai is set to release in January 2007. The Hindi Film Guru, directed by Mani Ratnam and music by A.R.Rahman will show the struggle of a man who strives to make his mark in life.
Dilip Sanghvi
Dilip Shanghvi is Chairman of Sun Pharmaceuticals and has an estimated wealth of $1.4 billion.
Fakir Chand Kohli 
Fakir Chand Kohli (born February 28, 1924) is regarded as the "Father of the Indian Software Industry." He was the first General Manager of Tata Consultancy Services, a leading Indian software consultancy company. He has also worked as the Deputy General Manager of the Tata Power Company.
G.R.Gopinath 
Captain G. R Gopinath, the Managing Director of Air Deccan is a graduate of the prestigious National Defence Academy and has served the Indian Army.
Jagdish Khattar 
Jagdish Khattar is the current Managing Director of Maruti Udyog Limited. Prior to this post, he has been an officer of the Indian Administrative Service with more than 37 years of experience.
Jamnalal Bajaj
Jamnalal Bajaj (1886 – 11 February 1942) was an industrialist, a philanthropist, and Indian freedom fighter. He was also a close associate and follower of Mahatma Gandhi. Gandhi is known to have adopted him as his son. Several institutions in India bears his name, including the Jamnalal Bajaj Institute of Management Studies. He founded the Bajaj group of companies in the 30s. The group now has 24 companies, including 6 listed companies. Besides Bajaj Auto Ltd, the other major companies in the group include Mukand Ltd, Bajaj Electricals Ltd and Bajaj Hindustan Ltd.
Jyoti Naik 
Jyoti Naik, also known as Jawantiben Popat, is the President of Lijjat Papad (Shri Mahila Griha Udyog Lijjat Papad) , and she pioneered a co-operative movement currently having over 42,000 members located in different parts of India.
Karsanbhai Patel
Karsanbhai Khodidas Patel (b. 1955, Mehsana, Gujarat) is an Indian industrialist, founder of the Rs. 2500 crore (USD 500 mn) Nirma group with major interests in detergents, soaps and cosmetics. He also has interests in education, and founded a leading engineering college, the Nirma Institute of Technology.
Kasturbhai Lalbhai ( Arvind Mill ) 
Kasturbhai Lalbhai (19 December 1894 – 20 January 1980) was an Indian industrialist. He was widely perceived as a nationalist businessman akin to G. D. Birla.
K.V.Kamath 
K. V. Kamath (born December 2, 1947) is the Managing Director and CEO of ICICI Bank, the largest private bank in India. He is an alumnus of prestigious educational institutions of India like the Karnataka Regional Engineering College and the Indian Institute of Management Ahmedabad. He is the recipient of the Asian Business Leader of the Year prize awarded at the Asian Business Leader Award 2001, organised by the business television network CNBC Asia.
Lakshmi Narayanan 
Lakshmi Narayanan is CEO and President of Cognizant Technology Solutions (CTS).He holds a BS and MS in science and electronics from Bangalore University and an MBA from the Indian Institute of Science, Bangalore.
Mr. Khalid A H Ansari
Mr. Khalid A H Ansari is an Indian businessman and journalist.He is the Chairman of Mid-Day Group of Publication based in Mumbai.
Kiran Mazumdar - Shaw
Dr. Kiran Mazumdar-Shaw (b. 23 March 1953 in Bangalore) is an Indian entrepreneur. She is the Chairman & Managing Director of Biocon Ltd. In 2004, she became India’s richest woman.
Kumar Mangalam Birla 
Kumar Mangalam Birla (June 14, 1967), is among the richest persons in India and the eighth youngest billionaire outside India according to the Fortune magazine. Mr. Kumar Mangalam Birla is the Chairman of the Aditya Birla Group.
M.S.Banga 
Manvinder Singh Banga is the ex-CEO of Hindustan Lever Limited, the Indian subsidiary of Unilever, and the largest FMCG (fast moving consumer goods) company in India.Mr Banga is an alumnus of the Indian Institute of Management, Ahmedabad, one of India's premier management education institutes.
Mukesh Ambani 
Mukesh Ambani is the chairman and managing director of Reliance Industries Limited, India's largest private sector company.
M. Balachandran 
M. Balachandran (b. 1st May 1947), currently the Chairman & Managing Director (CMD) of Bank of India (BoI), is a prominent banker of India.
M. Damodaran 
M. Damodaran is the chairman of the Securities and Exchange Board of India (SEBI), the country's financial market watchdog, before that he headed the IDBI bank for a short stint.
Narayana Murthy 
N.R. Narayana Murthy is an Indian industrialist, software engineer and the founder of Infosys Technologies.He retired on 20th August, 2006. However he shall continue as the Non-Executive Chairman. He graduated with a degree in electrical engineering from the University of Mysore in 1967 and received his master's degree from IIT Kanpur in 1969.He began his career with Patni Computer Systems in Pune. He is the chairman of the governing body of both the International Institute of Information Technology - Bangalore, and the Indian Institute of Management, Ahmedabad. In addition, he is a member of the Board of Directors of INSEAD, Board of Overseers of the University of Pennsylvania's Wharton School, Cornell University Board of Trustees, Singapore Management University Board of Trustees and the Board of Advisors for the William F. Achtmeyer Center for Global Leadership at the Tuck School of Business.
Naresh Goyal 
Naresh Goyal is the founder Chairman of Jet Airways. He started operating Jet Airways in 1993. Following the 2005 IPO of Jet Airways, Forbes magazine declared him the 16th richest person in India with a net worth of $1.9 billion. Was in News recently for the "Jet-Sahara Deal" which lead to failure.
Nandan Nilekani 
He is a co-founder of India’s National Association of Software and Service Companies (NASSCOM). He is currently the CEO and Managing Director of Infosys.
Nusli Wadia 
He is the chairman and majority owner of Bombay Dyeing, a major Indian textile company, and has vast holdings in real estate across Mumbai. Nusli Wadia is the son of Neville and Dina Wadia, and the grandson of Mohammad Ali Jinnah, founder of Pakistan.
Dr. Pratap C. Reddy 
Dr. Pratap C. Reddy is a doctor and businessman who founded the first corporate chain of hospitals in India, the Apollo Hospitals Group. He is the Executive Chairman of the company.
Preetha Reddy 
Preetha Reddy, managing director of Apollo Hospitals (Chennai).
Ramalinga Raju Byrraju 
Ramalinga Raju Byrraju (born September 16, 1954), is an Indian businessman, and a pioneer of the Information Technology industry in India.He is the Chairman of Satyam Computer Services Ltd. It was founded in the late 1980's after venturing earlier into other businesses such as construction and textiles. Raju had acquired a B. Com from Andhra Loyola College at Vijayawada prior to receiving an MBA degree from Ohio University. He has attended the Owner/President course at Harvard.
Ramesh Chandra Agarwal 
Ramesh Agarwal is a media baron of India. He owns Dainik Bhaskar group of newspapers that has presence in 26 cities and six states of India and have estimated readership of over 1.5 crore
Ramesh Gelli 
Ramesh Gelli is an Indian banking executive who served as the chairman and managing director (CMD) of Vysya Bank and was a promoter and CMD of the troubled Global Trust Bank.
Ramnath Goenka 
He founded the Indian Express in 1936.
Ratan Tata 
Ratan Naval Tata (born December 28, 1937, in Bombay) is the present Chairman of the Tata Group, a leading Indian conglomerate established by earlier generations of his family.
Sushil Kumar Roongta 
Sushil Kumar Roongta is the current Chairman of Steel Authority of India Ltd. (SAIL).
S.K.Burman 
Founder of Dabur.
Sabeer Bhatia 
Sabeer Bhatia is a co-founder of Hotmail. Currently he has started a new venture called BlogEverywhere http://www.blogeverywhere.com
Salil Chaturvedi 
Salil Chaturvedi is the owner of Indian apparel brand Provogue.
Sam Pitroda
Currently chairman of India's National Knowledge Commission, he is also largely considered to have been responsible for India's communications revolution [1]. He is the Chairman and CEO of World-Tel Limited.
Sarthak Behuria
Sarthak Behuria is the chairman and Managing Director of Indian Oil Corporation. He is An alumnus of St. Stephen’s College, Delhi, and the Indian Institute of Management (IIM), Ahmedabad.
Shiv nadar 
Shiv Nadar is the CEO of Hindustan Computers Limited (HCL), a large information technology company in India.
Subhash Chandra
Chairman, Essel Group of Industries. ( Essel Group : Zee tv , Zee Cinema , Dish Tv , Essel World , Water Kingdom , playwin , kidzee , Asian Sky Shop. )
Sunil Mittal 
Chairman & Managing Director of Bharti Group. ( Airtel )
Subroto Bagchi 
Subroto Bagchi is co-founder and Chief Operating Officer for MindTree Consulting. MindTree Consulting is an international consulting company working in the IT Consulting and Software Services space.
Subrata Roy 
Subrata Roy is the chairman and "managing worker" ( Managing Director) of the Sahara Group of companies .
Uday Kotak 
Uday Kotak is an Indian businessman. He is the vice-chairman and managing director of Kotak Mahindra Bank.
Venugopal Dhoot 
Venugopal Dhoot (Born 1944 in Mumbai, India) is an Indian business tycoon. He is Chairman of Videocon Electronics.His company recently bought a color picture tube unit from the French company Thompson SA, and a refrigerator business from Swedish company Electrolux.
Verghese Kurien
Verghese Kurien (born November 26, 1921 at Kozhikode, Kerala) is called the father of the White Revolution in India. He is also known as the Milkman of India.He was the chairman of the Gujarat Co-operative Milk Marketing Federation Ltd.(GCMMF). GCMMF is an apex cooperative organization that manages the Amul food brand. He is recognised as the man behind the success of the Amul brand.
Vijay Mallya 
Vijay Mallya (born December 20, 1955) is a Bangalore-based billionaire businessman and Member of Parliament (Rajya Sabha since 2002) from India. He is the son of industrialist Vittal Mallya and is the chairman of the United Beverages Group. Mallya has started a domestic airline in India called Kingfisher Airlines
Yusuf Khwaja
Yusuf Khwaja Hamied is chairman of Cipla, a company founded by his father Khwaja Abdul Hamied.
Subscribe to:
Posts (Atom)