{"id":18735,"date":"2013-05-08T15:56:18","date_gmt":"2013-05-08T10:26:18","guid":{"rendered":"http:\/\/vskills.in\/certification\/tutorial\/?p=18735"},"modified":"2024-04-12T14:24:19","modified_gmt":"2024-04-12T08:54:19","slug":"apply-and-modify-cell-formats","status":"publish","type":"page","link":"https:\/\/www.vskills.in\/certification\/tutorial\/apply-and-modify-cell-formats\/","title":{"rendered":"Apply and Modify Cell Formats"},"content":{"rendered":"<h4><strong>Apply and Modify Cell Formats<\/strong><\/h4>\n<p>You can use the\u00a0Format Cells\u00a0window to apply the following cell formatting to cells and worksheets:<\/p>\n<ul>\n<li>Leaders between words and values<\/li>\n<li>Number format<\/li>\n<li>Alignment of the cell or table in the object (left, center, or right)<\/li>\n<li>Font format<\/li>\n<li>Borders around rows, columns, and cells<\/li>\n<li>Patterns in the cell<\/li>\n<li>Protection to prevent cells from being edited<\/li>\n<\/ul>\n<h4>Formatting Toolbar<\/h4>\n<p><a ref=\"magnificPopup\" href=\"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/format_toolbar.gif\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-30683\" src=\"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/format_toolbar-300x82.gif\" alt=\"format_toolbar\" width=\"300\" height=\"82\" \/><\/a><\/p>\n<p>The contents of a highlighted cell can be formatted in many ways. Font and cell attributes can be added from shortcut buttons on the formatting bar. If this toolbar is not already visible on the screen, select\u00a0<strong>View &gt; Toolbars &gt; Formatting<\/strong>\u00a0from the menu bar.<\/p>\n<p><a ref=\"magnificPopup\" href=\"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/format_cells.gif\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/format_cells-300x284.gif\" alt=\"format_cells\" width=\"300\" height=\"284\" \/><\/a><\/p>\n<h4>Format Cells Dialog Box<\/h4>\n<p>For a complete list of formatting options, right-click on the highlighted cells and choose\u00a0<strong>Format Cells<\/strong>\u00a0from the shortcut menu or select\u00a0<strong>Format &gt; Cells<\/strong>\u00a0from the menu bar.<\/p>\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>Apply and Modify Cell Formats You can use the\u00a0Format Cells\u00a0window to apply the following cell formatting to cells and worksheets: Leaders between words and values Number format Alignment of the cell or table in the object (left, center, or right) Font format Borders around rows, columns, and cells Patterns in the cell Protection to prevent&#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":[5122],"class_list":["post-18735","page","type-page","status-publish","hentry","category-ms-excel","tag-apply-and-modify-cell-formats"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Apply and Modify Cell Formats - Tutorial<\/title>\n<meta name=\"description\" content=\"Apply and modify cell formats. 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\/apply-and-modify-cell-formats\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Apply and Modify Cell Formats - Tutorial\" \/>\n<meta property=\"og:description\" content=\"Apply and modify cell formats. Govt of India Certification for Excel\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.vskills.in\/certification\/tutorial\/apply-and-modify-cell-formats\/\" \/>\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:19+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/format_toolbar-300x82.gif\" \/>\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\/apply-and-modify-cell-formats\/\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/apply-and-modify-cell-formats\/\",\"name\":\"Apply and Modify Cell Formats - Tutorial\",\"isPartOf\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/apply-and-modify-cell-formats\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/apply-and-modify-cell-formats\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/format_toolbar-300x82.gif\",\"datePublished\":\"2013-05-08T10:26:18+00:00\",\"dateModified\":\"2024-04-12T08:54:19+00:00\",\"description\":\"Apply and modify cell formats. Govt of India Certification for Excel\",\"breadcrumb\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/apply-and-modify-cell-formats\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.vskills.in\/certification\/tutorial\/apply-and-modify-cell-formats\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/apply-and-modify-cell-formats\/#primaryimage\",\"url\":\"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/format_toolbar-300x82.gif\",\"contentUrl\":\"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/format_toolbar-300x82.gif\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/apply-and-modify-cell-formats\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Apply and Modify Cell Formats\"}]},{\"@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":"Apply and Modify Cell Formats - Tutorial","description":"Apply and modify cell formats. 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\/apply-and-modify-cell-formats\/","og_locale":"en_US","og_type":"article","og_title":"Apply and Modify Cell Formats - Tutorial","og_description":"Apply and modify cell formats. Govt of India Certification for Excel","og_url":"https:\/\/www.vskills.in\/certification\/tutorial\/apply-and-modify-cell-formats\/","og_site_name":"Tutorial","article_publisher":"https:\/\/www.facebook.com\/vskills.in\/","article_modified_time":"2024-04-12T08:54:19+00:00","og_image":[{"url":"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/format_toolbar-300x82.gif","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\/apply-and-modify-cell-formats\/","url":"https:\/\/www.vskills.in\/certification\/tutorial\/apply-and-modify-cell-formats\/","name":"Apply and Modify Cell Formats - Tutorial","isPartOf":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/apply-and-modify-cell-formats\/#primaryimage"},"image":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/apply-and-modify-cell-formats\/#primaryimage"},"thumbnailUrl":"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/format_toolbar-300x82.gif","datePublished":"2013-05-08T10:26:18+00:00","dateModified":"2024-04-12T08:54:19+00:00","description":"Apply and modify cell formats. Govt of India Certification for Excel","breadcrumb":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/apply-and-modify-cell-formats\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.vskills.in\/certification\/tutorial\/apply-and-modify-cell-formats\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/apply-and-modify-cell-formats\/#primaryimage","url":"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/format_toolbar-300x82.gif","contentUrl":"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/format_toolbar-300x82.gif"},{"@type":"BreadcrumbList","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/apply-and-modify-cell-formats\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.vskills.in\/certification\/tutorial\/"},{"@type":"ListItem","position":2,"name":"Apply and Modify Cell Formats"}]},{"@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\/18735","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=18735"}],"version-history":[{"count":6,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/18735\/revisions"}],"predecessor-version":[{"id":130042,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/18735\/revisions\/130042"}],"wp:attachment":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/media?parent=18735"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/categories?post=18735"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/tags?post=18735"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}