{"id":3830,"date":"2018-04-13T10:10:30","date_gmt":"2018-04-13T16:10:30","guid":{"rendered":"http:\/\/www.designandexecute.com\/designs\/?p=3830"},"modified":"2022-09-13T16:37:18","modified_gmt":"2022-09-13T22:37:18","slug":"keyboard-shortcuts-and-tips-that-every-windows-office-user-must-know","status":"publish","type":"post","link":"https:\/\/www.designandexecute.com\/designs\/keyboard-shortcuts-and-tips-that-every-windows-office-user-must-know\/","title":{"rendered":"15 Keyboard Shortcuts And Tips That Every Windows (Office) User Must Know"},"content":{"rendered":"

All should know (Anderson Sykes’s – Excel Guru opinion) the following keyboard shortcuts because they save a lot of time vs. using the mouse.\u00a0 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.<\/p>\n

Keyboard Shortcuts – Excel, Word, and PowerPoint (many will also work in Outlook)<\/p>\n

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

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

    They represent in order:<\/p>\n

      \n
    1. Select All = A<\/li>\n
    2. Bold = B<\/li>\n
    3. Copy = C<\/li>\n
    4. Find = F<\/li>\n
    5. Find & Replace = H<\/li>\n
    6. Italics = I<\/li>\n
    7. New = N\n
        \n
      1. eg. Word = new document, Excel = new spreadsheet, Powerpoint = new presentation<\/li>\n<\/ol>\n<\/li>\n
      2. Open (file) = O<\/li>\n
      3. Print = P<\/li>\n
      4. Save = S<\/u><\/strong>\n
          \n
        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?<\/li>\n<\/ol>\n<\/li>\n
        2. Underline = U<\/li>\n
        3. Paste = V<\/li>\n
        4. Cut = X<\/li>\n
        5. Redo = Y<\/li>\n
        6. Undo = Z<\/li>\n<\/ol>\n

          Bonus Tip for Office Products<\/h1>\n

          Get most recent list of used reports = Atl + F + R<\/p>\n

          Excel Worksheet Tips<\/h1>\n

          Ctrl+ home<\/strong> = Start of Xls document<\/p>\n

          Ctrl+ shift + end<\/strong> = highlight the end of the data<\/p>\n

          F4 = tap 4 times<\/strong> to make the cell formula\u00a0 =$E$13066 then =E$13066 then $E13066 then E13066.\u00a0 this makes relative and absolute fast instead of trying to get the mouse on the exact part of the formula.<\/p>\n

          Ctrl+ shift + L<\/strong> = turn filters on and off for fast filtering and sorting<\/p>\n

          Ctrl+Alt+V<\/strong>\u00a0 =\u00a0 Transpose after you copied the desired cells into the clipboard<\/p>\n

          Ctrl<\/kbd>+Shift<\/kbd>+$\u00a0 apply currency formatting<\/kbd><\/p>\n

          Ctrl<\/kbd>+Shift<\/kbd>+! applies comma formatting<\/kbd><\/p>\n

          Ctrl<\/kbd>+Shift<\/kbd>+# applies date formatting<\/kbd><\/p>\n

          Ctrl<\/kbd>+Shift<\/kbd>+% applies percentage formatting<\/kbd><\/p>\n

          Microsoft Word Tips<\/h1>\n

          Change the capitalization or case of the text.<\/h2>\n

          Change between lowercase, UPPERCASE, and Capitalize Each Word, select the text, and press SHIFT + F3<\/strong> until the case you\u00a0 desire<\/p>\n

          Stephen Choo Quan and Anderson Sykes<\/span><\/h3>\n

          More about the author<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

          All should know (Anderson Sykes’s – Excel Guru opinion) the following keyboard shortcuts because they save a lot of time vs. using the mouse.\u00a0 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. […]<\/p>\n","protected":false},"author":2,"featured_media":3831,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[43],"tags":[],"class_list":["post-3830","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-bi-excel"],"jetpack_featured_media_url":"https:\/\/www.designandexecute.com\/designs\/wp-content\/uploads\/2018\/04\/1200px-Microsoft_Excel_2013_logo.svg_.png","_links":{"self":[{"href":"https:\/\/www.designandexecute.com\/designs\/wp-json\/wp\/v2\/posts\/3830","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.designandexecute.com\/designs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.designandexecute.com\/designs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.designandexecute.com\/designs\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.designandexecute.com\/designs\/wp-json\/wp\/v2\/comments?post=3830"}],"version-history":[{"count":5,"href":"https:\/\/www.designandexecute.com\/designs\/wp-json\/wp\/v2\/posts\/3830\/revisions"}],"predecessor-version":[{"id":15662,"href":"https:\/\/www.designandexecute.com\/designs\/wp-json\/wp\/v2\/posts\/3830\/revisions\/15662"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.designandexecute.com\/designs\/wp-json\/wp\/v2\/media\/3831"}],"wp:attachment":[{"href":"https:\/\/www.designandexecute.com\/designs\/wp-json\/wp\/v2\/media?parent=3830"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.designandexecute.com\/designs\/wp-json\/wp\/v2\/categories?post=3830"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.designandexecute.com\/designs\/wp-json\/wp\/v2\/tags?post=3830"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}