Microsoft Natural Keyboard Shortcuts Keys

Windows Logo+BREAK (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 a 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)

General keyboard shortcuts keys

CTRL+C(Copy)
CTRL+X (Cut)
CTRL+Z (Undo)
DELETE (Delete)
SHIFT+DELETE (Delete the selected item permanently without placing the item in the Recycle Bin)
CTRL while dragging an item (Copy the selected item)
CTRL+SHIFT while dragging an item (Create a shortcut to the selected item)
F2 key (Rename the selected item)
CTRL+RIGHT ARROW (Move the insertion point to the beginning of the next word)
CTRL+LEFT ARROW (Move the insertion point to the beginning of the previous word)
CTRL+DOWN ARROW (Move the insertion point to the beginning of the next paragraph)
CTRL+SHIFT with any of the arrow keys (Highlight a block of text)
CTRL+UP ARROW (Move the insertion point to the beginning of the previous paragraph)
SHIFT with any of the arrow keys (Select more than one item in a window or on the desktop, or select text in a document)
CTRL+A (Select all)
F3 key (Search for a file or a folder)
ALT+ENTER (View the properties for the selected item)
ALT+F4 (Close the active item, or quit the active program)
ALT+ENTER (Display the properties of the selected object)
ALT+SPACEBAR (Open the shortcut menu for the active window)
CTRL+F4 (Close the active document in programs that enable you to have multiple documents open simultaneously)
ALT+TAB (Switch between the open items)
ALT+ESC (Cycle through items in the order that they had been opened)
F6 key (Cycle through the screen elements in a window or on the desktop)
F4 key (Display the Address bar list in My Computer or Windows Explorer)
SHIFT+F10 (Display the shortcut menu for the selected item)
ALT+SPACEBAR (Display the System menu for the active window)
CTRL+ESC (Display the Start menu)
ALT+Underlined letter in a menu name (Display the corresponding menu)
Underlined letter in a command name on an open menu (Perform the corresponding command)
F10 key (Activate the menu bar in the active program)
RIGHT ARROW (Open the next menu to the right, or open a submenu)
LEFT ARROW (Open the next menu to the left, or close a submenu)
F5 key (Update the active window)
BACKSPACE (View the folder one level up in My Computer or Windows Explorer)
ESC (Cancel the current task)
SHIFT when you insert a CD-ROM into the CD-ROM drive (Prevent the CD-ROM from automatically playing)
CTRL+SHIFT+ESC (Open Task Manager) Dialog box keyboard shortcuts

If you press SHIFT+F8 in extended selection list boxes, you enable extended selection mode. In this mode, you can use an arrow key to move a cursor without changing the selection. You can press CTRL+SPACEBAR or SHIFT+SPACEBAR to adjust the selection. To cancel extended selection mode, press SHIFT+F8 again. Extended selection mode cancels itself when you move the focus to another control.

CTRL+TAB (Move forward through the tabs)
CTRL+SHIFT+TAB (Move backward through the tabs)
TAB (Move forward through the options)
SHIFT+TAB (Move backward through the options)
ALT+Underlined letter (Perform the corresponding command or select the corresponding option)
ENTER (Perform the command for the active option or button)
SPACEBAR (Select or clear the check box if the active option is a check box)
Arrow keys (Select a button if the active option is a group of option buttons)
F1 key (Display Help)
F4 key (Display the items in the active list)
BACKSPACE (Open a folder one level up if a folder is selected in the Save As or Open dialog box)

Windows XP Run Commands and Shortcuts Keys

Windows XP Home / Pro Run Commands and Shortcuts Keys

How To - Click Start, Click Run and enter the command Click OK

Run commands

