{"id":3348,"date":"2020-10-27T15:14:06","date_gmt":"2020-10-27T07:14:06","guid":{"rendered":"https:\/\/owa.sodexo-cn.com\/blog\/?p=3348"},"modified":"2020-10-27T15:14:06","modified_gmt":"2020-10-27T07:14:06","slug":"print-excel-sheets-is-no-longer-a-hassle","status":"publish","type":"post","link":"https:\/\/owa.sodexo-cn.com\/blog\/?p=3348","title":{"rendered":"Print Excel sheets is no longer a hassle"},"content":{"rendered":"\n<p>Many people use Excel with ease, but when it need to print out or convert to PDF, there is always a lot of confusion. Often the format you print is not what you want. Today, I\u2019ll show you how to quickly print out a perfectly formatted and readable spreadsheet.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Print on a piece of paper<\/strong><\/h4>\n\n\n\n<p>To do this, go to the lower right corner of Excel and select the &#8220;Page Break Preview&#8221; button in the lower right corner.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"288\" height=\"26\" src=\"https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2020\/10\/103.jpg\" alt=\"\" class=\"wp-image-3337\"\/><\/figure>\n\n\n\n<p>You can see how the entire Excel page is paginated after printing. At this point, drag the blue line in the screen to print the entire screen on a piece of paper!<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"637\" height=\"244\" src=\"https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2020\/10\/104.gif\" alt=\"\" class=\"wp-image-3338\"\/><\/figure>\n\n\n\n<p>If finally found that the page is too long, need paging, you can also press the right mouse button, select &#8220;insert page Break&#8221; to adjust, very convenient!<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"290\" src=\"https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2020\/10\/105.gif\" alt=\"\" class=\"wp-image-3339\"\/><\/figure>\n\n\n\n<p>There is also a faster way to do this: do it in print Preview and print. When you have a page that needs to be printed quickly, the quickest way to do this is to select Fit sheet on one page and print out.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"430\" src=\"https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2020\/10\/106.gif\" alt=\"\" class=\"wp-image-3340\"\/><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>The exact setting takes a few sheets of paper<\/strong><\/h4>\n\n\n\n<p>Excel actually allows you to quickly and accurately set your content to be printed on several sheets of paper. If you frequently encounter printed content with a small tail and a single extra page, this setting can help you quickly complete the printing Settings!<br>First, find the &#8220;Page Setup&#8221; button on the panel, and then set printed content fit to how many pages wide by how many pages tall.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"532\" height=\"454\" src=\"https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2020\/10\/112.jpg\" alt=\"\" class=\"wp-image-3349\" srcset=\"https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2020\/10\/112.jpg 532w, https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2020\/10\/112-300x256.jpg 300w\" sizes=\"auto, (max-width: 532px) 100vw, 532px\" \/><\/figure>\n\n\n\n<p>After we set the page to be 1 page wide and 2 pages high, we can see through the print preview that the printing size of the entire Excel document has been quickly adjusted to be no more or no less than 2 pages.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"303\" height=\"420\" src=\"https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2020\/10\/108.gif\" alt=\"\" class=\"wp-image-3342\"\/><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>The header automatically repeats after switched the page<\/strong><\/h4>\n\n\n\n<p>Sometimes you see tables that are printed so long that for every new page you open, the header disappears, and you can&#8217;t see what the table says. In fact, you only need to use the following Settings to achieve this!<br>First, in the page layout, find the option to print the title.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"334\" height=\"89\" src=\"https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2020\/10\/109.jpg\" alt=\"\" class=\"wp-image-3343\" srcset=\"https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2020\/10\/109.jpg 334w, https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2020\/10\/109-300x80.jpg 300w\" sizes=\"auto, (max-width: 334px) 100vw, 334px\" \/><\/figure>\n\n\n\n<p>Then we just need to follow the following GIF Settings, select the lines that need to be repeated during pagination, and we can see the effect!<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"419\" height=\"189\" src=\"https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2020\/10\/110.gif\" alt=\"\" class=\"wp-image-3344\"\/><\/figure>\n\n\n\n<p>You can see that the orange headline repeats itself when you switch pages.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"281\" height=\"420\" src=\"https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2020\/10\/111.gif\" alt=\"\" class=\"wp-image-3345\"\/><\/figure>\n\n\n\n<p>This isn&#8217;t an &#8220;amazing&#8221; technique, but it&#8217;s a summary of everyday problems at work.You might use it a lot, but if you could save a little bit of time and effort every time, it would be great.I also hope you can inspire us with some better techniques, thank you!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Many people use Excel with ease, but when it need to pr &#8230; <a title=\"Print Excel sheets is no longer a hassle\" class=\"read-more\" href=\"https:\/\/owa.sodexo-cn.com\/blog\/?p=3348\" aria-label=\"\u9605\u8bfb Print Excel sheets is no longer a hassle\">\u9605\u8bfb\u66f4\u591a<\/a><\/p>\n","protected":false},"author":10,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-3348","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"views":1913,"_links":{"self":[{"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/3348","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\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3348"}],"version-history":[{"count":1,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/3348\/revisions"}],"predecessor-version":[{"id":3350,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/3348\/revisions\/3350"}],"wp:attachment":[{"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3348"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3348"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3348"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}