Thursday, July 26, 2012

Sunday, July 22, 2012

Windows 7 SHORTCUT KEY

 On 


Windows 7 productivity
Win + UP Arrow Maximize the current window
Win + Down Arrow Restore down or minimize current windows
Win + Left Arrow Dock the current window to the left half of the screen
Win + Right Arrrow Dock the current window to the right half of the
screen
Win + [number] Activate and run the program pinned on Windows 7
Taskbar, running program won’t be affected
Win + Home Minimize all but the current window
Win + Space Makes all windows transparent so you can see
through to the desktop
Win + Pause/Break Open System Properties
Win + Tab Flip Aero 3D [press Tab to cycle between Windows]
Win + B Move focus to notification tray (the right-most
portion of the taskbar)
Win + D Show/Hide desktop
Win + E Windows Explorer is launched
Win + F Search
Win + G Bring all gadgets on top and foreground
Win + L Lock Computer
Win + M Minimize all windows
Win + P Open the projection menu (generally used for
laptops connected to projectors)
Win + R Run Command is launched.
Win + S OneNote Screen Clipping Tool
Win + T Show preview thumbnail of running applications in
Windows Taskbar one by one without mouse over
Win + X Mobility Center
Win + # Quicklaunch
Win + = Magnifier
Win + [+/-] Enables the magnifier and zooms in/out
Win + Shift + Up Arrow Maximize vertical size
Win + Shift + Down Arrow Restore vertical size
Win + Shift + Left Arrow Jump to left monitor
Win + Shift + Right Arrow Jump to right monitor
Win + Shift + M Undo all window minimization
Win + Shift + T Cycles backwards
Win + Ctrl + F Opens the Active Directory Find Computers dialog
Ctrl + Right Arrow Move the cursor to the beginning of the next word
Ctrl + Left Arrow Move the cursor to the beginning of the previous
word
Ctrl + Up Arrow Move the cursor to the beginning of the previous
paragraph
Ctrl + Down Arrow Move the cursor to the beginning of the next
paragraph
Ctrl + Click A pinned taskbar icon to cycle through the program’s
open windows (e.g. IE)
Ctrl + Win + Tab Persistent flip 3D
Ctrl + Shift with an arrow key Select a block of text
Ctrl + any arrow key + Spacebar Select multiple individual items in a window or on
the desktop
Ctrl + Shift + Esc Open Task Manager directly
Ctrl + Shift + N Create new folder
Voor Ease of Access
Right SHIFT for eight seconds Turn Filter Keys on and off
Left ALT+left SHIFT+PRINT SCREEN
(or PRTSCRN) Turn High Contrast on or off
Left ALT+left SHIFT+NUM LOCK Turn Mouse Keys on or off
SHIFT five times Turn Sticky Keys on or off
NUM LOCK for five seconds Open the Ease of Access Center
Win + U Cycle through all open windows
Voor Windows Explorer
Alt + Left Arrow Go back
Alt + Right Arrow Go forward
Alt + Up Arrow Go up a directory
Alt + Enter Open the Properties window of the current selection
Alt + Spacebar Open the shortcut menu for the active window
Alt + F4 Close the active window
Alt + Tab Switch to previous active window
Alt + Esc Cycle through all open windows
Alt + D Move focus to address bar
Alt + P Show/hide the preview panel
Ctrl + N Open a new window
Ctrl + Mousewheel Change the view type (extra large, small, list view,
detail, etc.)
Num Lock + Asterisk (*)
on numeric keypad Display all subfolders under the selected folder
Num Lock + Plus Sign (+)
on numeric keypad Display the contents of the selected folder
Num Lock + Minus Sign (+)
on numeric keypad Collapse the selected folder
Voor de taskbar
Shift + Click on icon Open a new instance
Middle click on icon Open a new instance
Ctrl + Shift + Click on icon Open a new instance with Admin privileges
Voor dialog boxes
Ctrl + Tab Move forward through tabs
Ctrl + Shift + Tab Move back through tabs
Shift + Tab Move back through options
Tab Move forward through options
Alt + underlined letter Perform the command (or select the option) that
goes with that letter
Enter Replaces clicking the mouse for many selected
commands
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
Backspace Open a folder one level up if a folder is selected in the
Save As or Open dialog box
Voor de fotogalerij
Ctrl + F Open the Fix pane
Ctrl + P Print the selected picture
Ctrl + I Open or close the Details pane
Ctrl + Period (.) Rotate the picture clockwise
Ctrl + Comma (,) Rotate the picture counter-clockwise
Ctrl + Mouse scroll wheel Change the size of the picture thumbnail
Ctrl + B Best fit
Ctrl + E Search for an item
Alt + Left Arrow Go back
Alt + Right Arrow Go forward
Plus Sign (+) Zoom in or resize the picture thumbnail
Minus Sign (-) Zoom out or resize the picture thumbnail
Shift + Delete Permanently delete the selected item
Enter View the selected picture at a larger size
Voor aan- en afmelden in Windows 7
Win + Right Arrow + Enter Shutdown
Win + Right Arrow + Right Arrow + R Restart
Win + Right Arrow + Right Arrow + S Sleep
Win + Right Arrow + Right Arrow + W Switch users

EXCEL SHORTCUT KEY

 On 


