Microsoft Excel Shortcut Keys
1. F2 Edit the selected cell
2. F3 After a name has been created F3 will paste names
3. F5 Go to a specific cell. For example, C6
4. F7 Spell check selected text or document
5. F11 Create chart from selected data
6. Ctrl + Shift + ; Enter the current time
7. Ctrl + ; Enter the current date
8. Alt + Shift + F1 Insert new worksheet
9. Shift + F3 Open the Excel formula window
10. Shift + F5 Bring up search box
11. Ctrl + A Select all contents of the worksheet
12. Ctrl + B Bold highlighted section
13. Ctrl + I Italic highlighted section
14. Ctrl + K Insert link
15. Ctrl + U Underline highlighted section
16. Ctrl + 1 Change the format of selected cells
17. Ctrl + 5 Strike through highlighted section
18. Ctrl + P Bring up the print dialogue box to begin printing
19. Ctrl + Z Undo last action
20. Ctrl + F3 Open Excel Name Manager
21. Ctrl + F9 Minimize current window
22. Ctrl + F10 Maximize currently selected window
23. Ctrl + F6 Switch between open work books or windows
24. Ctrl + Page up Move between Excel work sheets in the same Excel document
25. Ctrl + page down Move between Excel worksheets in the same Excel document
26. Ctrl + Tab Move between two or more open Excel document
27. Alt + = Create a formula to sum all of the above cells
28. Ctrl + ’ Insert the value of the above cell into cell currently selected
29. Ctrl + Shift + ! Format number in comma format
30. Ctrl + Shift + $ Format number in currency format
31. Ctrl + Shift + # Format number in date format
32. Ctrl + Shift + % Format number in percentage format
33. Ctrl + Shift + ^ Format number in scientific format
34. Ctrl + Shift + @ Format number in time format
35. Ctrl + Arrow key Move to the next selection on text
36. Ctrl + Space Select entire column
37. Shift + Space Select entire row
38. Ctrl + - Delete the selected column or row
39. Ctrl + shift + = Insert a new column or row
40. Ctrl + Home Move to cell A1
41. Ctrl + ~ Switch between showing Excel formulas or their values in cells..!!
Interesting Facebook shortcuts Trick Free
New message = Alt+m
Home page = Alt+1
Profile page = Alt + 2
Friends list management = Alt + 3
All the message list = Alt + 4
List of notification = Alt + 5
Account setting page = Alt + 6
Privacy setting page = Alt + 7
Visit Facebook Fan page = Alt + 8
Facebook Policy Page = Alt+ 9
New message = shift+Alt+m
Home page = shift+Alt+1
Profile page = shift+Alt + 2
Friends list management = shift+Alt + 3
All the message list = shift+Alt + 4
List of notification = shift+Alt + 5
Account setting page = shift+Alt + 6
Privacy setting page = shift+Alt + 7
Visit Facebook Fan page = shift+Alt + 8
Facebook Policy Page = shift+Alt+ 9
Note:You must be logged in Facebook and stay in the Facebook tab of your browser to use the shortcuts. Cool! isn't it? Just go to your Facebook account and give a try! I like the "New message" shortcut most.
Windows8/8.1 Shortcut Keys
Windows Key : Open the Start Screen
Win + Z : Open Application bar
Win + W : Search in Settings of the system
Win + X : Open Windows Mobility Center
Win + V : Switch among notifications
Win + Shift + V : Switch among notifications (in reverse manner)
Win + U : Open Ease of Access Center
Win + T : Set focus to Taskbar and toggle through Programs
Win + S : Open OneNote Screenshot Creator (If Microsoft Office-OneNote is installed)
Win + R : Open Run dialog box
Win + Q : Open Windows Apps Search
Win + P : Display Projection Options
Win + O : Disable screen rotation / orientation
Win + N : Create new OneNote (If Microsoft Office-OneNote is installed)
Win + M : Minimize all windows
Win + Shift + M : Restore minimized windows
Win + L : Lock your computer
Win + K : Open Device Connections
Win + J : Toggle foreground between the filled and snapped applications
Win + I : Open Settings Panel (To change Settings for the Wireless Networks, Volume, Apps, Brightness or to Shut Down)
Win + H : Open Share Panel
Win + G : Toggle through Windows Desktop Gadgets
Win + F : Search for the Files in Computer
Win + Ctrl + F : Search for Computers in a network
Win + E : Show Windows Explorer with File’s Tree View
Win + D : Toggle “Show Desktop”
Win + C : Open Charms bar
Win + B : Set focus to Notification Area
Win + Enter : Open Windows Narrator
Win + Alt + Enter : Open Media Center (If Media Center is Installed on PC)
Win + Spacebar : Change the Keyboard Layout / Input Language
Win + PageUp : Move Start Screen to the left side of screen
Win + PageDown : Move Start Screen to the right side of screen
Win + Plus : Magnifier Zoom-In
Win + Minus : Magnifier Zoom-Out
Win + Esc : Close Magnifier
Win + Left Arrow : Dock the current window to left half of the screen
Win + Right Arrow : Dock the current window to right half of the screen
Win + Up Arrow : Maximize the currently active window
Win + Down Arrow : Minimize / Restore the currently active window
Win + Shift + Up Arrow : Maximize the currently active window vertically, while maintaining its width
Win + Shift + Down Arrow : Minimize / Restore the currently active window vertically, while maintaining its width
Win + Shift + Left Arrow : Move the currently active window to the left side of monitor
Win + Shift + Right Arrow : Move the currently active window to the right side of monitor
Win + Home : Toggle (Minimize/Maximize) all non-active windows
Windows + number : Launch the program from taskbar sequence (e.g. To open 1st program window, use Windows + 1)
Windows + Shift + number : Launch a new instance of the currently active program from taskbar sequence (e.g. To open an instance of 1st program window, use Windows + Shift + 1)
Win + Break : Display System Properties dialog box
Win + F1 : Open Windows Help and Support
Win + Forward Slash (/) : Initiate IME (Input Method Editor) reconversion
Win + Tab : Toggle through all Applications
Win + Ctrl + Tab : Toggle through Applications and snap them as they cycle
Win + Shift + Tab : Toggle through Applications in reverse order
Win + Dot (.) : Move the gutter to the right
Win + Shift + Dot (.) : Move the gutter to the left
Win + Comma (,) : Look Temporarily at the desktop
Shortcuts starting with Alt Key :
Alt + W : Create a new document or select a template
Alt + V : Paste
Alt + T : Cut
Alt + S + N : Deselect
Alt + S + I : Invert the selection
Alt + S + A : Select all
Alt + R : Rename selected files
Alt + P + S : Insert label
Alt + P + R : Open properties
Alt + P + E : Display “Open With…” dialog box
Alt + N : Create a new folder
Alt + M : Move the files
Alt + H : Show the history of file versions
Alt + E : Edit selected files
Alt + D : Delete selected files or folder
Alt + C + P : Copy path to the file or folder
Alt + C + O : Copy selected items
Alt + A : Open the “special features”
0 comments:
Post a Comment