Shortcuts of Excel 2010 (Manage Active Selections - Select inside cells ) Page - 3

Manage Active Selections
F8	Turn on extension of selection with arrow keys without having to keep pressing shift.
Shift+F8	Add another (adjacent or non-adjacent) range of cells to the selection. Use arrow keys and shift+arrow keys to add to selection.
Shift+Backspace	Select only the active cell when multiple cells are selected.
Ctrl+Backspace	Show active cell within selection.
Ctrl+. (period)	Move clockwise to the next corner of the selection.
Enter/Shift+Enter	Move active cell down / up in a selection.
Tab/Shift+Tab	Move active cell right / left in a selection.
Ctrl+Alt+Arrow Right/Ctrl+Alt+Arrow Left	Move to the right / to the left between non-adjacent selections (with multiple ranges selected).
Esc	Cancel Selection.

Select inside cells
Shift+Arrow Left/Shift+Arrow Right	Select or unselect one character to the left / to the right.
Ctrl+Shift+Arrow Left/Ctrl+Shift+Arrow Right	Select or unselect one word to the left / to the right.
Shift+Home/Shift+End	Select from the insertion point to the beginning / to the end of the cell.

Read More

Shortcuts of Excel 2010 (Work with Data Selections) Page-2

Select Cells
Shift+Space	Select the entire row.
Ctrl+Space	Select the entire column.
Ctrl+Shift+* (asterisk)	Select the current region around the active cell.
Ctrl+a (or ctrl+Shift+spacebar)	Select the entire worksheet or the data-containing area. Pressing ctrl+a a second time then selects entire worksheet.
Ctrl+Shift+Page Up	Select the current and previous sheet in a workbook.
Ctrl+Shift+o	Select all cells with comments.
Shift+Arrow Keys	Extend the selection by one cell.
Ctrl+Shift+Arrow Key	Extend the selection to the last cell with content in row or column.
Shift+Page Down/Shift+Page Up	Extend the selection down one screen /up one screen.
Shift+Home	Extend the selection to the beginning of the row.
Ctrl+Shift+Home	Extend the selection to the beginning of the worksheet.
Ctrl+Shift+End	Extend the selection to the last used cell on the worksheet (lower-right corner).

Read More

Windows Run Commands, Shortcut Collections

Windows
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
Odbcad32 - ODBC Data Source Administrator
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

General keyboard shortcuts
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 shortcutsIf 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)

Microsoft natural keyboard shortcuts
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)

Accessibility keyboard shortcuts
Right SHIFT for eight seconds (Switch FilterKeys either on or off)
Left ALT+left SHIFT+PRINT SCREEN (Switch High Contrast either on or off)
Left ALT+left SHIFT+NUM LOCK (Switch the MouseKeys either on or off)
SHIFT five times (Switch the StickyKeys either on or off)
NUM LOCK for five seconds (Switch the ToggleKeys either on or off)
Windows Logo +U (Open Utility Manager)

Windows Explorer keyboard shortcuts
END (Display the bottom of the active window)
HOME (Display the top of the active window)
NUM LOCK+Asterisk sign (*) (Display all of the subfolders that are under the selected folder)
NUM LOCK+Plus sign (+) (Display the contents of the selected folder)
NUM LOCK+Minus sign (-) (Collapse the selected folder)
LEFT ARROW (Collapse the current selection if it is expanded, or select the parent folder)
RIGHT ARROW (Display the current selection if it is collapsed, or select the first subfolder)

Shortcut keys for Character Map
After you double-click a character on the grid of characters, you can move through the grid by using the keyboard shortcuts
RIGHT ARROW (Move to the right or to the beginning of the next line)
LEFT ARROW (Move to the left or to the end of the previous line)
UP ARROW (Move up one row)
DOWN ARROW (Move down one row)
PAGE UP (Move up one screen at a time)
PAGE DOWN (Move down one screen at a time)
HOME (Move to the beginning of the line)
END (Move to the end of the line)
CTRL+HOME (Move to the first character)
CTRL+END (Move to the last character)
SPACEBAR (Switch between Enlarged and Normal mode when a character is selected)

Microsoft Management Console (MMC) main window keyboard shortcuts
CTRL+O (Open a saved console)
CTRL+N (Open a new console)
CTRL+S (Save the open console)
CTRL+M (Add or remove a console item)
CTRL+W (Open a new window)
F5 key (Update the content of all console windows)
ALT+SPACEBAR (Display the MMC window menu)
ALT+F4 (Close the console) • ALT+A (Display the Action menu)
ALT+V (Display the View menu)
ALT+F (Display the File menu)
ALT+O (Display the Favorites menu)

MMC console window keyboard shortcuts
CTRL+P (Print the current page or active pane)
ALT+Minus sign (-) (Display the window menu for the active console window)
SHIFT+F10 (Display the Action shortcut menu for the selected item)
F1 key (Open the Help topic, if any, for the selected item)
F5 key (Update the content of all console windows)
CTRL+F10 (Maximize the active console window)
CTRL+F5 (Restore the active console window)
ALT+ENTER (Display the Properties dialog box, if any, for the selected item)
F2 key (Rename the selected item)
CTRL+F4 (Close the active console window. When a console has only one console window, this shortcut closes the console)

