{"id":112226,"date":"2021-03-16T17:38:28","date_gmt":"2021-03-16T12:08:28","guid":{"rendered":"https:\/\/www.vskills.in\/certification\/tutorial\/?page_id=112226"},"modified":"2024-04-12T14:31:48","modified_gmt":"2024-04-12T09:01:48","slug":"printing-and-formatting-in-excel","status":"publish","type":"page","link":"https:\/\/www.vskills.in\/certification\/tutorial\/printing-and-formatting-in-excel\/","title":{"rendered":"Printing and Formatting in excel"},"content":{"rendered":"\n<p><strong>Page Setup<\/strong><\/p>\n\n\n\n<p>It is in file menu, for page setup options in tabs page, margins, header\/footer, and sheet.<\/p>\n\n\n\n<p>Various option in this tab are<\/p>\n\n\n\n<p>Orientation \u2013For print orientation, portrait (vertical), this is default, or landscape (horizontal).<\/p>\n\n\n\n<p>Paper Size \u2013 Default size is Letter (8.5&#215;11), but other options like Legal A4, A5 are given.<\/p>\n\n\n\n<p>Scaling &#8211; Scale down or up the text to print as per need or fit to content to print in given sheets<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"http:\/\/www.vskills.in\/lms\/wp-content\/uploads\/2016\/05\/printing-and-formatting-in-excel.jpg\" alt=\"printing-and-formatting-in-excel\" class=\"wp-image-18919\"\/><\/figure><\/div>\n\n\n\n<p>Margins &#8211; It configures margins which are empty spaces around the page. Top and bottom margins default to 1&#8243; and left and right margins to 0.75\u201d which can be changed. Inch is the default measure.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"http:\/\/www.vskills.in\/lms\/wp-content\/uploads\/2016\/05\/printing-and-formatting-in-excel-01.jpg\" alt=\"printing-and-formatting-in-excel-01\" class=\"wp-image-18918\"\/><\/figure><\/div>\n\n\n\n<p><strong>Printing<\/strong><\/p>\n\n\n\n<p>Worksheet is printed by clicking print option in file menu or \u201cCtrl+P\u201d keys or click print button. <strong>Print Dialog box<\/strong> &#8211; The print dialog box offers various options as<\/p>\n\n\n\n<p>Name \u2013 It selects printer to print on, else select from drop down list if any other.<\/p>\n\n\n\n<p>Copies &#8211; Specify the number of copies to print. Collation for multiple copies is also given.<\/p>\n\n\n\n<p>Print Range \u2013 Select to print all or specific pages of the worksheet<\/p>\n\n\n\n<p>Print What \u2013 Option to print a selected text or active worksheet or all worksheets is given.<\/p>\n\n\n\n<p><strong>Print Area<\/strong><\/p>\n\n\n\n<p>The print area feature is used to select an area on the worksheet to print. It is done by selecting cells to print then click set print area in print area drop down list of file menu. A dashed line border appears around the print area and to remove the print area, click file, print area, and clear print area.<\/p>\n\n\n\n<p>Printing Column and Row Headings \u2013 Sometimes row or column headings in top row or left column is to be repeated on all pages of print so, the steps are &#8211;<\/p>\n\n\n\n<p>Click page setup in file menu and select the sheet tab.<\/p>\n\n\n\n<p>Click in \u201crows to repeat at top\u201d or \u201ccolumns to repeat at left\u201d text box for row or column to repeat. Then, click in worksheet and select and drag to select row or columns and click OK.<\/p>\n\n\n\n<p>To remove the repeated row and columns headings, delete the values in the text box.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Page Setup It is in file menu, for page setup options in tabs page, margins, header\/footer, and sheet. Various option in this tab are Orientation \u2013For print orientation, portrait (vertical), this is default, or landscape (horizontal). Paper Size \u2013 Default size is Letter (8.5&#215;11), but other options like Legal A4, A5 are given. Scaling &#8211;&#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":[],"tags":[],"class_list":["post-112226","page","type-page","status-publish","hentry"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Printing and Formatting in excel - Tutorial<\/title>\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\/printing-and-formatting-in-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Printing and Formatting in excel - Tutorial\" \/>\n<meta property=\"og:description\" content=\"Page Setup It is in file menu, for page setup options in tabs page, margins, header\/footer, and sheet. Various option in this tab are Orientation \u2013For print orientation, portrait (vertical), this is default, or landscape (horizontal). Paper Size \u2013 Default size is Letter (8.5&#215;11), but other options like Legal A4, A5 are given. Scaling &#8211;...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.vskills.in\/certification\/tutorial\/printing-and-formatting-in-excel\/\" \/>\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-12T09:01:48+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.vskills.in\/lms\/wp-content\/uploads\/2016\/05\/printing-and-formatting-in-excel.jpg\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 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\/printing-and-formatting-in-excel\/\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/printing-and-formatting-in-excel\/\",\"name\":\"Printing and Formatting in excel - Tutorial\",\"isPartOf\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/printing-and-formatting-in-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/printing-and-formatting-in-excel\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.vskills.in\/lms\/wp-content\/uploads\/2016\/05\/printing-and-formatting-in-excel.jpg\",\"datePublished\":\"2021-03-16T12:08:28+00:00\",\"dateModified\":\"2024-04-12T09:01:48+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/printing-and-formatting-in-excel\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.vskills.in\/certification\/tutorial\/printing-and-formatting-in-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/printing-and-formatting-in-excel\/#primaryimage\",\"url\":\"http:\/\/www.vskills.in\/lms\/wp-content\/uploads\/2016\/05\/printing-and-formatting-in-excel.jpg\",\"contentUrl\":\"http:\/\/www.vskills.in\/lms\/wp-content\/uploads\/2016\/05\/printing-and-formatting-in-excel.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/printing-and-formatting-in-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Printing and Formatting in excel\"}]},{\"@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":"Printing and Formatting in excel - Tutorial","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\/printing-and-formatting-in-excel\/","og_locale":"en_US","og_type":"article","og_title":"Printing and Formatting in excel - Tutorial","og_description":"Page Setup It is in file menu, for page setup options in tabs page, margins, header\/footer, and sheet. Various option in this tab are Orientation \u2013For print orientation, portrait (vertical), this is default, or landscape (horizontal). Paper Size \u2013 Default size is Letter (8.5&#215;11), but other options like Legal A4, A5 are given. Scaling &#8211;...","og_url":"https:\/\/www.vskills.in\/certification\/tutorial\/printing-and-formatting-in-excel\/","og_site_name":"Tutorial","article_publisher":"https:\/\/www.facebook.com\/vskills.in\/","article_modified_time":"2024-04-12T09:01:48+00:00","og_image":[{"url":"http:\/\/www.vskills.in\/lms\/wp-content\/uploads\/2016\/05\/printing-and-formatting-in-excel.jpg","type":"","width":"","height":""}],"twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/printing-and-formatting-in-excel\/","url":"https:\/\/www.vskills.in\/certification\/tutorial\/printing-and-formatting-in-excel\/","name":"Printing and Formatting in excel - Tutorial","isPartOf":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/printing-and-formatting-in-excel\/#primaryimage"},"image":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/printing-and-formatting-in-excel\/#primaryimage"},"thumbnailUrl":"http:\/\/www.vskills.in\/lms\/wp-content\/uploads\/2016\/05\/printing-and-formatting-in-excel.jpg","datePublished":"2021-03-16T12:08:28+00:00","dateModified":"2024-04-12T09:01:48+00:00","breadcrumb":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/printing-and-formatting-in-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.vskills.in\/certification\/tutorial\/printing-and-formatting-in-excel\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/printing-and-formatting-in-excel\/#primaryimage","url":"http:\/\/www.vskills.in\/lms\/wp-content\/uploads\/2016\/05\/printing-and-formatting-in-excel.jpg","contentUrl":"http:\/\/www.vskills.in\/lms\/wp-content\/uploads\/2016\/05\/printing-and-formatting-in-excel.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/printing-and-formatting-in-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.vskills.in\/certification\/tutorial\/"},{"@type":"ListItem","position":2,"name":"Printing and Formatting in excel"}]},{"@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\/112226","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=112226"}],"version-history":[{"count":1,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/112226\/revisions"}],"predecessor-version":[{"id":112227,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/112226\/revisions\/112227"}],"wp:attachment":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/media?parent=112226"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/categories?post=112226"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/tags?post=112226"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}