Calc - Calculator
Cfgwiz32 - ISDN Configuration Wizard
Charmap - Character Map
Chkdisk - Repair damaged files
Cleanmgr - Cleans up hard drives
Clipbrd - Windows Clipboard viewer
Cmd - Opens a new Command Window (cmd.exe)
Control - Displays Control Panel
Dcomcnfg - DCOM user security
Debug - Assembly language programming tool
Defrag - Defragmentation tool
Drwatson - Records programs crash & snapshots
Dxdiag - DirectX Diagnostic Utility
Explorer - Windows Explorer
Fontview - Graphical font viewer
Ftp - ftp.exe program
Hostname - Returns Computer's name
Ipconfig - Displays IP configuration for all network adapters
Jview - Microsoft Command-line Loader for Java classes
MMC - Microsoft Management Console
Msconfig - Configuration to edit startup files
Msinfo32 - Microsoft System Information Utility
Nbtstat - Displays stats and current connections using NetBios over TCP/IP
Netstat - Displays all active network connections
Nslookup- Returns your local DNS server
Ping - Sends data to a specified host/IP
Regedit - registry Editor
Regsvr32 - register/de-register DLL/OCX/ActiveX
Regwiz - Reistration wizard
Sfc /scannow - Sytem File Checker
Sndrec32 - Sound Recorder
Sndvol32 - Volume control for soundcard
Sysedit - Edit system startup files (config.sys, autoexec.bat, win.ini, etc.)
Systeminfo - display various system information in text console
Taskmgr - Task manager
Telnet - Telnet program
Taskkill - kill processes using command line interface
Tskill - reduced version of Taskkill from Windows XP Home
Tracert - Traces and displays all paths required to reach an internet host
Winchat - simple chat program for Windows networks
Winipcfg - Displays IP configuration

Management Consoles

certmgr.msc - Certificate Manager
ciadv.msc - Indexing Service
compmgmt.msc - Computer management
devmgmt.msc - Device Manager
dfrg.msc - Defragment
diskmgmt.msc - Disk Management
fsmgmt.msc - Folder Sharing Management
eventvwr.msc - Event Viewer
gpedit.msc - Group Policy -XP Pro only
iis.msc - Internet Information Services
lusrmgr.msc - Local Users and Groups
mscorcfg.msc - Net configurations
ntmsmgr.msc - Removable Storage
perfmon.msc - Performance Manager
secpol.msc - Local Security Policy
services.msc - System Services
wmimgmt.msc - Windows Management

Shortcuts

access.cpl - Accessibility Options
hdwwiz.cpl - Add New Hardware Wizard
appwiz.cpl - dd/Remove Programs
timedate.cpl - Date and Time Properties
desk.cpl - Display Properties
inetcpl.cpl - Internet Properties
joy.cpl - Joystick Properties
main.cpl keboard - Keyboard Properties
main.cpl - Mouse Properties
ncpa.cpl - Network Connections
ncpl.cpl - Network Properties
telephon.cpl - Phone and Modem options
powercfg.cpl - Power Management
intl.cpl - Regional settings
mmsys.cpl sounds - Sound Properties
mmsys.cpl - Sounds and Audio Device Properties
sysdm.cpl - System Properties
nusrmgr.cpl - User settings
firewall.cpl - Firewall Settings (sp2)
wscui.cpl - Security Center (sp2)

Windows Environment Commands

%ALLUSERSPROFILE% - Open the All User's Profile
%HomeDrive% - Opens your home drive e.g. C:\
%UserProfile% - Opens you User's Profile
%temp% Opens - temporary file Folder
%systemroot% - Opens Windows folder

Wupdmgr - Takes you to Microsoft Windows Update 


Top 10 Keyboard Shortcut Keys

Top 10 keyboard shortcuts everyone should know

Using keyboard shortcuts can greatly increase your productivity, reduce repetitive strain, and help keep you focused. For example, highlighting text with the keyboard and pressing Ctrl + C is much faster than taking your hand from the keyboard, highlighting the text using the mouse, clicking copy from the file menu, and then putting your hand back in place on the keyboard. Below are our top 10 keyboard shortcuts we recommend everyone memorize and use.

Ctrl + C or Ctrl + Insert

Copy the highlighted text or selected item.

Ctrl + V or Shift + Insert

Paste the text or object that's in the clipboard.

Ctrl + Z and Ctrl + Y

Undo any change. For example, if you cut text, pressing this will undo it. This can also often be pressed multiple times to undo multiple changes. Pressing Ctrl + Y would redo the undo.

Ctrl + F

Open the Find in any program. This includes your Internet browser to find text on the current page.

Alt + Tab or Alt + Esc

Quickly switch between open programs moving forward.

Press Ctrl + Tab to switch between tabs in a program.

Adding the Shift key to Alt + Tab or Ctrl + Tab will move backwards. For example, if you are pressing Alt + Tab and pass the program you want to switch to, press Alt + Shift + Tab to move backwards to that program.
Windows Vista and 7 users can also press the Windows Key + Tab to switch through open programs in a full screenshot of the Window.

Ctrl + Back space
Pressing Ctrl + Backspace will delete a full word at a time instead of a single character.

Ctrl + Left arrow / Right arrow
Move the cursor one word at a time instead of one character at a time. If you wanted to highlight one word at a time you can hold down Ctrl + Shift and then press the left or right arrow key to move one word at a time in that direction while highlighting each word.

