Questions From Previous Tech Talk
- Do Excel shortcuts work in the web browser? Yes.
- Can you use QuickParts in Word? Yes.
Common Shortcuts for Web Browsers
| Order of Usefulness (subjective) |
Shortcut | Action |
|---|---|---|
| 1 | CTRL + Left-Click | Opens a link in a new tab |
| 2 | CTRL + T | New tab |
| 3 | CTRL + SHIFT + T | Reopen last closed tab |
| 4 | CTRL + L | Type in the browser search bar |
| 5 | CTRL + Tab | Next tab to the right |
| 7 | CTRL + W | Close current tab |
| 8 | SHIFT + Right-Click | Opens a link in a new window |
| 9 | CTRL + SHIFT + Tab | Next tab to the left |
| 10 | CTRL + N | New Window / New Document |
| 11 | CTRL + SHIFT + W | Close all tabs (entire application) does not work in Internet Explorer |
Create a Custom Hotkey for Applications
- Using a shortcut on the Desktop, right-click the icon and select Properties.
- In the Properties dialog, find the text box labeled “Shortcut key”
- Click in the text box and enter a key that you wish to use in your hotkey. ...
- Click "OK"
Common Windows Shortcuts
| Shortcut | Action |
|---|---|
| Windows key | Open or close Start Menu. |
| Windows key + D | Display and hide the desktop. |
| Windows key + E | Open File Explorer. |
| Windows key + I | Open Settings. |
| Windows key + L | Lock your PC or switch accounts. |
| Windows key + M | Minimize all windows. |
| Windows key + R | Open Run dialog box. |
| Windows key + S | Open Search. |
| Windows key + Left arrow key | Snap app windows left. |
| Windows key + Right arrow key | Snap app windows right. |
| Windows key + Up arrow key | Maximize app windows. |
| Windows key + Down arrow key | Minimize app windows. |
| Windows key + Comma | Temporarily peek at the desktop. |
| Windows key + PrtScn | Capture a screenshot and save in Screenshots folder. |
| Windows key + Shift + Up arrow | Stretch the desktop window to the top and bottom of the screen. |
| Windows key + Tab | Open Task view. |
| Windows key + "+" key | Zoom in using the magnifier. |
| Windows key + "-" key | Zoom out using the magnifier. |
| Ctrl + Shift + Esc | Open Task Manager. |
| Alt + Tab | Switch between open apps. |
| Ctrl + Alt +Tab | View open apps |
| Ctrl + F | Find text in a Document or Web-page. |
| Ctrl + C | Copy selected items to clipboard. |
| Ctrl + X | Cut selected items. |
| Ctrl + V | Paste content from clipboard. |
| Ctrl + A | Select all content. |
| Ctrl + Z | Undo an action. |
| Ctrl + Y | Redo an action. |
| Ctrl + D | Delete the selected item and move it to the Recycle Bin. |
| Ctrl + Shift + Esc | Open Task Manager. |
| Alt + F4 | Close the active window. |
Excel Shortcuts
Moving around
Arrow Keys – move in the direction you pressed
Ctrl+Arrow Keys – select the last cell in the data set in the direction you press
Ctrl+Home – select the top left cell of the data (usually cell A1)
Ctrl+End – select the bottom right cell of the data
Ctrl+A - select all cells
Highlighting cells
In general, you can add “Shift” to the above shortcuts to highlight all of the cells in the range.
Shift+Arrow Keys – highlight the current cell and the next consecutive cell in the direction you press
Ctrl+Home – highlight the current cell and all cells between it and the top left cell of the data.
Ctrl+End – highlight the current cell and all cells between it and the bottom right cell of the data.
Outlook Quick Part Shortcut
The steps for creating a Quick Part building block are the same for Email, Calendar, Contacts, and Tasks. Technically, it doesn’t matter where in Outlook you create the item. The saved quick part can be inserted into just about any Outlook item. Since you’re more apt to use email, I’ll use it for the instructions.
- Open Microsft Outlook (not outlook.com)
- From the Home tab, click New Email.
- In the text area of the message, type the content you’d like to use as your boilerplate.
- Apply any formatting to your text.
- Highlight the information you want in the Quick Part.
- Click the Insert tab on the ribbon
- Click Quick Parts from the Text group.
- Select Save Selection to Quick Part gallery…
Resources
1. Apple Shortcut Keyboard Map
2. Windows Shortcut Keyboard Map