Remote desktop connection navigation
CTRL+ALT+END (Open the Microsoft Windows NT Security dialog box)
ALT+PAGE UP (Switch between programs from left to right)
ALT+PAGE DOWN (Switch between programs from right to left)
ALT+INSERT (Cycle through the programs in most recently used order)
ALT+HOME (Display the Start menu)
CTRL+ALT+BREAK (Switch the client computer between a window and a full screen)
ALT+DELETE (Display the Windows menu)
CTRL+ALT+Minus sign (-) (Place a snapshot of the entire client window area on the Terminal server clipboard and provide the same functionality as pressing ALT+PRINT SCREEN on a local computer.)
CTRL+ALT+Plus sign (+) (Place a snapshot of the active window in the client on the Terminal server clipboard and provide the same functionality as pressing PRINT SCREEN on a local computer.)

Microsoft Internet Explorer navigationCTRL+B (Open the Organize Favorites dialog box)
CTRL+E (Open the Search bar)
CTRL+F (Start the Find utility)
CTRL+H (Open the History bar)
CTRL+I (Open the Favorites bar)
CTRL+L (Open the Open dialog box)
CTRL+N (Start another instance of the browser with the same Web address)
CTRL+O (Open the Open dialog box, the same as CTRL+L)
CTRL+R (Update the current Web page)
CTRL+ CTRL+P (Open the Print dialog box)
W (Close the current window)

Note Some keyboard shortcuts may not work if StickyKeys is turned on in Accessibility Options, Some of the Terminal Services client shortcuts that are similar to the shortcuts in Remote Desktop Sharing are not available when you use Remote Assistance in Windows XP Home Edition.

Microsoft Office run commands
If the Microsoft Office is installed you can use following run commands to run its components.

winword – Microsoft Word
excel – Microsoft Excel
powerpnt – Microsoft PowerPoint
msaccess – Microsoft Access
outlook – Microsoft Outlook
ois – Microsoft Picture Manage

Read More

Google Chrome Shortcut key

Ctrl+N Open a new window
Ctrl+Shift+N Open a new window in incognito mode
Press Ctrl, and click a link Open link in a new tab
Press Shift, and click a link Open link in a new window
Alt+F4 Close current window
Ctrl+T Open a new tab
Ctrl+Shift+T Reopen last tab closed (remembers 10)
Drag link to tab Open link in specified tab
Drag link to space between tabs Open link in a new tab

Ctrl+1 through Ctrl+8 Switch to the tab at the specified position number. The number you press represents a position on the tab strip.
Ctrl+9 Switch to the last tab
Ctrl+Tab or Ctrl+PgDown Switch to the next tab
Ctrl+Shift+Tab or Ctrl+PgUp Switch to the previous tab
Ctrl+W or Ctrl+F4 Close current tab or pop-up
Alt+Home Open your homepage
Ctrl+O, then select file Open a file from your computer

Address bar shortcuts:

Do one of the following actions in the address bar:

Type a search term Perform a search using your default search engine

Type the part of the web address that’s between ‘www.’ and ‘.com’, then press Ctrl+Enter

F6 or Ctrl+L or Alt+D Highlight content in the web address area

Type a web address, then press Alt+Enter Open your web address in a new tab

Shortcuts to open Google Chrome features:
Ctrl+B Toggle bookmarks bar on and off
Ctrl+H View the History page
Ctrl+J View the Downloads page
Shift+Escape View the Task manager

Webpage shortcuts:
Ctrl+P Print your current page
F5 Reload current page
Esc Stop page loading
Ctrl+F5 or Shift+F5 Reload current page, ignoring cached content
Press Alt, and click a link Download link
Ctrl+F Open find-in-page box
Ctrl+G or F3 Find next match for your input in the find-in-page box
Ctrl+Shift+G or Shift+F3 Find previous match for your input in the find-in-page box
Ctrl+U View source
Drag link to bookmarks bar Bookmark the link
Ctrl+D Bookmark your current webpage
Ctrl++ Make text larger
Ctrl+- Make text smaller
Ctrl+0 Return to normal text size

Read More

Shortcuts of Excel 2010 (Navigate Inside Worksheets) Page-1

Arrow Keys	Move one cell up, down, left, or right in a worksheet.
Page Down/Page Up	Move one screen down / one screen up in a worksheet.
Alt+Page Down/Alt+Page Up	Move one screen to the right / to the left in a worksheet.
Tab/Shift+Tab	Move one cell to the right / to the left in a worksheet.
Ctrl+Arrow Keys	Move to the edge of next data region (cells that contains data)
Home	Move to the beginning of a row in a worksheet.
Ctrl+Home	Move to the beginning of a worksheet.
Ctrl+End	Move to the last cell with content on a worksheet.
Ctrl+f	Display the Find and Replace dialog box (with Find selected).
Ctrl+h	Display the Find and Replace dialog box (with Replace selected).
Shift+F4	Repeat last find.
Ctrl+g (or f5)	Display the 'Go To' dialog box.
Ctrl+Arrow Left/Ctrl+Arrow Right	Inside a cell: Move one word to the left / to the right.
Home/End	Inside a cell: Move to the beginning / to the end of a cell entry.
Alt+Arrow Down	Display the AutoComplete list e.g. in cell with dropdowns or autofilter.
End	Turn 'End' mode on. In End mode, press arrow keys to move to the next nonblank cell in the same column or row as the active cell. From here use arrow keys to move by blocks of data, home to move to last cell, or enter to move to the last cell to the right.

Read More