Ctrl + Home / End
Move the cursor to the beginning or end of a document.

Ctrl + P
Print the page being viewed. For example, the document in Microsoft Word or the web page in your Internet browser.

Page Up / Space bar and Page Down
Pressing either the page up or page down key will move that page one page at a time in that direction. When browsing the Internet pressing the space bar will also move the page down one page at a time.

Top 10 Unknown Google Tricks

Below is a list of our top ten Google tricks many users don't know about.

1. Definitions - Pull up the definition of the word by typing define followed by the word you want the definition for. For example, typing: define seo would display the definition of that word.
2. Local search - Visit Google Local enter the area you want to search and the keyword of the place you want to find. For example, typing: restaurant at the above link would display local restaurants.
3. Phone number lookup - Enter a full phone number with area code to display the name and address associated with that phone number.
4. Find weather - Type weather followed by a zip code or city and state to display current weather conditions and forecasts for upcoming days.
5. Track airline flight - Enter the airline and flight number to display the status of an airline flight and it's arrival time. For example, type: delta 123 to display this flight information if available.
6. Track packages - Enter a UPS, FedEx or USPS tracking number to get a direct link to track your packages.
7. Pages linked to you - See what other web pages are linking to your website or blog by typing link: followed by your URL. For example, typing link:http://latest-tamil-kavithaigal.blogspot.com displays all pages linking to Lates Tamil Kavithaigal.
8. Find PDF results only - Add filetype: to your search to display results that only match a certain file type. For example, if you wanted to display PDF results only type: "dell xps" filetype:pdf -- this is a great way to find online manuals.
9. Calculator - Use the Google Search engine as a calculator by typing a math problem in the search. For example, typing: 100 + 200 would display results as 300.
10. Stocks - Quickly get to a stock quote price, chart, and related links by typing the stock symbol in Google. For example, typing: msft will display the stock information for Microsoft.

Shortcut Keys from F1 through F12 keys

Commonly known as "function keys", F1 through F12 may have a variety of different uses or no use at all. Depending on the installed operating system and the software program currently open will change how each of these keys operate. A program is capable of not only using each of the function keys, but also combining the function keys with the ALT or CTRL key, for example, Microsoft Windows users can press ALT + F4 to close the program currently active.

Below is a short-listing of some of the common functions of the functions keys on computers running Microsoft Windows. As mentioned above not all programs support function keys and may perform different tasks then those mentioned below. If you are looking for more specific shortcut keys and function key examples we suggest seeing our shortcut key page.

F1
•    Almost always used as the help key, almost every program will open the help screen when this key is pressed.
•    Enter CMOS Setup.
•    Windows Key + F1 would open the Microsoft Windows help and support center.
•    Open the Task Pane.
F2
•    In Windows commonly used to rename a highlighted icon or file.
•    Alt + Ctrl + F2 opens a new document in Microsoft Word.
•    Ctrl + F2 displays the print preview window in Microsoft Word.
•    Enter CMOS Setup.
F3
•    Often opens a search feature for many programs including Microsoft Windows.
•    In MS-DOS or Windows command line F3 will repeat the last command.
•    Shift + F3 will change the text in Microsoft Word from upper to lower case or a capital letter at the beginning of every word.
F4
•    Open find window.
•    Repeat the last action performed (Word 2000+)
•    Alt + F4 will close the program currently active in Microsoft Windows.
•    Ctrl + F4 will close the open window within the current active window in Microsoft Windows.
F5
•    In all modern Internet browsers pressing F5 will refresh or reload the page or document window.
•    Open the find, replace, and go to window in Microsoft Word.
•    Starts a slideshow in PowerPoint.
F6
•    Move the cursor to the Address bar in Internet Explorer and Mozilla Firefox.
•    Ctrl + Shift + F6 opens to another open Microsoft Word document.
F7
•    Commonly used to spell check and grammar check a document in Microsoft programs such as Microsoft Word, Outlook, etc.
•    Shift + F7 runs a Thesaurus check on the word highlighted.
•    Turns on Caret browsing in Mozilla Firefox.
F8
•    Function key used to enter the Windows startup menu, commonly used to access Windows Safe Mode.
F9
•    Opens the Measurements toolbar in Quark 5.0.
F10
•    In Microsoft Windows activates the menu bar of an open application.
•    Shift + F10 is the same as right-clicking on a highlighted icon, file, or Internet link.
•    Access the hidden recovery partition on HP and Sony computers.
•    Enter CMOS Setup.
F11
•    Full-screen mode in all modern Internet browsers.
•    Ctrl + F11 as computer is starting to access the hidden recovery partition on many Dell computers.
•    Access the hidden recovery partition on eMachines, Gateway, and Lenovo computers.
F12
•    Open the Save as window in Microsoft Word.
•    Shift + F12 save the Microsoft Word document.
•    Ctrl + Shift + F12 prints a document in Microsoft Word.

