General Windows Shortcuts: 1. Switch between open windows o Alt + Tab (Tap once to switch to last selected window) 2. Close current tab/window/document o Ctrl + F4 (same as Alt F, C) 3. Close current program o Alt + F4 4. Minimize current window o Alt + Spacebar, N 5. Maximize window o Alt + Spacebar, X 6. Show desktop o Windows key + D 7. Edit a filename o F2 8. Undo current editing of filename o Esc 9. Skip to beginning of next word o Ctrl + left or right (combine with shift for highlighting) 10. Move to beginning/end of current line o Home/End buttons 11. Move to beginning/end of page or document o Ctrl + Home/End 12. Zoom in and out of a text page o Ctrl + move mouse wheel (also works in other text viewers & browsers) 13. Switch active portion of window o
Tab for forward, and Shift Tab for backward
14. Right Click o Right click key, or Shift + F10 15. Cycle through items in the order that they had been opened o Alt + esc 16. Create a shortcut to the selected item o Ctrl + Shift (while dragging an item)
Word: 1. Subscript / Superscript o Alt + Plus Sign / Alt + Shift + plus sign 2. Degree symbol 째 o Alt + 2,4,8 3. Have a page in the middle of the document as landscape o Page layout, breaks, next page (2x) Then set middle page as landscape 4. Finely adjust picture size o Hold Alt while resizing/cropping 5. Select the entire sentence o Ctrl + click anywhere in sentence 6. Delete word to the left/right of cursor o Ctrl + Backspace/Delete 7. Change case to all Caps o Ctrl + Shift + A 8. Repeat the most recent action o F4 Christopher P. Horvath
MS Shortcuts, tips, & tricks
9. Change font o Ctrl + Shift + F (same in Excel) 10. Highlight multiple rows o Hold cursor at the side of row and Ctrl + click 11. Move tab or bullet left o Shift + Tab 12. Close a dialog box o Escape key
Excel: 1. Move through tabs of a document o Control + Page up/Page Down 2. Switch between open documents in excel o Ctrl + Tab 3. Fill columns below with formula o Ctrl+ D 4. Lock referenced column/row o F4 5. Move to first box/last box with text o Ctrl + Home/End 6. F2 o Edit a text box, allows you to move backward and forward in a cell using arrow keys 7. When editing source data of graphs o Using F2, Control Z, and escape button are helpful 8. Have two windows side by side o Open another instance of Excel, and then open the document, rather than through the same
program 9. Paste value data into excel o Alt + H, V, S, V, Enter 10. Processing data in Excel o Create a template 11. Keep column titles visible o Highlight a cell below the title, then go to view, and click split 12. Skip to last cell in column/row o Ctrl up/down/left/right (use with Shift to highlight) 13. Resize all of the columns at once o Highlight all the columns from the top, then double click on a line between 2 columns 14. Sort by alphabetical o Data, AZ or ZA 15. Create a text cell which incorporates another cell o =Concatenate(“Text1”, CellNumber, “Text2”) 16. Convert columns to rows or vice versa o Copy vertical or horizontal cells, paste special, transpose
PowerPoint: 1. Make mouse visible o Right click, O, O, V 2. Start presentation from current slide o Shift + F5 3. Start Presentation o F5
Christopher P. Horvath
MS Shortcuts, tips, & tricks