CTRL Shortcuts
CTRL + A Select All
CTRL + B Bold
CTRL + C Copy
CTRL + C, ALT E+S Paste Special
CTRL + D Fill Down
CTRL + F Find
CTRL + G Go to
CTRL + H Replace
CTRL + I Italic
CTRL + K Insert Hyperlink
CTRL + N New Workbook
CTRL + O Open File
CTRL + P Print
CTRL + R Fill right
CTRL + S Save workbook
CTRL + U Underline
CTRL + V Paste
CTRL + W Close window
CTRL + X Cut
CTRL + Y Repeat
CTRL + Z Undo
CTRL + 1 Format Box
CTRL + 5 Strike-through
CTRL + 7 Hide/show toolbar
CTRL + 9 Hide row
SHIFT + CTRL + 9 Unhide row
CTRL + 0 Hide column
SHIFT + CTRL + 0 Unhide column
CTRL + ~ Show formulas/values
CTRL + ‘ Copy above formula
CTRL + ; Display date
SHIFT + CTRL + : Display time
CTRL + [ Precedents
CTRL + ] Dependents
CTRL + Enter Fill selection w/ entry
Formatting Shortcuts
ALT + ‘ Display style
CTRL + 1 Format Box
SHIFT + CTRL + ~ General format
SHIFT + CTRL + ! Number format
SHIFT + CTRL + @ Time format
SHIFT + CTRL + # Date format
SHIFT + CTRL + $ Currency format
SHIFT + CTRL + % Percentage format
SHIFT + CTRL + ^ Exponential format
SHIFT + CTRL + & Outline border
SHIFT + CTRL + _ Remove border
SHIFT + CTRL + * Select region
Tools > Customize > Options Show full menus
Navigation and Data Editing
Arrow keys Move to new cells
ALT + Display a drop-down list
ALT + Tab Switch programs
CTRL + Pg Up/Down Switch worksheets
CTRL + Tab Switch workbooks
CTRL + Arrow keys Go to end of contiguous range
SHIFT + Arrow keys Select a cell range
SHIFT + CTRL + Arrow keys Highlight contiguous range
Home Move to beginning of row
CTRL + Home Move to cell “A1”
F5 “Go to”
ENTER Move to cell below
SHIFT + ENTER Move to cell above
TAB Move to cell to the right
SHIFT + TAB Move to cell to the left
BACKSPACE Delete cell and get inside
DELETE Delete cell/selection
F2 Edit/ highlight dependent cells
When inside cell…
ALT + ENTER Start new line in same cell
SHIFT + Arrow keys Highlight within cells
SHIFT + CTRL + Arrow keys Highlight contiguous items
BACKSPACE Delete preceding character
DELETE Delete character to the right
F4 Anchor “Fix” Cells
ESC Cancel a cell entry
F7 Spell check
SHIFT + F2 Insert a comment
CTRL + F3 Name a cell
ALT Shortcuts
ALT + Tab Switch program
ALT + ‘ Display style
ALT + T + O Options Menu
ALT + T + I Add-Ins Menu
ALT + E + S Paste special box
ALT + E + S + T Paste format only
ALT + W + S (Un)split panes
ALT + W + F (Un)freeze windows
ALT + E + M Move/ Copy a sheet
ALT + E + L Delete worksheet
ALT + V + Z Change view sizing
ALT + O + C + A Fit column width
ALT + O + H + R Change tab name
ALT + E + A Clears cell
ALT + F + V Print preview
ALT + F4 Close program
ALT + F8 Macro box
ALT + F11 Visual basic editor
Columns and Rows
SHIFT + Spacebar Highlight row
CTRL + Spacebar Highlight column
SHIFT + ALT + Group rows/columns
SHIFT + ALT + Ungroup rows/columns
CTRL + Minus sign Delete selected cells
SHIFT + CTRL + Plus Sign Insert blank cells
Formulas and Auditing
= (equals sign) Start a formula
SHIFT + F3 Display “Insert Function” box
ALT + “=“ Insert AutoSum formula
CTRL + ‘ (apostrophe) Copy formula from above cell
SHIFT + CTRL + “ (quote) Copy value from above cell
CTRL + ~ Show formulas/values
F9 Recalculate all workbooks
Auditing formulas…
ALT + T + U + T Trace immediate precedents
ALT + T + U + D Trace immediate dependents
ALT + T + U + A Remove tracing arrows
CTRL + [ Go to precedent cells
CTRL + ] Go to dependent cells
SHIFT + CTRL + { Trace all precedents (indirect)
SHIFT + CTRL + } Trace all dependents (indirect)
F5 + Enter Go back to original cell
Function Key Shortcuts
F1 Excel Help Menu
F2 Edit cells
F3 Paste Name
F4 Repeat or anchor cells
F5 “Go to”
F6 Next pane in split mode
F7 Spell check
F8 Anchor to highlight
F9 Recalculate workbooks
F10 Activate menu bar
F11 New chart
F12 Save as
SHIFT + F2 Insert a comment
SHIFT + F3 “Insert Function” Box
SHIFT + F4 Find Next
SHIFT + F5 Find
SHIFT + F6 Previous pane
SHIFT + F8 Add to selection
SHIFT + F9 Calculate active sheet
SHIFT + F10 Display shortcut menu
SHIFT + F11 New worksheet
CTRL + F3 Name a cell
CTRL + F4 Close window
CTRL + F9 Minimize workbook
CTRL + F10 Maximize window
CTRL + F12 Open File
Windows Flag + D Minimize program
Windows Flag + E Windows explorer
Subscribe to: Posts (Atom)