{"id":18738,"date":"2013-05-08T15:57:10","date_gmt":"2013-05-08T10:27:10","guid":{"rendered":"http:\/\/vskills.in\/certification\/tutorial\/?p=18738"},"modified":"2024-04-12T14:24:19","modified_gmt":"2024-04-12T08:54:19","slug":"format-worksheets","status":"publish","type":"page","link":"https:\/\/www.vskills.in\/certification\/tutorial\/format-worksheets\/","title":{"rendered":"Format Worksheets"},"content":{"rendered":"

Format Worksheets<\/strong><\/h4>\n

Apply cell borders<\/b><\/p>\n

    \n
  1. Select the cell or range of cells that you want to add a border to.<\/li>\n<\/ol>\n

    Tip<\/b>\u00a0\u00a0\u00a0\u00a0To quickly select the whole worksheet, click the\u00a0Select All<\/b>\u00a0button.<\/p>\n

    \"ZA010048465<\/a><\/p>\n

    2.On the\u00a0Home<\/b>\u00a0tab, in the\u00a0Font<\/b>\u00a0group, click the arrow next to\u00a0Borders\"ZA010180584<\/a><\/b>\u00a0, and then click the border style that you want.<\/p>\n

    \"ZA101863459<\/a><\/p>\n

    Tip<\/b>\u00a0\u00a0\u00a0\u00a0The\u00a0Borders<\/b>\u00a0button displays the most recently used border style. You can click the\u00a0Borders<\/b>\u00a0button (not the arrow) to apply that style.<\/p>\n

    2. Change text color and alignment<\/b><\/p>\n

      \n
    1. Select the cell or range of cells that contain (or will contain) the text that you want to format. You can also select one or more portions of the text within a cell and apply different text colors to those sections.<\/li>\n
    2. To change the color of text in the selected cells, on the\u00a0Home<\/b>\u00a0tab, in the\u00a0Font<\/b>\u00a0group, click the arrow next to\u00a0Font Color<\/b>\u00a0, and then under\u00a0Theme Colors<\/b>\u00a0or\u00a0Standard Colors<\/b>, click the color that you want to use.<\/li>\n<\/ol>\n

      Note<\/b>\u00a0\u00a0\u00a0\u00a0To apply a color other than the available theme colors and standard colors, click\u00a0More Colors<\/b>, and then define the color that you want to use on the\u00a0Standard<\/b>\u00a0tab or\u00a0Custom<\/b>\u00a0tab of theColors<\/b>\u00a0dialog box<\/p>\n

      3.To change the alignment of the text in the selected cells, on the\u00a0Home<\/b>\u00a0tab, in the\u00a0Alignment<\/b>group, click the alignment option that you want.<\/p>\n

      \"ZA010371859<\/a><\/p>\n

      For example, to change the horizontal alignment of cell contents, click\u00a0Align Text Left\u00a0,\u00a0\"ZA010180315\"<\/a>Center\"ZA010180315\"<\/a>\u00a0, or\u00a0Align Text Right\u00a0\"ZA010181292<\/a>.<\/p>\n

      Apply cell shading<\/b><\/p>\n

      \u00a0<\/b>Select the cell or range of cells that you want to apply cell shading to.<\/span><\/p>\n

        \n
      1. \n
          \n
        1. On the\u00a0Home<\/b>\u00a0tab, in the\u00a0Font<\/b>\u00a0group, click the arrow next to\u00a0Fill Color<\/b>\u00a0, and then underTheme Colors<\/b>\u00a0or\u00a0Standard Colors<\/b>, click the color that you want.<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n
          \n

          Apply for MS Excel Certification Now!!<\/h3>\n

          https:\/\/www.vskills.in\/certification\/excel-online-certification-course<\/a><\/p>\n

          Back to Tutorial<\/strong><\/a><\/h4>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

          Format Worksheets Apply cell borders Select the cell or range of cells that you want to add a border to. Tip\u00a0\u00a0\u00a0\u00a0To quickly select the whole worksheet, click the\u00a0Select All\u00a0button. 2.On the\u00a0Home\u00a0tab, in the\u00a0Font\u00a0group, click the arrow next to\u00a0Borders\u00a0, and then click the border style that you want. Tip\u00a0\u00a0\u00a0\u00a0The\u00a0Borders\u00a0button displays the most recently used border style….<\/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":[4495,4494],"class_list":["post-18738","page","type-page","status-publish","hentry","category-ms-excel","tag-alignment","tag-format-worksheets"],"acf":[],"yoast_head":"\nFormat Worksheets - Tutorial<\/title>\n<meta name=\"description\" content=\"Format worksheets. 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\/format-worksheets\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Format Worksheets - Tutorial\" \/>\n<meta property=\"og:description\" content=\"Format worksheets. Govt of India Certification for Excel\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.vskills.in\/certification\/tutorial\/format-worksheets\/\" \/>\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\/ZA010048465-1.gif\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 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\/format-worksheets\/\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/format-worksheets\/\",\"name\":\"Format Worksheets - Tutorial\",\"isPartOf\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/format-worksheets\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/format-worksheets\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/ZA010048465-1.gif\",\"datePublished\":\"2013-05-08T10:27:10+00:00\",\"dateModified\":\"2024-04-12T08:54:19+00:00\",\"description\":\"Format worksheets. Govt of India Certification for Excel\",\"breadcrumb\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/format-worksheets\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.vskills.in\/certification\/tutorial\/format-worksheets\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/format-worksheets\/#primaryimage\",\"url\":\"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/ZA010048465-1.gif\",\"contentUrl\":\"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/ZA010048465-1.gif\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/format-worksheets\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Format Worksheets\"}]},{\"@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":"Format Worksheets - Tutorial","description":"Format worksheets. 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\/format-worksheets\/","og_locale":"en_US","og_type":"article","og_title":"Format Worksheets - Tutorial","og_description":"Format worksheets. Govt of India Certification for Excel","og_url":"https:\/\/www.vskills.in\/certification\/tutorial\/format-worksheets\/","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\/ZA010048465-1.gif","type":"","width":"","height":""}],"twitter_misc":{"Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/format-worksheets\/","url":"https:\/\/www.vskills.in\/certification\/tutorial\/format-worksheets\/","name":"Format Worksheets - Tutorial","isPartOf":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/format-worksheets\/#primaryimage"},"image":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/format-worksheets\/#primaryimage"},"thumbnailUrl":"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/ZA010048465-1.gif","datePublished":"2013-05-08T10:27:10+00:00","dateModified":"2024-04-12T08:54:19+00:00","description":"Format worksheets. Govt of India Certification for Excel","breadcrumb":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/format-worksheets\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.vskills.in\/certification\/tutorial\/format-worksheets\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/format-worksheets\/#primaryimage","url":"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/ZA010048465-1.gif","contentUrl":"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/ZA010048465-1.gif"},{"@type":"BreadcrumbList","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/format-worksheets\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.vskills.in\/certification\/tutorial\/"},{"@type":"ListItem","position":2,"name":"Format Worksheets"}]},{"@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\/18738","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=18738"}],"version-history":[{"count":6,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/18738\/revisions"}],"predecessor-version":[{"id":130050,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/18738\/revisions\/130050"}],"wp:attachment":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/media?parent=18738"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/categories?post=18738"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/tags?post=18738"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}