 |
| Keyboard shortcuts for excel |
You can use this keyboard shortcut to work faster in Microsoft Office, many of these keyboard shortcuts work in Word, Excel and Power point three.
Short Keyboard for Microsoft Word
- Ctrl + A - to select the entire page at once
- Ctrl + B - to bold text
- Ctrl + C - to copy text
- Ctrl + D - To change the default font settings
- Ctrl + E - to center the text
- Ctrl + F - to find
- Ctrl + G - to access a page or line directly
- Ctrl + H - to replace a word
- Ctrl + I - to italicize text
- Ctrl + J - to justify the paragraph
- Ctrl + K - to place hyperlink on page
- Ctrl + L - To left align text
- Ctrl + M - to increase indent
- Ctrl + N - Create a new file
- Ctrl + O - to open the file
- Ctrl + P - to remove print
- Ctrl + Q - to end the indent
- Ctrl + R - to write align text
- Ctrl + S - to save the file
- Ctrl + T - to increase the handling indent on the page
- Ctrl + U - For Underline
- Ctrl + V - Pastes the copied text
- Ctrl + W - to close the file
- Ctrl + X - to cut the text
- Ctrl + Z - To Undo
- Ctrl +] - to increase font size
- Ctrl + [ - to reduce font size
Windows Shortcut Keys
- Windows Key + R - To opens the run file.
- Windows Key + E - To opens Explorer.
- Alt + Tab - Switch between open programs.
- Windows Key + Up Arrow - To Maximize current window.
- Ctrl + Shift + Esc - To open Task Manager file.
- Windows Key + Break - Opens system properties.
- Windows Key + F - To opens search files and folders.
- Windows Key + D - Hide/display the desktop .
- Alt + Esc - Switch between programs in order they were opened.
- Alt + Letter - Select menu item by underlined letter.
- Ctrl + Esc - Open Start menu.
- Ctrl + F4 - Close active document
- Alt + F4 - Quit active application or close current window.
- Alt + Spacebar - Open menu for active program.
- Ctrl + Left or Right Arrow - Move cursor forward or back one word.
- Ctrl + Up or Down Arrow - Move cursor forward or back one paragraph.
- F1 - Open Help menu for active application.
- Windows Key + M - Minimize all windows.
- Shift + Windows Key + M - Restore windows that were minimized with previous keystroke.
- Windows + F1 - Open Windows Help and Support.
- Windows + Tab - Open Task view.
- Windows + Break - Open the System Properties dialog box.
- Hold Right SHIFT key for eight seconds - Switch Filter Keys on and off.
- Left Alt + Left Shift + Print Screen - Switch High Contrast on and off.
- Left Alt + Left Shift + Num Lock - Switch Mouse keys on and off.
- Press Shift five times - Switch Sticky keys on and off.
- Hold Num Lock for five seconds - Switch Toggle keys on and off.
Excel Short Keyboard
- F2 - Edit the active cell.
- F5 - Displays the Go To box.
- F7 - Open the Spelling dialogue box to check a selected range.
- F11 - Create a chart of data in the current range in a separate sheet.
- Alt + Shift + F1 - Insert a new worksheet.
- Shift + F3 - Opens Insert Function dialogue box.
- Shift + F5 - Opens the Find and Replace dialogue box.
- Ctrl + Shift + Colon (:) - Enter the current time.
- Ctrl + Semicolon (;) - Enter the current date.
- Ctrl + A - Select all content in the worksheet.
- Ctrl + B - Bold highlighted selection.
- Ctrl + I - Italicize highlighted selection.
- Ctrl + K - Open the Insert hyperlink dialogue box.
- Ctrl + U - Underline highlighted selection.
- Ctrl + 5 - Apply strikethrough formatting.
- Ctrl + P - Brings up the print dialog box.
- Ctrl + Z - Undo.
- Ctrl + F9 - Minimize a workbook window to an icon.
- Ctrl + F10 - Maximize a selected workbook window.
- Ctrl + F6 - Switch to the next workbook window when multiple are open.
- Ctrl + Page Up - Move to previous sheet in a workbook.
- Ctrl + Page Down - Move to next sheet in a workbook.
- Ctrl + Tab - Switch to next tab in dialogue box.
- Ctrl + Apostrophe (') - Insert the value of the above cell into the cell currently selected.
- Ctrl + Shift + ! - Apply the Number format.
- Ctrl + Shift + $ - Apply the Currency format.
- Ctrl + Shift + # - Apply the Date format.
- Ctrl + Shift + % - Apply the Percentage format.
- Ctrl + Shift + ^ - Apply the Exponential format.
- Ctrl + Shift + @ - Apply the Time format.
- Ctrl + Arrow Key - Move to the edge of the current data region in a worksheet.
- Ctrl + Space - Select an entire column in a worksheet.
- Shift + Space - Select an entire row in a worksheet.
No comments:
Post a Comment