tag: computer shortcut keys for patwari, mp patwari computer pdfs, mp patwari shortcut keys, mp patwari ms word, mp patwari excel.
Microsoft Excel Short Keys
General
| Description |
Shortcut Key |
| New file |
Ctrl + N |
| Open file |
Ctrl + O |
| Save file |
Ctrl + S |
| Move between open workbooks |
Ctrl + F6 |
| Close file |
Ctrl + F4 |
| Save as |
F12 |
| Display the print menu |
Ctrl + P |
| Select whole spreadsheet |
Ctrl + A |
| Select column |
Ctrl + Space |
| Select row |
Shift + Space |
| Undo last action |
Ctrl + Z |
| Redo last action |
Ctrl + Y |
| Start a formula |
Equals Sign (eg. SUM(A1+A2) |
| Exit Excel 97 |
Alt + F4 |
| Description |
Shortcut Key |
| Move to next cell in row |
Tab |
| Move to previous cell in row |
Shift + Tab |
| Up one screen |
Page Up |
| Down one screen |
Page Down |
| Move to next worksheet |
Ctrl + Page Down |
| Move to previous worksheet |
Ctrl + Page Up |
| Go to first cell in data region |
Ctrl + Home |
| Go to last cell in data region |
Ctrl + End |
Formatting Text In Worksheet
| Description |
Shortcut Key |
| Bold toggle for selection |
Ctrl + B |
| Italic toggle for selection |
Ctrl + I |
| Underline toggle for selection |
Ctrl + U |
| Strikethrough for selection |
Ctrl + 5 |
| Change the font |
Ctrl + Shift + F |
| Change the font size |
Ctrl + Shift + P |
| Apply outline borders |
Ctrl + Shift + 7 |
| Remove all borders |
Ctrl + Shift + Underline |
| Wrap text in same cell |
Alt + Enter |
Formatting Cells
| Description |
Shortcut Key |
| Format cells |
Ctrl + 1 |
| Select font |
Ctrl + Shift + F |
| Select point size |
Ctrl + Shift + P |
| Format as currency |
Ctrl + Shift + 4 |
| Format as general (to remove any formatting) |
Ctrl + Shift + # (hash sign) |
| Format as percentage |
Ctrl + Shift + 5 |
| Format as number |
Ctrl + Shift + 1 |
Editing/Deleting Text
| Description |
Shortcut Key |
| Delete one character to right |
Delete |
| Delete one character to left |
Backspace |
| Edit active cell |
F2 |
| Cancel cell entry |
Escape Key |
Highlighting Cells
| Description |
Shortcut Key |
| Select entire worksheet |
Ctrl + A |
| Select entire row |
Shift + Spacebar |
| Select entire column |
Ctrl + Spacebar |
| Manual select |
Hold Shift + with Left, Right, Up, Down Arrow Key |
Copying and Moving Text
| Description |
Shortcut Key |
| Cut |
Ctrl + X |
| Copy |
Ctrl + C |
| Paste |
Ctrl + V |
Inserting Text Automatically
| Description |
Shortcut Key |
| Autosum a range of cells |
Alt + Equals Sign |
| Insert the date |
Ctrl + ; (semi-colon) |
| Insert the time |
Ctrl + Shift + ; (semi-colon) |
| Insert columns/rows |
Ctrl + Shift + + (plus sign) |
| Insert a new worksheet |
Shift + F11 |
Misc
| Description |
Shortcut Key |
| Find text |
Ctrl + F |
| Replace text dialog |
Ctrl + H |
| Create a chart automatically on new sheet |
F11 |
| Edit a cell comment |
Shift + F2 |
Main Jaws Keystrokes In Excel
| Description |
Shortcut Key |
| Say Version of Excel |
Ctrl + Shift + V |
| Move to Next Sheet |
Ctrl + Page Down |
| Move to Prior Sheet |
Ctrl + Page Up |
| Go to a cell command |
Ctrl + G |
| Collapse Selection To Active Cell |
Shift + Backspace |
| Say Active Cell Coordinates |
Insert + C |
| AutoSum |
Alt + Equals |
| Formula Mode |
Equals Sign |
| Insert Date In Current Cell |
Ctrl + ; (semicolon) |
| Insert Time In Current Cell |
Ctrl + Shift + ; (semicolon) |
| Current Column First Cell From Top |
Alt + 1 |
| Current Column Second Cell From Top |
Alt + 2 |
| Current Column Third Cell From Top |
Alt + 3 |
| Current Column Fourth Cell From Top |
Alt + 4 |
| Data Region Left |
Ctrl + Left Arrow |
| Data Region Right |
Ctrl + Right Arrow |
| Data Region Down |
Ctrl + Down Arrow |
| Data Region Up |
Ctrl + Up Arrow |
| Select Whole Data Region |
Ctrl + Shift + 8 |
| Say Formula |
Ctrl + F2 |
| Spell Check |
F7 |
| Report Gridline Status |
Alt + Shift + g |
| Read Row Total |
Insert + Delete |
| Read Column Total |
Insert + Enter |
| Say Column Title |
Alt + Shift + C |
| Say Row Title |
Alt + Shift + R |
| Say Visible Range Coordinates |
Alt + Shift + V |
| Cycle Through Controls in Dialog Box |
Tab |
| Tab Backwards |
Shift + Tab |
| List Cells With Comments |
Ctrl + Shift + ‘ (apostrophe) |
| Row Second Cell From Left |
Alt + Ctrl + 2 |
| Row First Cell From Left |
Alt + Ctrl + 1 |
| Row Third Cell From Left |
Alt + Ctrl + 3 |
| Row Fourth Cell From Left |
Alt + Ctrl + 4 |
| Describe Cell Border |
Alt + Shift + B |
| Read Cell Comment |
Alt + Shift + ‘ (apostrophe) |
| Auto Filter |
Ctrl + Shift + A |
| Read Cell Hyperlink |
Alt + Shift + H |
| Close Office Assistant |
Ctrl + Insert + F4 |
| Set Monitor Cell One |
Alt + Ctrl + Shift + 1 |
| Set Monitor Cell Two |
Alt + Ctrl + Shift + 2 |
| Set Monitor Cell Three |
Alt + Ctrl + Shift + 3 |
| Set Monitor Cell Four |
Alt + Ctrl + Shift + 4 |
| Set Monitor Cell Five |
Alt + Ctrl + Shift + 5 |
| Set Monitor Cell Six |
Alt + Ctrl + Shift + 6 |
| Set Monitor Cell Seven |
Alt + Ctrl + Shift + 7 |
| Set Monitor Cell Eight |
Alt + Ctrl + Shift + 8 |
| Set Monitor Cell Nine |
Alt + Ctrl + Shift + 9 |
| Set Monitor Cell 10 |
Alt + Ctrl + Shift + 0 |
| Read Monitor Cell One |
Alt + Shift + 1 |
| Read Monitor Cell Two |
Alt + Shift + 2 |
| Read Monitor Cell Three |
Alt + Shift + 3 |
| Read Monitor Cell Four |
Alt + Shift + 4 |
| Read Monitor Cell Five |
Alt + Shift + 5 |
| Read Monitor Cell Six |
Alt + Shift + 6 |
| Read Monitor Cell Seven |
Alt + Shift + 7 |
| Read Monitor Cell Eight |
Alt + Shift + 8 |
| Read Monitor Cell Nine |
Alt + Shift + 9 |
| Read Monitor Cell Ten |
Alt + Shift + 0 |
| List Visible Cells With Data |
Ctrl + Shift + D |
| Lists Data In Current Column |
Ctrl + Shift + C |
| List Data In Current Row |
Ctrl + Shift + R |
| Select Hyperlink |
Ctrl + Shift + H |
| Move To Worksheet Listbox |
Ctrl + Shift + S |
| Move To Monitor Cell |
Ctrl + Shift + M |
| Select Worksheet Objects |
Ctrl + Shift + O |
| List Cells At Page Breaks |
Ctrl + Shift + B |
| Options Listbox |
Insert + V |
Microsoft Word Short Keys
Display and use windows
| To do this |
Press |
| Switch to the next window. |
ALT+TAB |
| Switch to the previous window. |
ALT+SHIFT+TAB |
| Close the active window. |
CTRL+W or CTRL+F4 |
| Restore the size of the active window after you maximize it. |
ALT+F5 |
| Move to a task pane from another pane in the program window (clockwise direction). You may need to press F6 more than once. |
F6 |
| Move to a task pane from another pane in the program window (counterclockwise direction). |
SHIFT+F6 |
| When more than one window is open, switch to the next window. |
CTRL+F6 |
| Switch to the previous window. |
CTRL+SHIFT+F6 |
| Maximize or restore a selected window. |
CTRL+F10 |
| Copy a picture of the screen to the Clipboard. |
PRINT SCREEN |
| Copy a picture of the selected window to the Clipboard. |
ALT+PRINT SCREEN |
Use dialog boxes
| To do this |
Press |
| Move from an open dialog box back to the document, for dialog boxes such as Find and Replace that support this behavior. |
ALT+F6 |
| Move to the next option or option group. |
TAB |
| Move to the previous option or option group. |
SHIFT+TAB |
| Switch to the next tab in a dialog box. |
CTRL+TAB |
| Switch to the previous tab in a dialog box. |
CTRL+SHIFT+TAB |
| Move between options in an open drop-down list, or between options in a group of options. |
Arrow keys |
| Perform the action assigned to the selected button; select or clear the selected check box. |
SPACEBAR |
| Select an option; select or clear a check box. |
ALT+ the letter underlined in an option |
| Open a selected drop-down list. |
ALT+DOWN ARROW |
| Select an option from a drop-down list. |
First letter of an option in a drop-down list |
| Close a selected drop-down list; cancel a command and close a dialog box. |
ESC |
| Run the selected command. |
ENTER |
Use edit boxes within dialog boxes
An edit box is a blank in which you type or paste an entry, such as your user name or the path to a folder.
| To do this |
Press |
| Move to the beginning of the entry. |
HOME |
| Move to the end of the entry. |
END |
| Move one character to the left or right. |
LEFT ARROW or RIGHT ARROW |
| Move one word to the left. |
CTRL+LEFT ARROW |
| Move one word to the right. |
CTRL+RIGHT ARROW |
| Select or unselect one character to the left. |
SHIFT+LEFT ARROW |
| Select or unselect one character to the right. |
SHIFT+RIGHT ARROW |
| Select or unselect one word to the left. |
CTRL+SHIFT+LEFT ARROW |
| Select or unselect one word to the right. |
CTRL+SHIFT+RIGHT ARROW |
| Select from the insertion point to the beginning of the entry. |
SHIFT+HOME |
| Select from the insertion point to the end of the entry. |
SHIFT+END |
Use the Open and Save As dialog boxes
| To do this |
Press |
| Display the Open dialog box. |
CTRL+F12 or CTRL+O |
| Display the Save As dialog box. |
F12 |
| Go to the previous folder. |
ALT+1 |
| Up One Level button: Open the folder one level above the open folder. |
ALT+2 |
| Delete button: Delete the selected folder or file. |
DELETE |
| Create New Folder button: Create a new folder. |
ALT+4 |
| Views button: Switch among available folder views. |
ALT+5 |
| Display a shortcut menu for a selected item such as a folder or file. |
SHIFT+F10 |
| Move between options or areas in the dialog box. |
TAB |
| Open the Look in list. |
F4 or ALT+I |
| Update the file list. |
F5 |
Undo and redo actions
| To do this |
Press |
| Cancel an action. |
ESC |
| Undo an action. |
CTRL+Z |
| Redo or repeat an action. |
CTRL+Y |
Access and use task panes and galleries
| To do this |
Press |
| Move to a task pane from another pane in the program window. (You may need to press F6 more than once.) |
F6 |
| When a menu is active, move to a task pane. (You may need to press CTRL+TAB more than once.) |
CTRL+TAB |
| When a task pane is active, select the next or previous option in the task pane. |
TAB or SHIFT+TAB |
| Display the full set of commands on the task pane menu. |
CTRL+SPACEBAR |
| Perform the action assigned to the selected button. |
SPACEBAR or ENTER |
| Open a drop-down menu for the selected gallery item. |
SHIFT+F10 |
| Select the first or last item in a gallery. |
HOME or END |
| Scroll up or down in the selected gallery list. |
PAGE UP or PAGE DOWN |
Close a task pane
- Press F6 to move to the task pane, if necessary.
- Press CTRL+SPACEBAR.
- Use the arrow keys to select Close, and then press ENTER.
Move a task pane
- Press F6 to move to the task pane, if necessary.
- Press CTRL+SPACEBAR.
- Use the arrow keys to select Move, and then press ENTER.
- Use the arrow keys to move the task pane, and then press ENTER.
Resize a task pane
- Press F6 to move to the task pane, if necessary.
- Press CTRL+SPACEBAR.
- Use the arrow keys to select Size, and then press ENTER.
- Use the arrow keys to resize the task pane, and then press ENTER.
Access and use smart tags
| To do this |
Press |
| Display the shortcut menu for the selected item. |
SHIFT+F10 |
| Display the menu or message for a smart tag or for the AutoCorrect Options button or the Paste options button. If more than one smart tag is present, switch to the next smart tag and display its menu or message. |
ALT+SHIFT+F10 |
| Select the next item on a smart tag menu. |
DOWN ARROW |
| Select the previous item on a smart tag menu. |
UP ARROW |
| Perform the action for the selected item on a smart tag menu. |
ENTER |
| Close the smart tag menu or message. |
ESC |
Change the keyboard focus without using the mouse
Another way to use the keyboard to work with programs that feature the Office Fluent Ribbon is to move the focus among the tabs and commands until you find the feature that you want to use. The following table lists some ways to move the keyboard focus without using the mouse.
| To do this |
Press |
| Select the active tab of the Ribbon and activate the access keys. |
ALT or F10. Press either of these keys again to move back to the document and cancel the access keys. |
| Move to another tab of the Ribbon. |
F10 to select the active tab, and then LEFT ARROW or RIGHT ARROW |
| Hide or show the Ribbon. |
CTRL+F1 |
| Display the shortcut menu for the selected command. |
SHIFT+F10 |
Move the focus to select each of the following areas of the window:
- Active tab of the Ribbon
- Any open task panes
- Status bar at the bottom of the window
- Your document
|
F6 |
| Move the focus to each command on the Ribbon, forward or backward, respectively. |
TAB or SHIFT+TAB |
| Move down, up, left, or right, respectively, among the items on the Ribbon. |
DOWN ARROW, UP ARROW, LEFT ARROW, or RIGHT ARROW |
| Activate the selected command or control on the Ribbon. |
SPACEBAR or ENTER |
| Open the selected menu or gallery on the Ribbon. |
SPACEBAR or ENTER |
| Activate a command or control on the Ribbon so you can modify a value. |
ENTER |
| Finish modifying a value in a control on the Ribbon, and move focus back to the document. |
ENTER |
| Get help on the selected command or control on the Ribbon. (If no Help topic is associated with the selected command, a general Help topic about the program is shown instead.) |
F1 |
Common tasks in Microsoft Office Word
| To do this |
Press |
| Create a nonbreaking space. |
CTRL+SHIFT+SPACEBAR |
| Create a nonbreaking hyphen. |
CTRL+HYPHEN |
| Make letters bold. |
CTRL+B |
| Make letters italic. |
CTRL+I |
| Make letters underline. |
CTRL+U |
| Decrease font size one value. |
CTRL+SHIFT+< |
| Increase font size one value. |
CTRL+SHIFT+> |
| Decrease font size 1 point. |
CTRL+[ |
| Increase font size 1 point. |
CTRL+] |
| Remove paragraph or character formatting. |
CTRL+SPACEBAR |
| Copy the selected text or object. |
CTRL+C |
| Cut the selected text or object. |
CTRL+X |
| Paste text or an object. |
CTRL+V |
| Paste special |
CTRL+ALT+V |
| Paste formatting only |
CTRL+SHIFT+V |
| Undo the last action. |
CTRL+Z |
| Redo the last action. |
CTRL+Y |