Earlier IBM computers also had F13 - F24 on the keyboards. However, because these keyboards are no longer used they are not listed on this page.

Choosing a Better Keyboard

Choosing a Better Keyboard

Every Windows computer comes with a keyboard and either a mouse or some other form of pointing device, such as a touchpad or pointing stick. The keyboard is usually a basic device that fulfills little more than the minimal requirements of having the right number of keys arranged in a conventional fashion and having a suitable connection to the computer, such as a PS/2 plug, a USB plug, or a wireless connection.

If what’s sitting on your desk and keeping your fingertips blunt is a basic keyboard, you’re likely to benefit from an upgrade. This appendix discusses what kinds of keyboards are available and how to choose a suitable keyboard for your needs

Considerations for Choosing a Keyboard

At the risk of generalizing horribly, keyboards fall into three categories: conventional, serious, and specialized (or strange) keyboards. The following sections discuss these categories.

First, though, here are general considerations to keep in mind when choosing a new keyboard:

• You must choose the keyboard yourself, because only you can tell whether it suits you. One person’s dream ergonomic keyboard is another person’s carpal tunnel of horrors.
• Try to type for several minutes on any keyboard you’re considering buying so that you can get a fair idea of its strong points and weak points.
• Generally speaking, the more expensive a keyboard is, the higher its build quality should be. But if all you need is a conventional keyboard, you should be able to find a decent one without spending a lot of money. Besides, expense doesn’t necessarily bear any relation to comfort.
• If you’re likely to spill coffee, soda, or water on your keyboard, or shower it with crumbs, you may prefer to stick with a cheaper keyboard so that it costs less to replace. Alternatively, make sure that a keyboard skin (a cover through which you use the keyboard) is available for the model you plan to buy, or find a company that can manufacture custom skins for any keyboard.
• You don’t need to be suffering from carpal tunnel or RSI syndrome before you start using an ergonomic keyboard, although sadly for many people this is the normal progression. If you spend several hours or more each day typing, seriously consider an ergonomic keyboard. You should also take such steps as possible to reduce the amount of typing you do—for example, by using keyboard shortcuts, macros, and features built into your software (such as AutoCorrect or glossary features).

Here are more specific criteria to ask yourself when you lay hands on the keyboard. They’re largely obvious, but you’ll kick yourself if you skip them.

• Does it have all the keys you want?
• Are the keys arranged where you need them to be?
• Are the keys the right size? Standard key spacing is 19 mm from the middle of one key to the middle of the next key.
• Is the key travel adequate? Key travel of 3 mm is about standard. Many laptop keyboards necessarily have less travel.
• Do you like the “feel” of the keyboard? This is almost entirely subjective: some people like keyboards with a firm feel; others prefer a soft feel; some like a firm response and audible click when a key is pressed, others a subtler response and no audible click.
• Does it have the right type of connector for the computer or computers you want to use it with? These days, most computers use PS/2 connectors—the kind with a small round connector at the end—rather than the 5-pin DIN connector (a larger round connector) used on older keyboards. Some “legacy-lite” or “legacy-free” computers require USB keyboards. You can get various kinds of keyboard connectors if necessary, but they all cost money and clutter your computing area.
• Is the keyboard the color you want? Computer beige is the most widely used color for keyboards, but many black keyboards are available too. Beyond these colors (or noncolors), your choices are limited. The next most popular “color” after beige and black is perhaps aluminum, with several aluminum keyboards available.

All of these issues are easy enough to resolve if you can try the keyboard before you buy it. If you must buy without trying, make sure you can return the keyboard if it doesn’t suit you.

Most large computer stores carry a variety of keyboards and make the most popular (or most promoted) models available for customers to try. While large stores typically have some of the more widely used ergonomic keyboards, if you need a specialized model, you’ll probably do better to visit a specialized computer-ergonomics store.

Keyboard Basics—and How to Enhance Your Keyboard

Understanding the Standard Keys

A standard PC keyboard contains 101 or 104 keys that break down as follows:

