{"id":18522,"date":"2016-10-26T16:59:36","date_gmt":"2016-10-26T16:59:36","guid":{"rendered":"http:\/\/www.oracletutoring.ca\/blog\/?p=18522"},"modified":"2016-10-26T16:59:36","modified_gmt":"2016-10-26T16:59:36","slug":"spreadsheets-how-to-border-a-range-of-cells-in-excel","status":"publish","type":"post","link":"https:\/\/www.oracletutoring.ca\/blog\/spreadsheets-how-to-border-a-range-of-cells-in-excel\/","title":{"rendered":"Spreadsheets: How to border a range of cells in Excel"},"content":{"rendered":"

The tutor tells how to set a border around a selected area in Excel.<\/h1>\n

Here’s how:<\/p>\n

    \n
  1. \nSelect the area around which you want a border, then right click.<\/li>\n
  2. \nYou’ll see a toolbar and a menu. On the toolbar, find the icon that’s a square divided in four. Click the downward arrow beside it.<\/li>\n
  3. \nA dropdown menu will appear: at the bottom, click More Borders…<\/li>\n
  4. \nIn the pane that appears, you can select the style, thickness, color, etc, that you want. See next step for important info.<\/li>\n
  5. In my experience, the order in which you set the options matters: For best results, select the style, then the color, then the outline, then OK.<\/span> Otherwise, the border may not show the color, etc, that you desire.<\/li>\n<\/ol>\n

    HTH:)<\/p>\n

    Jack of Oracle Tutoring by Jack and Diane,<\/a> Campbell River, BC.<\/p>\n","protected":false},"excerpt":{"rendered":"

    The tutor tells how to set a border around a selected area in Excel. Here’s how: Select the area around which you want a border, then right click. You’ll see a toolbar and a menu. On the toolbar, find the …<\/p>\n

    Spreadsheets: How to border a range of cells in Excel<\/span> Read More »<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[371,1583,1009,1065],"tags":[1990,1989],"class_list":["post-18522","post","type-post","status-publish","format-standard","hentry","category-business","category-excel","category-home-computer-use","category-spreadsheets","tag-how-to-border-a-selection-in-exel","tag-how-to-set-a-border-in-excel"],"_links":{"self":[{"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/posts\/18522","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/comments?post=18522"}],"version-history":[{"count":8,"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/posts\/18522\/revisions"}],"predecessor-version":[{"id":18530,"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/posts\/18522\/revisions\/18530"}],"wp:attachment":[{"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/media?parent=18522"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/categories?post=18522"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/tags?post=18522"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}