15 Keyboard Shortcuts And Tips That Every Windows (Office) User Must Know

0
1472

All should know (Anderson Sykes’s – Excel Guru opinion) the following keyboard shortcuts because they save a lot of time vs. using the mouse.  This prevents piano playing, a process where you are constantly shuffling between the keyboard and the mouse. These keyboard shortcuts work in the most used Microsoft Office & other Windows programs.

Keyboard Shortcuts – Excel, Word, and PowerPoint (many will also work in Outlook)

  1. Basic shortcuts that work the same in Excel, Word, and PowerPoint:
  2. Ctrl + (Control key plus) -A, B, C, F, H, I, N, O, P, S, U, V, X, Y, Z

Most used (in order of mostly used/importance, Anderson Sykes’s opinion) are: S, C, V, Z, X, P, Y

They represent in order:

  1. Select All = A
  2. Bold = B
  3. Copy = C
  4. Find = F
  5. Find & Replace = H
  6. Italics = I
  7. New = N
    1. eg. Word = new document, Excel = new spreadsheet, Powerpoint = new presentation
  8. Open (file) = O
  9. Print = P
  10. Save = S
    1. The most valuable of all. Use frequently & repeatedly. Do not depend on the AutoSave setting of any program. Still, debating whether or not to use it? How much of my data/corrections/updates can I afford to lose?
  11. Underline = U
  12. Paste = V
  13. Cut = X
  14. Redo = Y
  15. Undo = Z

Bonus Tip for Office Products

Get most recent list of used reports = Atl + F + R

Excel Worksheet Tips

Ctrl+ home = Start of Xls document

Ctrl+ shift + end = highlight the end of the data

F4 = tap 4 times to make the cell formula  =$E$13066 then =E$13066 then $E13066 then E13066.  this makes relative and absolute fast instead of trying to get the mouse on the exact part of the formula.

Ctrl+ shift + L = turn filters on and off for fast filtering and sorting

Ctrl+Alt+V  =  Transpose after you copied the desired cells into the clipboard

Ctrl+Shift+$  apply currency formatting

Ctrl+Shift+! applies comma formatting

Ctrl+Shift+# applies date formatting

Ctrl+Shift+% applies percentage formatting

Microsoft Word Tips

Change the capitalization or case of the text.

Change between lowercase, UPPERCASE, and Capitalize Each Word, select the text, and press SHIFT + F3 until the case you  desire

Stephen Choo Quan and Anderson Sykes

More about the author