| Windows system key combinations |
| F1: Help |
| CTRL+ESC: Open Start menu |
| ALT+TAB: Switch between open programs |
| ALT+F4: Quit program |
| SHIFT+DELETE: Delete item permanently |
| Windows Logo+L: Lock the computer (without using CTRL+ALT+DELETE) |
| Windows program key combinations |
| CTRL+C: Copy |
| CTRL+X: Cut |
| CTRL+V: Paste |
| CTRL+Z: Undo |
| CTRL+B: Bold |
| CTRL+U: Underline |
| CTRL+I: Italic |
| Mouse click/keyboard modifier combinations for shell objects |
| SHIFT+right click: Displays a shortcut menu containing alternative commands |
| SHIFT+double click: Runs the alternate default command (the second item on the menu) |
| ALT+double click: Displays properties |
| SHIFT+DELETE: Deletes an item immediately without placing it in the Recycle Bin |
| General keyboard-only commands |
| F1: Starts Windows Help |
| F10: Activates menu bar options |
| SHIFT+F10 Opens a shortcut menu for the selected item (this is the same as right-clicking an object |
| CTRL+ESC: Opens the Start menu (use the ARROW keys to select an item) |
| CTRL+ESC or ESC: Selects the Start button (press TAB to select the taskbar, or press SHIFT+F10 for a context menu) |
| CTRL+SHIFT+ESC: Opens Windows Task Manager |
| ALT+DOWN ARROW: Opens a drop-down list box |
| ALT+TAB: Switch to another running program (hold down the ALT key and then press the TAB key to view the task-switching window) |
| SHIFT: Press and hold down the SHIFT key while you insert a CD-ROM to bypass the automatic-run feature |
| ALT+SPACE: Displays the main window’s System menu (from the System menu, you can restore, move, resize, minimize, maximize, or close the window) |
| ALT+- (ALT+hyphen): Displays the Multiple Document Interface (MDI) child window’s System menu (from the MDI child window’s System menu, you can restore, move, resize, minimize, maximize, or close the child window) |
| CTRL+TAB: Switch to the next child window of a Multiple Document Interface (MDI) program |
| ALT+underlined letter in menu: Opens the menu |
| ALT+F4: Closes the current window |
| CTRL+F4: Closes the current Multiple Document Interface (MDI) window |
| ALT+F6: Switch between multiple windows in the same program (for example, when the Notepad Find dialog box is displayed, ALT+F6 switches between the Find dialog box and the main Notepad window) |
| Shell objects and general folder/Windows Explorer shortcuts |
| For a selected object: |
| F2: Rename object |
| F3: Find all files |
| CTRL+X: Cut |
| CTRL+C: Copy |
| CTRL+V: Paste |
| SHIFT+DELETE: Delete selection immediately, without moving the item to the Recycle Bin |
| ALT+ENTER: Open the properties for the selected object |
| To copy a file |
| Press and hold down the CTRL key while you drag the file to another folder. |
| To create a shortcut |
| Press and hold down CTRL+SHIFT while you drag a file to the desktop or a folder. |
| General folder/shortcut control |
| F4: Selects the Go To A Different Folder box and moves down the entries in the box (if the toolbar is active in Windows Explorer) |
| F5: Refreshes the current window. |
| F6: Moves among panes in Windows Explorer |
| CTRL+G: Opens the Go To Folder tool (in Windows 95 Windows Explorer only) |
| CTRL+Z: Undo the last command |
| CTRL+A: Select all the items in the current window |
| BACKSPACE: Switch to the parent folder |
| SHIFT+click+Close button: For folders, close the current folder plus all parent folders |
| Windows Explorer tree control |
| Numeric Keypad *: Expands everything under the current selection |
| Numeric Keypad +: Expands the current selection |
| Numeric Keypad -: Collapses the current selection. |
| RIGHT ARROW: Expands the current selection if it is not expanded, otherwise goes to the first child |
| LEFT ARROW: Collapses the current selection if it is expanded, otherwise goes to the parent |
| Properties control |
| CTRL+TAB/CTRL+SHIFT+TAB: Move through the property tabs |
| Accessibility shortcuts |
| Press SHIFT five times: Toggles StickyKeys on and off |
| Press down and hold the right SHIFT key for eight seconds: Toggles FilterKeys on and off |
| Press down and hold the NUM LOCK key for five seconds: Toggles ToggleKeys on and off |
| Left ALT+left SHIFT+NUM LOCK: Toggles MouseKeys on and off |
| Left ALT+left SHIFT+PRINT SCREEN: Toggles high contrast on and off |
| Microsoft Natural Keyboard keys |
| Windows Logo: Start menu |
| Windows Logo+R: Run dialog box |
| Windows Logo+M: Minimize all |
| SHIFT+Windows Logo+M: Undo minimize all |
| Windows Logo+F1: Help |
| Windows Logo+E: Windows Explorer |
| Windows Logo+F: Find files or folders |
| Windows Logo+D: Minimizes all open windows and displays the desktop |
| CTRL+Windows Logo+F: Find computer |
| CTRL+Windows Logo+TAB: Moves focus from Start, to the Quick Launch toolbar, to the system tray (use RIGHT ARROW or LEFT ARROW to move focus to items on the Quick Launch toolbar and the system tray) |
| Windows Logo+TAB: Cycle through taskbar buttons |
| Windows Logo+Break: System Properties dialog box |
| Application key: Displays a shortcut menu for the selected item |
| Microsoft Natural Keyboard with IntelliType software installed |
| Windows Logo+L: Log off Windows |
| Windows Logo+P: Starts Print Manager |
| Windows Logo+C: Opens Control Panel |
| Windows Logo+V: Starts Clipboard |
| Windows Logo+K: Opens Keyboard Properties dialog box |
| Windows Logo+I: Opens Mouse Properties dialog box |
| Windows Logo+A: Starts Accessibility Options (if installed) |
| Windows Logo+SPACEBAR: Displays the list of Microsoft IntelliType shortcut keys |
| Windows Logo+S: Toggles CAPS LOCK on and off |
| Dialog box keyboard commands |
| TAB: Move to the next control in the dialog box |
| SHIFT+TAB: Move to the previous control in the dialog box |
| SPACEBAR: If the current control is a button, this clicks the button. If the current control is a check box, this toggles the check box. If the current control is an option, this selects the option. |
| ENTER: Equivalent to clicking the selected button (the button with the outline) |
| ESC: Equivalent to clicking the Cancel button |
| ALT+underlined letter in dialog box item: Move to the corresponding item |
Category: INFO
| Command | Shortcut |
| Group objects | Ctrl+Shift+G |
| Ungroup objects | Ctrl+Shift+H |
| Show or hide grid | Shift+F9 |
| Show or hide guides | Alt+F9 |
| Change grid or guide settings | Ctrl+G |
| Show AutoShape menu and insert shape | Alt+U -> Ctrl+ENTER |
| Insert perfect squares | Press shift first, start drawing figure |
| Move selection in specific direction | Ctrl+ARROW |
| Zoom | Ctrl+mouse wheel |
| Duplicate selectedshapes | Ctrl+D |
| Insert new slide | Ctrl+M |
| Draw multiple similar figures | Double-click corresponding toolbar icon |
| Repeatlast action | F4 |
| Activate menu bar | F10 |
| Context menu | Shift+F10 or Windows special key |
| Work with presentations | Shortcut |
| Create new presentation | Ctrl+N |
| Insertnew slide | Ctrl+M |
| Duplicate selected slide | Ctrl+D |
| Open a presentations | Ctrl+O |
| Close presentation | Ctrl+W |
| Print presentation | Ctrl+P |
| Save presentation | Ctrl+S |
| Quit PowerPoint | Alt+F4 |
| Find text | Ctrl+F |
| Replace text | Ctrl+H |
| Repeat the last find action | Shift+F4 |
| Insert a hyperlink | Ctrl+K |
| Undo an action | Ctrl+Z |
| Redo or repeat an action | Ctrl+Y |
| Switch to the next pane | F6 |
| Switch to the previous pane | Shift+F6 |
| Cancel an action | ESC |
| Carry out Save As command | F12 |
| Carry out Save command | Shift+F12 |
| Carry out Open command | Ctrl+F12 |
| Carry out Print command | Ctrl+Shift+F12 |
| Display Visual Basic code | Alt+F11 |
| Text operations | Shortcut |
| Delete one word to the left | Ctrl+BACKSPACE |
| Delete one word to the right | Ctrl+DELETE |
| Cut selected object | Ctrl+X |
| Copy selected object | Ctrl+C |
| Paste cut or copied object | Ctrl+V |
| Move cursor one word to the left | Ctrl+LEFT ARROW |
| Move cursor one word to the right | Ctrl+RIGHT ARROW |
| Changecase letters (toggles through sentence case, lowercase, and uppercase) | Shift+F3 |
| Center paragraph | Ctrl+E |
| Justify paragraph | Ctrl+J |
| Left align paragraph | Ctrl+L |
| Right align paragraph | Ctrl+R |
| Promoteparagraph | Alt+Shift+LEFT ARROW |
| Demote paragraph | Alt+Shift+RIGHT ARROW |
| Move selected paragraphs up | Alt+Shift+UP ARROW |
| Move selected paragraphs down | Alt+Shift+DOWN ARROW |
| Format font style | Ctrl+T |
| Changefont size | Ctrl+Shift+P |
| Increasefont size | Ctrl+Shift+> |
| Decrease font size | Ctrl+Shift+< |
| Apply bold formatting | Ctrl+B |
| Apply an underline | Ctrl+U |
| Apply italic formatting | Ctrl+I |
| Apply subscript formatting | Ctrl+EQUAL SIGN |
| Apply superscript formatting | Ctrl+Shift+PLUS SIGN |
| Remove manual character formatting | Ctrl+SPACEBAR |
| Copy formats | Ctrl+Shift+C |
| Paste formats | Ctrl+Shift+V |
| Insert a tab in a table cell | Ctrl+TAB |
| Addnew row at the bottom of a table | TAB at the end of the last row |
| Check spelling | F7 |
| Find next misspelling (Automatic Spell Checking enabled) | Shift+F7 |
| Selection | Shortcut |
| Select next object (with an object selected) | TAB or Shift+TAB |
| Select text within selected object | ENTER |
| Select all objects | Ctrl+A (in slide pane) |
| Select all slides | Ctrl+A (in slide sorter view) |
| Select all text | Ctrl+A (in text field) |
| Move to the end of a line | END |
| Move to the beginning of a line | HOME |
| Move up one paragraph | Ctrl+UP ARROW |
| Move down one paragraph | Ctrl+DOWN ARROW |
| Control slide shows | Shortcut |
| Start slideshow from current slide | Shift+F5 |
| Slideshow from beginning | F5 |
| Perform next animation or advance tonext slide | ENTER, PAGE DOWN, RIGHT ARROW, DOWN ARROW, SPACEBAR, or mouse click |
| Perform previous animation or return toprevious slide | P, PAGE UP, LEFT ARROW, UP ARROW, or BACKSPACE |
| Go to slide | <number>+ENTER |
| Display a black screen, or return to slide show from black screen | B or PERIOD |
| Display a white screen, or return to the slide show from a white screen | W or COMMA |
| Stop or restartautomatic slide show | S or PLUS SIGN |
| End slide show | ESC, Ctrl+BREAK, or HYPHEN |
| Erase on-screen annotations | E |
| Go to next hidden slide | H |
| Set new timings while rehearsing | T |
| Use original timings while rehearsing | O |
| Use mouse-click to advance while rehearsing | M |
| Return to first slide | HOME or both mouse buttons for 2 seconds |
| Redisplay hidden pointer and/or change the pointer to a pen | Ctrl+P |
| Redisplay hidden pointer and/or change the pointer to an arrow | Ctrl+A |
| Hidepointer and button immediately | Ctrl+H |
| Hidepointer and button in 15 seconds | Ctrl+U |
| Display shortcut menu | Shift+F10 or right-click or special windows key |
| Go to first or next hyperlink on slide | TAB |
| Go to last or previous hyperlink on slide | Shift+TAB |
| Perform “mouse click” behavior of selected hyperlink | ENTER while hyperlink is selected |
| Perform “mouse over” behavior of selected hyperlink | Shift+ENTER while hyperlink is selected |
| Display list of controls | F1 |
| 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 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 of 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 |
| Open the selected folder or file. | ENTER |
| Open the folder one level above the selected folder. | BACKSPACE |
| Delete the selected folder or file. | DELETE |
| Display a shortcut menu for a selected item such as a folder or file. | SHIFT+F10 |
| Move forward through options. | TAB |
| Move back through options. | SHIFT+TAB |
| Open the Look in list. | F4 or ALT+I |
| 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 |
| GENERAL | |
| Alt+2 | Duplicate Voucher |
| Alt+A | Add voucher / To Alter the column in columnar report |
| Alt+C | Create a master at a voucher screen (if it has not been already assigned a different function, as in reports like Balance Sheet, wh |
| Alt+D | Delete a voucher To delete Accounting or Inventory master which is not used by any voucher or elsewhere in the alteration mode. To |
| Alt+E | Export the report in ASCII, HTML OR XML format |
| Alt+I | Insert a voucher / To toggle between Item and Accounting invoice |
| Alt+N | To view the report in automatic columns (Multiple Columns at all reports, Trial Balance, Cash/bank books, Group Summary & Journal Reg |
| Alt+P | Print the report |
| Alt+R | Remove a line in a report |
| Alt+S | Bring back a line you removed using Alt+R |
| Alt+U | Retrieve the last line which is deleted using Alt+R |
| Alt+W | To view the Tally Web browser. |
| Alt+X | Cancel a voucher in Day Book/List of Vouchers |
| Alt+Y | Register Tally |
| Ctrl+A | Accept a form – wherever you use this key combination, that screen or report gets accepted as it is. |
| Ctrl+Alt+B | Check the Company Statutory details |
| Ctrl+G | Select Group |
| Alt+I | Import statutory masters |
| Ctrl+Q | Abandon a form – wherever you use this key combination, it quits that screen without making any changes to it. |
| Ctrl+Alt+R | Rewrite data for a Company |
| Alt+H | Help Shortcut |
| Alt+F2 | Maintain Date for Multiple Years by changing period on Gateway of Tally / Change of Period for Setting Period |
| Ctrl+M | Switches to Main Area of Tally Screen |
| Ctrl+N | Switches to Calculator / ODBC Section of Tally Screen |
| Alt+R | Recalls the last narration saved for the first ledger in the voucher, irrespective of the voucher type |
| Ctrl+R | Repeat narration in the same voucher type irrespective of Ledger Account |
| Ctrl+T | Mark any voucher as Post Dated Voucher |
| Alt+D | Delete any voucher in Day Book/ Deleting |
| Alt+O | To upload the report to the webe |
| Alt+M | Email the report |
| Alt+F1 | Close a Company (At All Menu Screens). View detailed Report (Report Screens). Explore a line into its details (At Almost all Screens) |
| Alt+F3 | Select the company info menu (At Gateway of Tally Screen). Create/ alter / shut a company (At Gateway of Tally Screen) |
| Alt+F5 | View sales and purchase register summary on a quarterly basis |
| Alt+F12 | View the filters screen where the range of information can be specified |
| Alt+Z | Zoom |
| Ctrl+Alt+C | Copy the text from Tally (At creation and alternation screens) |
| Ctrl+Alt+V | To paste the text from Tally (At creation and alternation screens) |
| Shift+Enter | To view the next level of details and / or condense the next level of details |
| F2 | Change the date |
| F4 | Contra Voucher (All voucher creation and alteration screens). View list of Groups (Reports groups summary, group voucher screen, cash/ bank summary) |
| F5 | Select Payment Voucher. Switch between Grouped and Ledger-wise Display |
| F6 | Select Receipt Voucher |
| F7 | Select Journal Voucher |
| F8 | Select Sales Voucher |
| F9 | Select Purchase Voucher |
| Ctrl+F9 | Select Debit Note Voucher |
| F10 | Navigate between Accounting Reports |
| F11 | Modify Company features specific to current company only |
| F12 | Master Configurations, which will affect all companies in same data directory. |
| Ctrl+L | Mark a voucher as Optional or Regular |
| Ctrl+Alt+c (for copy) Ctrl+Alt+v (for paste) | Duplicate narration in many Vouchers |
| INVENTORY VOUCHERS | |
|---|---|
| Alt+F4 | Purchase Order Voucher |
| Alt+F5 | Sales Order Voucher |
| Ctrl+F6 | Rejection In |
| Alt+F7 | Stock Journal / Manufacturing Journal |
| Alt+F8 | Delivery Note |
| Alt+F9 | Receipt Note |
| Alt+F10 | Physical Stock |
| Esc | Clear entry |
| Function | Short cut |
| Select All | Ctrl+A |
| Bold | Ctrl+B |
| Copy | Ctrl+C |
| Fill Down | Ctrl+D |
| Find | Ctrl+F |
| Goto | Ctrl+G |
| Replace | Ctrl+H |
| Italic | Ctrl+I |
| Insert Hyperlink | Ctrl+K |
| New Workbook | Ctrl+N |
| Open | Ctrl+O |
| Ctrl+P | |
| Fill Right | Ctrl+R |
| Save | Ctrl+S |
| Underline | Ctrl+U |
| Paste | Ctrl+V |
| Close | Ctrl W |
| Cut | Ctrl+X |
| Repeat | Ctrl+Y |
| Undo | Ctrl+Z |
| Help | F1 |
| Edit | F2 |
| Paste Name | F3 |
| Repeat last action | F4 |
| While typing a formula, switch between absolute/relative refs | F4 |
| Goto | F5 |
| Next Pane | F6 |
| Spell check | F7 |
| Extend mode | F8 |
| Recalculate all workbooks | F9 |
| Activate Menubar | F10 |
| New Chart | F11 |
| Save As | F12 |
| Insert Current Time | Ctrl+: |
| Insert Current Date | Ctrl+; |
| Copy Value from Cell Above | Ctrl+” |
| Copy Formula from Cell Above | Ctrl+’ |
| Hold down shift for additional functions in Excel’s menu | Shift |
| What’s This? | Shift+F1 |
| Edit cell comment | Shift+F2 |
| Paste function into formula | Shift+F3 |
| Find Next | Shift+F4 |
| Find | Shift+F5 |
| Previous Pane | Shift+F6 |
| Add to selection | Shift+F8 |
| Calculate active worksheet | Shift+F9 |
| Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation. | Ctrl+Alt+F9 |
| Rechecks dependent formulas and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated. | Ctrl+Alt+Shift+F9 |
| Display shortcut menu | Shift+F10 |
| New worksheet | Shift+F11 |
| Save | Shift+F12 |
| Define name | Ctrl+F3 |
| Close | Ctrl+F4 |
| XL, Restore window size | Ctrl+F5 |
| Next workbook window | Ctrl+F6 |
| Previous workbook window | Shift+Ctrl+F6 |
| Move window | Ctrl+F7 |
| Resize window | Ctrl+F8 |
| Minimize workbook | Ctrl+F9 |
| Maximize or restore window | Ctrl+F10 |
| Inset 4.0 Macro sheet | Ctrl+F11 |
| File Open | Ctrl+F12 |
| Insert Chart | Alt+F1 |
| Save As | Alt+F2 |
| Exit | Alt+F4 |
| Macro dialog box | Alt+F8 |
| Visual Basic Editor | Alt+F11 |
| Create name by using names of row and column labels | Ctrl+Shift+F3 |
| Previous Window | Ctrl+Shift+F6 |
| Ctrl+Shift+F12 | |
| New worksheet | Alt+Shift+F1 |
| Save | Alt+Shift+F2 |
| AutoSum | Alt+= |
| Toggle Value/Formula display | Ctrl+` |
| Insert argument names into formula | Ctrl+Shift+A |
| Display AutoComplete list | Alt+Down arrow |
| Format Style dialog box | Alt+’ |
| General format | Ctrl+Shift+~ |
| Comma format | Ctrl+Shift+! |
| Time format | Ctrl+Shift+@ |
| Date format | Ctrl+Shift+# |
| Currency format | Ctrl+Shift+$ |
| Percent format | Ctrl+Shift+% |
| Exponential format | Ctrl+Shift+^ |
| Place outline border around selected cells | Ctrl+Shift+& |
| Remove outline border | Ctrl+Shift+_ |
| Select the current region around the active cell. In a PivotTable report, select the entire PivotTable report. | Ctrl+Shift+* |
| Insert | Ctrl++ |
| Delete | Ctrl+- |
| Format cells dialog box | Ctrl+1 |
| Bold | Ctrl+2 |
| Italic | Ctrl+3 |
| Underline | Ctrl+4 |
| Strikethrough | Ctrl+5 |
| Show/Hide objects | Ctrl+6 |
| Show/Hide Standard toolbar | Ctrl+7 |
| Toggle Outline symbols | Ctrl+8 |
| Hide rows | Ctrl+9 |
| Hide columns | Ctrl+0 |
| Unhide rows | Ctrl+Shift+( |
| Unhide columns | Ctrl+Shift+) |
| Activate the menu | Alt or F10 |
| In toolbar: next toolbar | Ctrl+Tab |
| In a workbook: activate next workbook | |
| In toolbar: previous toolbar | Shift+Ctrl+Tab |
| In a workbook: activate previous workbook | |
| Next tool | Tab |
| Previous tool | Shift+Tab |
| Do the command | Enter |
| Start a new line in the same cell. | Alt+Enter |
| Fill the selected cell range with the current entry. | Ctrl+Enter |
| Font Drop Down List | Shift+Ctrl+F |
| Font tab of Format Cell Dialog box | Shift+Ctrl+F+F |
| Point size Drop Down List | Shift+Ctrl+P |
| Select the entire column | Ctrl+Spacebar |
| Select the entire row | Shift+Spacebar |
| Select the array containing the active cell. | CTRL+/ |
| Select all cells that contain comments. | CTRL+SHIFT+O |
| In a selected row, select the cells that don’t match the formula or static value in the active cell. | CTRL+\ |
| In a selected column, select the cells that don’t match the formula or static value in the active cell. | CTRL+SHIFT+| |
| Select all cells directly referenced by formulas in the selection. | CTRL+[ |
| Select all cells directly or indirectly referenced by formulas in the selection. | CTRL+SHIFT+{ |
| Select cells that contain formulas that directly reference the active cell. | CTRL+] |
| Select cells that contain formulas that directly or indirectly reference the active cell. | CTRL+SHIFT+} |
| Select the visible cells in the current selection. | ALT+; |
| With multiple cells selected, select only the active cell. | SHIFT+BACKSPACE |
| Selects the entire worksheet. | CTRL+SHIFT+SPACEBAR |
| If the worksheet contains data, CTRL+SHIFT+SPACEBAR selects the current region. CTRL+SHIFT+SPACEBAR a second time selects the entire worksheet. | |
| When an object is selected, CTRL+SHIFT+SPACEBAR selects all objects on a worksheet | |
| Reapply the filter and sort on the current range so that changes you’ve made are included | Ctrl+Alt+L |
| Displays the Paste Special dialog box. Available only after you have cut or copied an object, text, or cell contents on a worksheet or in another program. | Ctrl+Alt+V |