• Twenty-six letter keys for the letters a through z.
• A [Spacebar] to put spaces between characters.
• Two sets of keys for the single-digit numbers (0 through 9), one set appearing as a row above the letter keys and one set on the numeric keypad. The row of number keys double as symbol keys, and the numeric keypad keys double as navigation keys.
• Fifteen to 18 keys for mainstream punctuation symbols (for example, comma, period, and semicolon) and other symbols (for example, + and ~). The numeric keypad typically includes symbols used for basic mathematical operations (+ for addition, – for subtraction, / for division, and * for multiplication) and a period for a decimal place.
• A [Tab] key for entering tabs and for navigating from one interface element to another.
• Two [Enter] keys for entering carriage returns and “clicking” the selected button in dialog boxes.
• Two [Shift] keys to change the case of the key pressed, and a [CapsLock] key to lock the letter keys in the capital position.
• Six other modifier keys: two [Ctrl] keys, two [Alt] keys, and two ÿ buttons.
• An [Insert] key for toggling Insert mode.
• A [Delete] key for deleting the selection or the character after the insertion point, and a [Backspace] key for deleting the character before the insertion point.
• Eight or more navigation keys: four arrow keys (←,→,↑, and ↓), a [Home] key for moving to the beginning of an item, an [End] key for moving to the end of an item, a [PageUp] key for moving up by a “page” of information, and a [PageDown] key for moving down by a page.
• Twelve function keys, numbered [F1] to [F12], for invoking functionality built into the operating system and into applications.
• A [ScrollLock] key that toggles the locking on the scrolling function.
• A [NumLock] key for locking on the numeric keypad.
• A [PrintScreen] (or [PrtScr] ) key for capturing what appears on screen.
• A [Pause/Break] key for special functions.
• An [Esc] key for canceling an action or “clicking” the Cancel button in a dialog box.
• A context menu key (or shortcut menu key) for displaying the context menu or shortcut menu.

Take a few Excel Keyboard Shortcuts

Take a few Excel Keyboard Shortcuts

Who doesn't need to save a little time here and there? Keyboard shortcuts can help you do just that. Here's a list of shortcuts for Excel that will make life a little easier:

