{"id":2864,"date":"2018-02-01T15:37:38","date_gmt":"2018-02-01T15:37:38","guid":{"rendered":"http:\/\/isophal.info\/?p=2864"},"modified":"2018-02-02T01:15:46","modified_gmt":"2018-02-02T01:15:46","slug":"%e1%9e%80%e1%9e%b6%e1%9e%9a%e1%9e%94%e1%9f%92%e1%9e%9a%e1%9f%81%e1%9e%b8%e1%9e%94%e1%9f%92%e1%9e%9a%e1%9e%b6%e1%9e%9f%e1%9f%8b%e2%80%8b-merge-wrap-borders-and-shade-and-apply-formatting","status":"publish","type":"post","link":"https:\/\/isophal.com\/news\/2018\/02\/01\/2864.html\/","title":{"rendered":"\u1780\u17b6\u179a\u1794\u17d2\u179a\u17c1\u17b8\u1794\u17d2\u179a\u17b6\u179f\u17cb\u200b Merge &#038; Wrap, Borders and Shade, and Apply Formatting"},"content":{"rendered":"<p><strong>\u1780\u17d2\u178f\u17c4\u1794 \u1793\u17b7\u1784 \u1796\u1784\u17d2\u179a\u17bd\u1789\u17a2\u178f\u17d2\u1790\u1794\u1791 (Wrap Text and Shrink to fit)<\/strong><\/p>\n<p>\u1794\u17d2\u179a\u179f\u17b7\u1793\u1794\u17be \u17a2\u178f\u17d2\u1790\u1794\u1791\u1792\u17c6\u1796\u17c1\u1780 \u1798\u17b7\u1793\u179b\u17d2\u1798\u1798\u1793\u17b9\u1784\u1791\u17c6\u17a0\u17c6 column\u200b\u200b \u17a0\u17be\u1799\u1785\u1784\u17cb\u1787\u17c0\u179f\u179c\u17b6\u1784\u200b \u1798\u17b7\u1793\u17b2\u17d2\u1799\u17a2\u178f\u17d2\u1790\u1794\u1791\u17a0\u17ca\u17b6\u179a\u1791\u17c5\u200b\u1794\u17d2\u179a\u17a2\u1794\u17cb cells \u178a\u17c2\u179b \u1793\u17c5\u1787\u17b6\u1794\u17cb\u200b \u1799\u17be\u1784\u17a2\u17b6\u1785\u1794\u17d2\u179a\u17be Wrap Text\u200b \u17ac Shrink to fit\u200b \u178a\u17be\u1798\u17d2\u1794\u17b8\u1794\u1789\u17d2\u1785\u17bc\u179b\u17a2\u178f\u17d2\u1790\u1794\u1791\u17d4<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2867\" src=\"http:\/\/isophal.info\/wp-content\/uploads\/2018\/02\/wrap-text.jpg\" alt=\"\" width=\"560\" height=\"394\" srcset=\"https:\/\/isophal.com\/news\/wp-content\/uploads\/2018\/02\/wrap-text.jpg 560w, https:\/\/isophal.com\/news\/wp-content\/uploads\/2018\/02\/wrap-text-300x211.jpg 300w\" sizes=\"auto, (max-width: 560px) 100vw, 560px\" \/><\/p>\n<p><strong>Borders and Shades:<\/strong><\/p>\n<p><strong>Borders<\/strong><\/p>\n<p>Excel 2016 \u17a2\u1793\u17bb\u1789\u17d2\u1789\u17b6\u178f\u17a2\u17c4\u1799\u17a2\u17d2\u1793\u1780\u17a2\u17b6\u1785\u178a\u17b6\u1780\u17cb Border \u1791\u17c5\u179b\u17be Cell \u1793\u17b8\u1798\u17bd\u1799\u17d7\u1794\u17b6\u1793\u1795\u1784\u178a\u17c2\u179a \u17d4 \u178a\u17be\u1798\u17d2\u1794\u17b8\u1792\u17d2\u179c\u17be\u1780\u17b6\u179a\u178a\u17b6\u1780\u17cb \u179f\u17ca\u17bb\u1798\u1796\u17d0\u1791\u17d2\u1792\u1787\u17bb\u17c6\u179c\u17b7\u1789 Cell \u1799\u17be\u1784\u178f\u17d2\u179a\u17bc\u179c\u17a2\u1793\u17bb\u179c\u178f\u17d2\u178f\u178f\u17b6\u1798\u1787\u17c6\u17a0\u17b6\u1793\u178a\u17bc\u1785\u1781\u17b6\u1784\u1780\u17d2\u179a\u17c4\u1798\u17d6<br \/>\n\u1785\u17bb\u1785 Mouse \u179f\u17d2\u178f\u17b6\u17c6 \u00bb\u00a0\u1787\u17d2\u179a\u17be\u179f\u1799\u1780 Format cells \u00bb \u1787\u17d2\u179a\u17be\u179f\u1799\u1780 Border Tab\u00a0\u00bb Select Border Style<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2868\" src=\"http:\/\/isophal.info\/wp-content\/uploads\/2018\/02\/BorderTab.jpg\" alt=\"\" width=\"560\" height=\"414\" srcset=\"https:\/\/isophal.com\/news\/wp-content\/uploads\/2018\/02\/BorderTab.jpg 560w, https:\/\/isophal.com\/news\/wp-content\/uploads\/2018\/02\/BorderTab-300x222.jpg 300w\" sizes=\"auto, (max-width: 560px) 100vw, 560px\" \/><\/p>\n<p>\u1794\u1793\u17d2\u1791\u17b6\u1794\u17cb\u1798\u1780 \u17a2\u17d2\u1793\u1780\u17a2\u17b6\u1785\u178a\u17b6\u1780\u17cb Border \u178f\u17b6\u1798\u179c\u17b7\u1792\u17b8\u1798\u17bd\u1799\u1794\u17c2\u1794\u1791\u17c0\u178f\u1782\u17ba \u1787\u17d2\u179a\u17be\u179f\u1799\u1780 Home Tab\u00a0\u00bb Font group\u00a0\u00bb Apply Borders<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2869\" src=\"http:\/\/isophal.info\/wp-content\/uploads\/2018\/02\/allBorderTab.jpg\" alt=\"\" width=\"560\" height=\"389\" srcset=\"https:\/\/isophal.com\/news\/wp-content\/uploads\/2018\/02\/allBorderTab.jpg 560w, https:\/\/isophal.com\/news\/wp-content\/uploads\/2018\/02\/allBorderTab-300x208.jpg 300w\" sizes=\"auto, (max-width: 560px) 100vw, 560px\" \/><\/p>\n<p><strong>Shades<\/strong><\/p>\n<p>\u17a2\u17d2\u1793\u1780\u17a2\u17b6\u1785\u1792\u17d2\u179c\u17be\u1780\u17b6\u179a\u178a\u17b6\u1780\u17cb\u1793\u17bc\u179c Shading \u1791\u17c5\u1780\u17b6\u1793\u17cbCell\u200b \u1793\u17b8\u1798\u17bd\u1799\u17d7\u1794\u17b6\u1793\u1795\u1784\u178a\u17c2\u179a\u178f\u17b6\u1798\u179c\u17b8\u1792\u17b8\u1784\u17b6\u1799\u178a\u17bc\u1785\u1781\u17b6\u1784\u1780\u17d2\u179a\u17c4\u1798: \u1785\u17bc\u179b\u1791\u17c5\u1780\u17b6\u1793\u17cb Home Tab\u00a0\u00bb Font Group\u00a0\u00bb Select the color<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2870\" src=\"http:\/\/isophal.info\/wp-content\/uploads\/2018\/02\/select_color.jpg\" alt=\"\" width=\"560\" height=\"361\" srcset=\"https:\/\/isophal.com\/news\/wp-content\/uploads\/2018\/02\/select_color.jpg 560w, https:\/\/isophal.com\/news\/wp-content\/uploads\/2018\/02\/select_color-300x193.jpg 300w\" sizes=\"auto, (max-width: 560px) 100vw, 560px\" \/><\/p>\n<p><strong>Format Cells<\/strong><\/p>\n<p>\u1793\u17c5\u1780\u17d2\u1793\u17bb\u1784 Excel 2016 \u1799\u17be\u1784\u17a2\u17b6\u1785\u1792\u17d2\u179c\u17be\u1780\u17b6\u179a\u178a\u17b6\u1780\u17cb\u1793\u17bc\u179cFormat \u1791\u17c5\u1780\u17b6\u1793\u17cb Cell \u17ac \u1787\u17bd\u179a\u1793\u17c3 Cell (Range of cell) \u178a\u17c4\u1799\u1782\u17d2\u179a\u17b6\u1793\u17cb\u178f\u17c2\u1792\u17d2\u179c\u17be\u178f\u17b6\u1798\u1787\u17c6\u17a0\u17b6\u1793\u178a\u17bc\u1785\u1781\u17b6\u1784\u1780\u17d2\u179a\u17c4\u1798\u17d6<\/p>\n<p>\u1785\u17bb\u1785 Mouse \u179f\u17d2\u178f\u17b6\u17c6 (Right Click)\u00a0\u00bb Format cells \u00bb Select the tab\u200b \u1794\u1793\u17d2\u1791\u17b6\u1794\u17cb\u1798\u1780\u1799\u17be\u1784\u1793\u17b9\u1784\u1783\u17be\u1789\u1798\u17b6\u1793 tab \u1787\u17b6\u1785\u17d2\u179a\u17be\u1793\u178a\u17c2\u179b\u17a2\u17b6\u1785\u1787\u17d2\u179a\u17be\u179f\u179a\u17be\u179f\u1794\u17b6\u1793\u1798\u17b6\u1793\u1794\u1784\u17d2\u17a0\u17b6\u1789\u178a\u17bc\u1785\u179a\u17bc\u1794\u1781\u17b6\u1784\u1780\u17d2\u179a\u17c4\u1798\u17d6<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-2871 size-full\" src=\"http:\/\/isophal.info\/wp-content\/uploads\/2018\/02\/Format_Cells.jpg\" alt=\"\" width=\"560\" height=\"418\" srcset=\"https:\/\/isophal.com\/news\/wp-content\/uploads\/2018\/02\/Format_Cells.jpg 560w, https:\/\/isophal.com\/news\/wp-content\/uploads\/2018\/02\/Format_Cells-300x224.jpg 300w\" sizes=\"auto, (max-width: 560px) 100vw, 560px\" \/><br \/>\n\u1787\u1798\u17d2\u179a\u17be\u179f\u1795\u17d2\u179f\u17c1\u1784\u1791\u17c0\u178f\u178a\u17c2\u179b\u17a2\u17d2\u1793\u1780\u17a2\u17b6\u1785\u1792\u17d2\u179c\u17be\u1780\u17b6\u179a \u178a\u17b6\u1780\u17cb\u1793\u17bc\u179c Background\u17d6<\/p>\n<ul>\n<li>Number: \u1780\u17b6\u179a\u1780\u17c6\u178e\u178f\u17cb Format of cell \u178a\u17c4\u1799\u17a2\u17b6\u179f\u17d2\u179a\u17d0\u1799\u1791\u17c5\u1793\u17b9\u1784 cell content<\/li>\n<li>Alignment: \u1780\u17b6\u179a\u1780\u17c6\u178e\u178f\u17cb alignment text<\/li>\n<li>Font: \u1780\u17b6\u179a\u1780\u17c6\u178e\u178f\u17cb\u1791\u17c5\u179b\u17be\u1794\u17d2\u179a\u1797\u17c1\u1791\u1793\u17c3 Font Style<\/li>\n<li>Border: \u1780\u17b6\u179a\u1780\u17c6\u178e\u178f\u17cb\u179b\u17be Border\u179a\u1794\u179f\u17cb Cell \u1793\u17b8\u1798\u17bd\u1799\u17d7<\/li>\n<li>Fill: \u1780\u17c6\u178e\u178f\u17cb\u1791\u17c5\u179b\u17be\u1780\u17b6\u179a\u1785\u17b6\u1780\u17cb\u1796\u178e\u17cc\u1791\u17c5\u179b\u17be Cell \u1793\u17b8\u1798\u17bd\u1799\u17d7<\/li>\n<li>Protection: \u1780\u17b6\u179a\u1780\u17c6\u178e\u178f\u17cb cell protection<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>\u1780\u17d2\u178f\u17c4\u1794 \u1793\u17b7\u1784 \u1796\u1784\u17d2\u179a\u17bd\u1789\u17a2\u178f\u17d2\u1790\u1794\u1791 (Wrap Text and Shrink&hellip;<\/p>\n","protected":false},"author":1,"featured_media":2867,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[52,59],"tags":[],"class_list":["post-2864","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-2013","category-microsoft-office"],"_links":{"self":[{"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/posts\/2864","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/comments?post=2864"}],"version-history":[{"count":4,"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/posts\/2864\/revisions"}],"predecessor-version":[{"id":2873,"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/posts\/2864\/revisions\/2873"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/media\/2867"}],"wp:attachment":[{"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/media?parent=2864"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/categories?post=2864"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/tags?post=2864"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}