{"id":18749,"date":"2013-05-08T15:58:59","date_gmt":"2013-05-08T10:28:59","guid":{"rendered":"http:\/\/vskills.in\/certification\/tutorial\/?p=18749"},"modified":"2024-04-12T14:24:20","modified_gmt":"2024-04-12T08:54:20","slug":"print-data","status":"publish","type":"page","link":"https:\/\/www.vskills.in\/certification\/tutorial\/print-data\/","title":{"rendered":"Print Data"},"content":{"rendered":"<h4><strong>Print Data<\/strong><\/h4>\n<p>Excel automatically prints worksheets without cell gridlines. However, it may be easier for some readers to view data on paper with the cell gridlines in place.<\/p>\n<p>If you&#8217;re in print preview, click\u00a0Setup. If you&#8217;re in normal view, on the\u00a0File\u00a0menu, click\u00a0Page Setup. Click the\u00a0Sheet\u00a0tab. Under\u00a0Print, select the\u00a0Gridlines\u00a0check box.<\/p>\n<p><b>Note<\/b>\u00a0\u00a0\u00a0\u00a0 It takes more time to print with gridlines turned on. Keep that in mind, if your worksheets are very large, or if you have lots of worksheets to print.<\/p>\n<p><a ref=\"magnificPopup\" href=\"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/077.gif\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-30742\" src=\"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/077-300x151.gif\" alt=\"077\" width=\"300\" height=\"151\" \/><\/a><\/p>\n<p><b>If you click print now you will notice that while it&#8217;s printed out the cells you&#8217;ve selected, it may run to more than one page wide or long<\/b>. You can change this with in Excel 2007 easily.<\/p>\n<p><a ref=\"magnificPopup\" href=\"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/088.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-30743\" src=\"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/088-300x237.jpg\" alt=\"088\" width=\"300\" height=\"237\" srcset=\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/088-300x237.jpg 300w, https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/088.jpg 550w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<h1>Quick Tip: How to format excel spreadsheets to print<\/h1>\n<p><a ref=\"magnificPopup\" href=\"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/066.gif\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-30746\" src=\"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/066-300x235.gif\" alt=\"066\" width=\"300\" height=\"235\" \/><\/a><\/p>\n<p><strong>Steps to formatting an excel file to print:<\/strong><\/p>\n<ul style=\"font-size: 1rem;\">\n<li><span style=\"font-size: 1rem; line-height: 1.714285714;\">Open the excel and if there are multiple worksheets (tabs at the bottom), start with the first one<\/span><\/li>\n<li><span style=\"font-size: 1rem; line-height: 1.714285714;\">If you want everything on the sheet to print, make sure no rows or columns are hidden, and that no filtering is applied.\u00a0 Take a look at the general size and layout of the data and start to determine if it would look better horizontal or vertical, what size paper might work best, and how many pages it might take to layout<\/span><\/li>\n<li><span style=\"font-size: 1rem; line-height: 1.714285714;\">Go to the Page Setup menu, and start with the first tab:<\/span><\/li>\n<li>Page\n<ul>\n<li>Orientation \u2013 is the data wide?\u00a0 Landscape might work better.\u00a0 Tall?\u00a0 Try portrait<\/li>\n<li>Scaling \u2013 I always use the fit to option, if it will fit on one page, great.\u00a0 If not, play with the pages until it makes sense<\/li>\n<li>Paper size \u2013 if 8.5\u00d711\u201d is too small, maybe the data will fit nicely on one legal size page<\/li>\n<\/ul>\n<\/li>\n<li>Margins \u2013 give yourself more room on each page by expanding the margins.\u00a0 Check the boxes to center on the page if you want all the space around the edges to be even when you print<\/li>\n<li>Header\/Footer \u2013 lots of options here, add a page number, or add the worksheet name by doing a custom footer.\u00a0 Note, if the margins are too small, a header or footer may overlap data, so be sure to leave enough margin if you want to use one<\/li>\n<li>Sheet\n<ul>\n<li>Rows to repeat at top \u2013 this is where you can select column headings to print on every page.\u00a0 Helpful if the data will not fit all on one page, so that you know what each column is on the next pages<\/li>\n<li>Gridlines \u2013 do you want the individual cell lines to show up?\u00a0 Sometimes this makes it easier to follow large amounts of data across a page<\/li>\n<li>Page order \u2013 if it will not fit on one page, how is the data to read?\u00a0 I use over, then down most often<\/li>\n<\/ul>\n<\/li>\n<li><span style=\"font-size: 1rem; line-height: 1.714285714;\">Before you hit OK, do the Print Preview and see if the choices you have made make sense.\u00a0 If not, go back to Page Setup and adjust some things.\u00a0 I most often have to adjust the Fit to Pages part.\u00a0 If the text is too small to read on the page, try expanding the number of pages you want it to fit to<\/span><\/li>\n<li><span style=\"font-size: 1rem; line-height: 1.714285714;\">As a last adjustment, you can switch to the Page Layout view and make sure that your page breaks make sense.\u00a0 Move the lines so that sections are divided in logical places, and no blank pages are included<\/span><\/li>\n<\/ul>\n<div class=\"apply\">\n<h3>Apply for MS Excel Certification Now!!<\/h3>\n<p><a href=\"https:\/\/www.vskills.in\/certification\/excel-online-certification-course\" target=\"_blank\" rel=\"noopener\">https:\/\/www.vskills.in\/certification\/excel-online-certification-course<\/a><\/p>\n<h4><a href=\"https:\/\/www.vskills.in\/certification\/tutorial\/certified-excel-2003-professional\/\" target=\"_blank\" rel=\"noopener\"><strong>Back to Tutorial<\/strong><\/a><\/h4>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Print Data Excel automatically prints worksheets without cell gridlines. However, it may be easier for some readers to view data on paper with the cell gridlines in place. If you&#8217;re in print preview, click\u00a0Setup. If you&#8217;re in normal view, on the\u00a0File\u00a0menu, click\u00a0Page Setup. Click the\u00a0Sheet\u00a0tab. Under\u00a0Print, select the\u00a0Gridlines\u00a0check box. Note\u00a0\u00a0\u00a0\u00a0 It takes more time to&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"categories":[47],"tags":[5143],"class_list":["post-18749","page","type-page","status-publish","hentry","category-ms-excel","tag-print-data"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Print Data - Tutorial<\/title>\n<meta name=\"description\" content=\"Print data. Govt of India Certification for Excel\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.vskills.in\/certification\/tutorial\/print-data\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Print Data - Tutorial\" \/>\n<meta property=\"og:description\" content=\"Print data. Govt of India Certification for Excel\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.vskills.in\/certification\/tutorial\/print-data\/\" \/>\n<meta property=\"og:site_name\" content=\"Tutorial\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/vskills.in\/\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-12T08:54:20+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/077-300x151.gif\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/print-data\/\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/print-data\/\",\"name\":\"Print Data - Tutorial\",\"isPartOf\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/print-data\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/print-data\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/077-300x151.gif\",\"datePublished\":\"2013-05-08T10:28:59+00:00\",\"dateModified\":\"2024-04-12T08:54:20+00:00\",\"description\":\"Print data. Govt of India Certification for Excel\",\"breadcrumb\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/print-data\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.vskills.in\/certification\/tutorial\/print-data\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/print-data\/#primaryimage\",\"url\":\"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/077-300x151.gif\",\"contentUrl\":\"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/077-300x151.gif\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/print-data\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Print Data\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#website\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\",\"name\":\"Tutorial\",\"description\":\"Vskills - A initiative in elearning and certification\",\"publisher\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.vskills.in\/certification\/tutorial\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#organization\",\"name\":\"Vskills\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg\",\"contentUrl\":\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg\",\"width\":73,\"height\":55,\"caption\":\"Vskills\"},\"image\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/vskills.in\/\",\"https:\/\/x.com\/vskills_in\",\"https:\/\/www.linkedin.com\/company-beta\/1371554\/\",\"https:\/\/www.youtube.com\/channel\/UCMWnscxPwRF_PqXo9B7q_Tw\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Print Data - Tutorial","description":"Print data. Govt of India Certification for Excel","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.vskills.in\/certification\/tutorial\/print-data\/","og_locale":"en_US","og_type":"article","og_title":"Print Data - Tutorial","og_description":"Print data. Govt of India Certification for Excel","og_url":"https:\/\/www.vskills.in\/certification\/tutorial\/print-data\/","og_site_name":"Tutorial","article_publisher":"https:\/\/www.facebook.com\/vskills.in\/","article_modified_time":"2024-04-12T08:54:20+00:00","og_image":[{"url":"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/077-300x151.gif","type":"","width":"","height":""}],"twitter_misc":{"Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/print-data\/","url":"https:\/\/www.vskills.in\/certification\/tutorial\/print-data\/","name":"Print Data - Tutorial","isPartOf":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/print-data\/#primaryimage"},"image":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/print-data\/#primaryimage"},"thumbnailUrl":"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/077-300x151.gif","datePublished":"2013-05-08T10:28:59+00:00","dateModified":"2024-04-12T08:54:20+00:00","description":"Print data. Govt of India Certification for Excel","breadcrumb":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/print-data\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.vskills.in\/certification\/tutorial\/print-data\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/print-data\/#primaryimage","url":"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/077-300x151.gif","contentUrl":"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/077-300x151.gif"},{"@type":"BreadcrumbList","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/print-data\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.vskills.in\/certification\/tutorial\/"},{"@type":"ListItem","position":2,"name":"Print Data"}]},{"@type":"WebSite","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#website","url":"https:\/\/www.vskills.in\/certification\/tutorial\/","name":"Tutorial","description":"Vskills - A initiative in elearning and certification","publisher":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.vskills.in\/certification\/tutorial\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#organization","name":"Vskills","url":"https:\/\/www.vskills.in\/certification\/tutorial\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/","url":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg","contentUrl":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg","width":73,"height":55,"caption":"Vskills"},"image":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/vskills.in\/","https:\/\/x.com\/vskills_in","https:\/\/www.linkedin.com\/company-beta\/1371554\/","https:\/\/www.youtube.com\/channel\/UCMWnscxPwRF_PqXo9B7q_Tw"]}]}},"_links":{"self":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/18749","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/comments?post=18749"}],"version-history":[{"count":6,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/18749\/revisions"}],"predecessor-version":[{"id":130066,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/18749\/revisions\/130066"}],"wp:attachment":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/media?parent=18749"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/categories?post=18749"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/tags?post=18749"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}