• [Ctrl][Shift]A: Use this combination after typing a function name, and it will automatically enter the parentheses and the argument names for the function you typed.
• [Alt][F8]: Displays the Macro dialog box.
• [Alt][F11]: Opens the VBA Editor or switches to it if it's already open.
• [Ctrl]1: Displays the Format Cells dialog box.
• [Ctrl][Shift][~]: Applies the General format.
• [Ctrl][Shift][$]: Formats the current cells as Currency.
• [Ctrl][Shift][#]: Applies the Date format.
• [Shift][F10]: Displays the shortcut menu that applies to the selection.
• [F6]: Moves to the next pane in a split worksheet.
• [Shift][F6]: Moves to the previous pane.
• [Ctrl][F6]: Moves to the next workbook window.
• [Ctrl][Shift][F6]: Moves back to the last workbook window.
• [F3]: Opens a dialog box to paste a Named Range into a formula.
• [Ctrl][F3]: Opens the Define Name dialog box.
• [Ctrl][Shift][F3]: Automatically creates Named Ranges from the headers for the selected table of data with row or column headers.
• [Shift][F3]: Inserts an equal sign (=) and opens the Paste Function dialog box to help you pick a formula.
• [Alt][=]: Inserts the AutoSum function.
• [Ctrl][;]: Inserts the current date.

Keyboard Shortcuts Result in Excel 2011

Keyboard Shortcut Keys

F1 Key Help
F2 Key Edit current Cell
F5 Key Goto
F7 Key Spell Check
F12 Key Save file as
CTRL and A Select entire worksheet.
CTRL and B Toggle Bold Text.
CTRL and C Copies the item or items selected to the Clipboard and can be pasted using CTRL and V.
CTRL and F Displays the Find dialog box.
CTRL and H Displays the Replace dialog box.
CTRL and I Toggles Italic Text.
CTRL and N New File.
CTRL and O Open File.
CTRL and P Print.
CTRL and S Save File.
CTRL and U Toggles Underlined Text.
CTRL and V Paste the contents of the clipboard.
CTRL and X Cut the selected item.
CTRL and Y Redo the last undone action
CTRL and Z Undoes the last action.
CTRL and 1 Displays Format Cells Dialogue Box
CTRL and 5 Toggles Strikethrough Text

Keyboard Shortcuts Result in Excel 2011 - Formulas
ALT and = Autosum
ALT and F8 Macros
CTRL and ; Insert Current Date
CTRL and : Insert Current Time

Keyboard Shortcuts Result in Excel 2011 - Movement

Left Arrow One Cell Left (also SHIFT and TAB)
Right Arrow One Cell Right (also TAB)
Up Arrow One Cell Up
Down Arrow One Cell Down
Home Go to End of row
CTRL and left Arrow Go to End of Column
CTRL and Home Go to Top of Worksheet (A1)
CTRL and End Go to End of Worksheet
CTRL and PAGE-DOWN Go to Next Worksheet

Keyboard Shortcuts Result in Excel 2011 - Cell Selection

CTRL and Spacebar Select the entire Column
SHIFT and Spacebar Select the entire Row
CTRL and A Select Entire Worksheet
SHIFT and Left Cursor Select all cells to the left of the active one
SHIFT and Right Cursor Select all cells to the right of the active one

Best Excel Shortcuts

Excel Shortcut Keys

CTRL+(	Unhides any hidden rows within the selection.
CTRL+)	Unhides any hidden columns within the selection.
CTRL+&	Applies the outline border to the selected cells.
CTRL+_	Removes the outline border from the selected cells.
CTRL+~	Applies the General number format.
CTRL+$	Applies the Currency format with two decimal places (negative numbers in parentheses).
CTRL+%	Applies the Percentage format with no decimal places.
CTRL+^	Applies the Exponential number format with two decimal places.
CTRL+#	Applies the Date format with the day, month, and year.
CTRL+@	Applies the Time format with the hour and minute, and AM or PM.
CTRL+!	Applies the Number format with two decimal places, thousands separator, and minus sign (-) for negative values.
CTRL+-	Displays the Delete dialog box to delete the selected cells.
CTRL+*	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+:	Enters the current time.
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+"	Copies the value from the cell above the active cell into the cell or the Formula Bar.
CTRL++	Displays the Insert dialog box to insert blank cells.
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+7	Displays or hides the Standard toolbar.
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 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 Microsoft Office 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 dialog box. SHIFT+F5 also displays this dialog box, while SHIFT+F4 repeats the last Find action.
CTRL+G	Displays the Go To dialog box. F5 also displays this dialog box.
CTRL+H	Displays the Find and Replace dialog box.
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+L	Displays the Create List dialog box.
CTRL+N	Creates a new, blank file.
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+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+U	Applies or removes underlining.
CTRL+V	Inserts the contents of the Clipboard at the insertion point and replaces any selection. Available only after you cut or copied an object, text, or cell contents.
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 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.
F1	Displays the Help task pane. CTRL+F1 closes and reopens the current task pane. 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 edits a cell comment.
F3	Pastes a defined name into a formula. 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 to the next pane in a worksheet that has been split (Window menu, Split command). SHIFT+F6 switches to the previous pane in a worksheet that has been split. CTRL+F6 switches to the next workbook window when more than one workbook window is open. Note  When the task pane is visible, F6 and SHIFT+F6 include that pane when switching between panes.
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 ESC.
F8	Turns extend mode on or off. In extend mode, EXT appears in the status line, and the arrow keys extend the selection. SHIFT+F8 enables you to add a non-adjacent 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 run, edit, or delete a macro.
F9	Calculates all worksheets in all open workbooks. F9 followed by ENTER (or followed by CTRL+SHIFT+ENTER for array formulas) calculates the selected a portion of a formula and replaces the selected portion with the calculated value. 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	Selects the menu bar or closes an open menu and submenu at the same time. 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 Visual Basic Editor, in which you can create a macro by using Visual Basic for Applications (VBA). ALT+SHIFT+F11 opens the Microsoft Script Editor, where you can add text, edit HTML tags, and modify any script code.
F12	Displays the Save As dialog box.
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. LEFT ARROW or RIGHT ARROW selects the menu to the left or right when a menu is visible. When a submenu is open, these arrow keys switch between the main menu and the submenu. DOWN ARROW or UP ARROW selects the next or previous command when a menu or submenu is open. In a dialog box, arrow keys move between options in an open drop-down list, or between options in a group of options. 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.
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. CTRL+SHIFT+END extends the selection of cells to the last used cell on the worksheet (lower-right corner).
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. It also closes an open menu or submenu, dialog box, or message window.
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 entire worksheet.                      When an object is selected, CTRL+SHIFT+SPACEBAR selects all objects on a worksheet. ALT+SPACEBAR displays the Control menu for the 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.