{"id":921,"date":"2013-10-25T08:08:00","date_gmt":"2013-10-25T15:08:00","guid":{"rendered":"https:\/\/community.scrippscollege.edu\/itfits\/?p=921"},"modified":"2013-10-25T08:08:00","modified_gmt":"2013-10-25T15:08:00","slug":"excel-tips-shortcuts","status":"publish","type":"post","link":"https:\/\/community.scrippscollege.edu\/itfits\/excel-tips-shortcuts\/","title":{"rendered":"Excel Tips: Shortcuts"},"content":{"rendered":"<p>So I got an email the other day with the weekly digest for one of the groups I follow on LinkedIn, which led me to this guy\u2019s post with a link to a <strong><a href=\"http:\/\/www.businessinsider.com\/basic-excel-tricks-and-shortcuts-2013-4?op=1\" target=\"_blank\"><span style=\"text-decoration: underline;\">Business Insider article on Excel tips<\/span><\/a><\/strong>, which I have decided to share with you.\u00a0 How\u2019s that for social networking?\u00a0 (I\u2019ve only given you a few of the shortcuts that were new to me that I found particularly useful, so if you want to find a few more, follow the link!\u00a0 A formula called VLOOKUP low on the page is worth a look.)<\/p>\n<p>Excel shortcuts illustrate a rare phenomenon when Mac and PC shortcuts match!\u00a0 For shortcuts that involve changing the number format like the ones given here, click just above the column you wish to change the format for (you\u2019ll see a downward arrow) to highlight the whole column.<\/p>\n<p><strong>Ctrl(Control)-Shift-$<\/strong><\/p>\n<p>This changes the number format into currency, with two decimal places at the end for change.\u00a0 It uses commas to separate the thousands.<\/p>\n<p><strong>Ctrl-Shift-!<\/strong><\/p>\n<p>This changes the number format into a number with two decimal places and commas to separate thousands.\u00a0 It\u2019s essentially the same as the currency format, but without the dollar sign.<\/p>\n<p><strong>Ctrl-Shift-%<\/strong><\/p>\n<p>This changes the number format into a percentage.<\/p>\n<p><em>By ITA, Hillary Shipps<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"<p>So I got an email the other day with the weekly digest for one of the groups I follow on LinkedIn, which led me to &hellip;<\/p>\n","protected":false},"author":53,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[43,5],"tags":[],"class_list":["post-921","post","type-post","status-publish","format-standard","hentry","category-microsoft-excel","category-tips-and-tricks"],"acf":[],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/community.scrippscollege.edu\/itfits\/wp-json\/wp\/v2\/posts\/921","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/community.scrippscollege.edu\/itfits\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/community.scrippscollege.edu\/itfits\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/community.scrippscollege.edu\/itfits\/wp-json\/wp\/v2\/users\/53"}],"replies":[{"embeddable":true,"href":"https:\/\/community.scrippscollege.edu\/itfits\/wp-json\/wp\/v2\/comments?post=921"}],"version-history":[{"count":0,"href":"https:\/\/community.scrippscollege.edu\/itfits\/wp-json\/wp\/v2\/posts\/921\/revisions"}],"wp:attachment":[{"href":"https:\/\/community.scrippscollege.edu\/itfits\/wp-json\/wp\/v2\/media?parent=921"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/community.scrippscollege.edu\/itfits\/wp-json\/wp\/v2\/categories?post=921"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/community.scrippscollege.edu\/itfits\/wp-json\/wp\/v2\/tags?post=921"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}