{"id":1874,"date":"2013-01-08T09:48:59","date_gmt":"2013-01-08T09:48:59","guid":{"rendered":"http:\/\/vskills.in\/certification\/tutorial\/?p=1874"},"modified":"2024-04-12T14:31:59","modified_gmt":"2024-04-12T09:01:59","slug":"printing-formatting","status":"publish","type":"page","link":"https:\/\/www.vskills.in\/certification\/tutorial\/printing-formatting\/","title":{"rendered":"Printing and Formatting"},"content":{"rendered":"<p><a class=\"vsc\" href=\"http:\/\/www.vskills.in\/certification\/Certified E-Governance Professional \"><span class=\"vsc-cn\" style=\"text-align: center;\"><span style=\"color: red;\">Certify and Increase Opportunity.<\/span><br \/>\n<span style=\"color: green;\">Be <\/span><br \/>\nGovt. Certified E-Governance Professional<br \/>\n<\/span><\/a><\/p>\n<p>Printing and Formatting<\/p>\n<p><strong>Formatting Cells<\/strong><\/p>\n<p>Formatting can be done in MS-Excel by<\/p>\n<ul>\n<li>Formatting with auto format<\/li>\n<li>Copying format with the format painter button<\/li>\n<li>Format from Toolbar<\/li>\n<\/ul>\n<p>Various options on formatting toolbar are<\/p>\n<ul>\n<li>Merge and Center<\/li>\n<li>Currency Button<\/li>\n<li>Percentage Button<\/li>\n<li>Comma Button<\/li>\n<li>Indent Buttons<\/li>\n<li>Border Buttons<\/li>\n<li>Fill Color<\/li>\n<li>Font Color<\/li>\n<\/ul>\n<p>Various horizontal alignments are<\/p>\n<ul>\n<li>General<\/li>\n<li>Left (Indent)<\/li>\n<li>Center<\/li>\n<li>Right (Indent)<\/li>\n<li>Fill<\/li>\n<li>Justify<\/li>\n<li>Center Across Selection<\/li>\n<li>Distributed (Indent)<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>The Vertical alignment options are<\/p>\n<ul>\n<li>Wrap Text<\/li>\n<li>Shrink to Fit<\/li>\n<li>Merge Cells<\/li>\n<li>Orientation<\/li>\n<\/ul>\n<p><span style=\"text-decoration: underline;\">Conditional Formatting<\/span><br \/>\nMS-Excel provides the feature of Conditional Formatting used to apply format to selected cells based on predefined conditions.<\/p>\n<p><strong>Printing<\/strong><br \/>\nExcel gives you several ways to print a worksheet<\/p>\n<ul>\n<li>Select File, Print.<\/li>\n<li>Press Ctrl+P.<\/li>\n<li>Click the Print button on the Standard toolbar.<\/li>\n<\/ul>\n<p>It offers various options as<\/p>\n<ul>\n<li>Printing Single Worksheet<\/li>\n<li>Printing a Range<\/li>\n<li>Printing a Selection<\/li>\n<li>Printing the Entire Workbook<\/li>\n<li>Set Print Area<\/li>\n<li>Printing Column and Row Headings<\/li>\n<li>Fitting Your Worksheet to a Number of Pages<\/li>\n<\/ul>\n<div class=\"apply\">\n<h3>Apply for E-Governance Certification Now!!<\/h3>\n<p><a href=\"http:\/\/www.vskills.in\/certification\/Certified-E-Governance-Professional\">http:\/\/www.vskills.in\/certification\/Certified-E-Governance-Professional<\/a><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Certify and Increase Opportunity. Be Govt. Certified E-Governance Professional Printing and Formatting Formatting Cells Formatting can be done in MS-Excel by Formatting with auto format Copying format with the format painter button Format from Toolbar Various options on formatting toolbar are Merge and Center Currency Button Percentage Button Comma Button Indent Buttons Border Buttons Fill&#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":[329],"tags":[328,6811,578,581],"class_list":["post-1874","page","type-page","status-publish","hentry","category-e-governance","tag-e-governance-certification","tag-e-governance-professional","tag-formulae","tag-printing-formatting"],"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 - Tutorial<\/title>\n<meta name=\"description\" content=\"Printing and Formatting. Govt of India Certification for e-governance. Get Certified and improve employability. Certification assesses candidates in e-governance concepts.\" \/>\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-formatting\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Printing and Formatting - Tutorial\" \/>\n<meta property=\"og:description\" content=\"Printing and Formatting. Govt of India Certification for e-governance. Get Certified and improve employability. Certification assesses candidates in e-governance concepts.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.vskills.in\/certification\/tutorial\/printing-formatting\/\" \/>\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:59+00:00\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\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-formatting\/\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/printing-formatting\/\",\"name\":\"Printing and Formatting - Tutorial\",\"isPartOf\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#website\"},\"datePublished\":\"2013-01-08T09:48:59+00:00\",\"dateModified\":\"2024-04-12T09:01:59+00:00\",\"description\":\"Printing and Formatting. Govt of India Certification for e-governance. Get Certified and improve employability. Certification assesses candidates in e-governance concepts.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/printing-formatting\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.vskills.in\/certification\/tutorial\/printing-formatting\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/printing-formatting\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Printing and Formatting\"}]},{\"@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 - Tutorial","description":"Printing and Formatting. Govt of India Certification for e-governance. Get Certified and improve employability. Certification assesses candidates in e-governance concepts.","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-formatting\/","og_locale":"en_US","og_type":"article","og_title":"Printing and Formatting - Tutorial","og_description":"Printing and Formatting. Govt of India Certification for e-governance. Get Certified and improve employability. Certification assesses candidates in e-governance concepts.","og_url":"https:\/\/www.vskills.in\/certification\/tutorial\/printing-formatting\/","og_site_name":"Tutorial","article_publisher":"https:\/\/www.facebook.com\/vskills.in\/","article_modified_time":"2024-04-12T09:01:59+00:00","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/printing-formatting\/","url":"https:\/\/www.vskills.in\/certification\/tutorial\/printing-formatting\/","name":"Printing and Formatting - Tutorial","isPartOf":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#website"},"datePublished":"2013-01-08T09:48:59+00:00","dateModified":"2024-04-12T09:01:59+00:00","description":"Printing and Formatting. Govt of India Certification for e-governance. Get Certified and improve employability. Certification assesses candidates in e-governance concepts.","breadcrumb":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/printing-formatting\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.vskills.in\/certification\/tutorial\/printing-formatting\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/printing-formatting\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.vskills.in\/certification\/tutorial\/"},{"@type":"ListItem","position":2,"name":"Printing and Formatting"}]},{"@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\/1874","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=1874"}],"version-history":[{"count":4,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/1874\/revisions"}],"predecessor-version":[{"id":66009,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/1874\/revisions\/66009"}],"wp:attachment":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/media?parent=1874"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/categories?post=1874"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/tags?post=1874"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}