{"id":1148,"date":"2018-01-04T13:49:05","date_gmt":"2018-01-04T05:49:05","guid":{"rendered":"http:\/\/owa.sodexo-cn.com\/blog\/?p=1148"},"modified":"2018-01-04T13:56:50","modified_gmt":"2018-01-04T05:56:50","slug":"exceltwo-excel-tips","status":"publish","type":"post","link":"https:\/\/owa.sodexo-cn.com\/blog\/?p=1148","title":{"rendered":"[Excel]Two Excel Tips"},"content":{"rendered":"<p><span style=\"color: #555555; font-family: Segoe UI; font-size: 10pt;\">This time we will introduce two tips for entering content in Excel.<br \/>\n<\/span><\/p>\n<h2><span style=\"font-family: \u5b8b\u4f53; font-size: 12pt;\">Enter in multiple workbooks at the same time<br \/>\n<\/span><\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1150\" src=\"https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2018\/01\/1.gif\" alt=\"\" width=\"926\" height=\"595\" \/><\/p>\n<p><span style=\"color: #555555; font-family: Segoe UI; font-size: 10pt;\">When you have multiple workbooks that need to enter the same content at the same time, you can never have to enter the same content repeatedly in each table.<br \/>\n<\/span><\/p>\n<p><span style=\"color: #555555; font-family: Segoe UI; font-size: 10pt;\">In fact, just hold down the CTRL key and select more than one workbook, and then press ENTER at the end of the list.<br \/>\n<\/span><\/p>\n<h2><span style=\"font-family: \u5b8b\u4f53; font-size: 12pt;\">Quickly copy previous row or column contents<br \/>\n<\/span><\/h2>\n<p><span style=\"color: #555555; font-family: Segoe UI; font-size: 10pt;\">And sometimes, we may need to enter many of the same data in the same workbook, repeatedly input or one by one times of pasting, obviously very inefficient. This is how you can do this:<br \/>\n<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1151\" src=\"https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2018\/01\/2.gif\" alt=\"\" width=\"926\" height=\"595\" \/><\/p>\n<p><span style=\"color: #555555; font-family: Segoe UI; font-size: 10pt;\">When you want to duplicate the previous line of content, you can select one area after the CTRL (D-down). The last line of content is copied.<br \/>\n<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1152\" src=\"https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2018\/01\/3.gif\" alt=\"\" width=\"926\" height=\"595\" \/><\/p>\n<p><span style=\"color: #555555; font-family: Segoe UI; font-size: 10pt;\">Similarly, when you want to duplicate the previous column, you can select one area and press CTRL (R-right).<br \/>\n<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>This time we will introduce two tips for entering conte &#8230; <a title=\"[Excel]Two Excel Tips\" class=\"read-more\" href=\"https:\/\/owa.sodexo-cn.com\/blog\/?p=1148\" aria-label=\"\u9605\u8bfb [Excel]Two Excel Tips\">\u9605\u8bfb\u66f4\u591a<\/a><\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-1148","post","type-post","status-publish","format-standard","hentry","category-tips"],"views":2025,"_links":{"self":[{"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1148","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1148"}],"version-history":[{"count":3,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1148\/revisions"}],"predecessor-version":[{"id":1154,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1148\/revisions\/1154"}],"wp:attachment":[{"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1148"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1148"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1148"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}