{"id":447,"date":"2013-08-18T07:34:47","date_gmt":"2013-08-18T11:34:47","guid":{"rendered":"http:\/\/elearningpod.com\/?page_id=447"},"modified":"2014-09-28T11:46:49","modified_gmt":"2014-09-28T15:46:49","slug":"office-excel","status":"publish","type":"page","link":"https:\/\/elearningpod.com\/?page_id=447","title":{"rendered":"Office – Excel"},"content":{"rendered":"

Tips and Tricks:<\/b><\/p>\n

1.\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 <\/b>Split screen<\/b> (for when you want to read online text and work on project at the same time!)<\/p>\n\n\n\n\n
Windows Key + Left Arrow<\/td>\nMaximize current window to left side of the screen<\/td>\n<\/tr>\n
Windows Key + Right Arrow<\/td>\nMaximize current window to right side of the screen<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

2.\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 <\/b>Select Column in Excel \u00c2\u00a0– Ctrl+Space Bar; Select Row in Excel \u00c2\u00a0– Shift+Space Bar<\/b><\/p>\n

In Excel, hit Ctrl plus the Space Bar to select the entire column of your active or selected cells. (Then you can delete all the cell contents with the delete key, or copy with Ctrl+C or whatever you like.)<\/p>\n

Similarly, Shift plus the Space Bar selects the entire row of cells.<\/p>\n

For example, suppose you want to move a column. Follow these steps:<\/p>\n

    \n
  1. Move \u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 your cursor to some cell in the column you want to move. (Remember you can \u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 press F5 to instantly go anywhere.)<\/li>\n
  2. Press \u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 Ctrl+Space Bar. The entire column is selected.<\/li>\n
  3. Press \u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 Ctrl+X to Cut the column.<\/li>\n
  4. Move \u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 your cursor to the location right where you want the column inserted.<\/li>\n
  5. Press \u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 Shift+F10 to display the shortcut menu.<\/li>\n
  6. Using \u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 the arrow keys and Enter, select the Insert Cut Cells command.<\/li>\n<\/ol>\n

    3.\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 <\/b>Display active cell in Excel \u00c2\u00a0– Ctrl+Backspace<\/b><\/p>\n

    Suppose you\u00e2\u20ac\u2122ve used the mouse to scroll too far in Excel. You\u00e2\u20ac\u2122re lost. The cells are zooming by at a million miles an hour. You just want to get back to see the cell where your cursor is. Help! Scrolling around to find the active cell will take forever! Ctrl+Backspace moves the visible area of the spreadsheet back to whereever your cursor is (the so-called active cell).<\/p>\n

    4.\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 <\/b>Move left and right one screen in Excel \u00c2\u00a0– Alt+Page Down, Alt+Page Up<\/b><\/p>\n

    To move to the right in Excel to see your next group of columns, you could scroll. Or you could press the Right Arrow key a bunch of times.<\/p>\n

    Or, press Alt+Page Up. You immediately find yourself one screen to the right looking at your next batch of columns.<\/p>\n

    Conversely, Alt+Page Down moves you to the left.<\/p>\n

    (Compare to the regular Page Up and Page Down, which you already know moves you up and down a screen.)<\/p>\n

    5.\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 <\/b>Insert New Worksheet in Excel \u00c2\u00a0– Shift+F11 <\/b><\/p>\n

    Don\u00e2\u20ac\u2122t click on the Insert menu and then the Worksheet command. Don\u00e2\u20ac\u2122t even press Alt+I, W. Just press Shift+F11 and a brand new worksheet is created for you in Excel.<\/p>\n

    Source: http:\/\/www.zeigen.com\/shortcuts\/<\/a><\/p>\n

    6. Best tip ever!!! Recover unsaved office files —<\/strong><\/div>\n
    go to: file –>Info–> Versions\/Manage Versions (Recover unsaved files!!!)<\/div>\n
    <\/div>\n
    http:\/\/www.makeuseof.com\/tag\/recover-unsaved-ms-word-2010-document-seconds\/<\/a><\/div>\n
    <\/div>\n
    7. Working with multiple lines – \u00c2\u00a0http:\/\/www.itbrigadeinc.com\/post\/2011\/12\/16\/Excel-Tips-and-Tricks-e28093Working-with-multiple-lines-in-a-single-cell.aspx<\/a><\/div>\n
    <\/div>\n
    8. Time travel in excel – http:\/\/chandoo.org\/wp\/2008\/08\/26\/date-time-tips-ms-excel\/<\/a><\/div>\n
    <\/div>\n
    9. Using Excel (2003) for cause analysis and process diagrams – http:\/\/www.thinkreliability.com\/video\/Excel03-tips-1min42\/Excel03-tips-1min42.html<\/a><\/div>\n
    <\/div>\n
    10. How many sleeps until xmas – http:\/\/theexceltrainer.co.uk\/how-many-sleeps-until-christmas\/<\/a><\/div>\n
    <\/div>\n
    \u00c2\u00a011. Create custom lists<\/strong><\/div>\n
    <\/div>\n
    http:\/\/employee-it-training.co.uk\/2014\/01\/create-a-custom-list-in-excel\/<\/a><\/div>\n
    <\/div>\n
    12. Formatting Tips: \u00c2\u00a0http:\/\/www.desktoptrainingacademy.com\/excel-formatting-tips\/<\/a><\/div>\n
    <\/div>\n
    13. Basic Sorting – http:\/\/www.desktoptrainingacademy.com\/using-basic-sorting-in-excel\/<\/a><\/div>\n
    <\/div>\n
    14. Remove Blank Lines – http:\/\/www.theexceladdict.com\/_t\/t031008.htm<\/a><\/div>\n","protected":false},"excerpt":{"rendered":"

    Tips and Tricks: 1.\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 Split screen (for when you want to read online text and work on project at the same time!) Windows Key + Left Arrow Maximize current window to left side of the screen Windows Key + Right … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":479,"menu_order":0,"comment_status":"open","ping_status":"open","template":"","meta":{"footnotes":""},"class_list":["post-447","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/elearningpod.com\/index.php?rest_route=\/wp\/v2\/pages\/447","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/elearningpod.com\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/elearningpod.com\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/elearningpod.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/elearningpod.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=447"}],"version-history":[{"count":14,"href":"https:\/\/elearningpod.com\/index.php?rest_route=\/wp\/v2\/pages\/447\/revisions"}],"predecessor-version":[{"id":795,"href":"https:\/\/elearningpod.com\/index.php?rest_route=\/wp\/v2\/pages\/447\/revisions\/795"}],"up":[{"embeddable":true,"href":"https:\/\/elearningpod.com\/index.php?rest_route=\/wp\/v2\/pages\/479"}],"wp:attachment":[{"href":"https:\/\/elearningpod.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=447"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}