{"id":53,"date":"2023-08-21T07:02:28","date_gmt":"2023-08-21T07:02:28","guid":{"rendered":"https:\/\/appspoon.com\/?page_id=53"},"modified":"2023-09-11T13:34:46","modified_gmt":"2023-09-11T13:34:46","slug":"document","status":"publish","type":"page","link":"https:\/\/appspoon.com\/index.php\/document\/","title":{"rendered":"Manual &#038; Usage"},"content":{"rendered":"\n<p class=\"has-large-font-size\">&lt;<strong>Qborder<\/strong>&gt;<\/p>\n\n\n\n<p class=\"has-text-align-left has-medium-font-size\"><strong>Qborder Add-in User Guide<\/strong><\/p>\n\n\n\n<p><\/p>\n\n\n\n<blockquote class=\"wp-block-quote has-text-align-center\">\n<p class=\"has-text-align-center\"><strong>Introduction<\/strong><br>: Qborder is an Excel add-in designed to enhance data differentiation and visualization by automating the data sorting and border addition processes. The following installation and usage guide explains the steps to effectively use the Qborder add-in.<\/p>\n<cite><strong>Caution <\/strong><br><em>: This program was developed and optimized for Microsoft Office 365, and works smoothly with Microsoft Office programs running the PC version of VBA.<\/em><\/cite><\/blockquote>\n\n\n\n<p class=\"has-text-align-left has-medium-font-size\"><strong>Demo (Free) Version Installation and (Paid) Pro Version Purchase<\/strong>:<\/p>\n\n\n\n<div class=\"wp-block-buttons is-layout-flex\">\n<div class=\"wp-block-button is-style-fill\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/drive.google.com\/uc?export=download&amp;id=1ghlxoYpa2CLyz24hxSs7wjQBIeq9LD8n\"><mark style=\"background-color:#000000\" class=\"has-inline-color has-white-color\">Qborder download(Free version)<\/mark><\/a><\/div>\n\n\n<\/div>\n\n\n\n<blockquote class=\"wp-block-quote\">\n<ol>\n<li><strong>Qborder<\/strong> is initially offered as a free demo version. Download the compressed zip file of the<strong> Demo (Free) version<\/strong> and change the file extension to &#8220;.exe&#8221; for installation.<\/li>\n\n\n\n<li>To change to the (paid) <strong>Pro version<\/strong>, visit the website (<a href=\"https:\/\/appspoon.com\/index.php\/product\/qborder\/\">https:\/\/appspoon.com\/index.php\/product\/qborder\/<\/a>) and <em>purchase the <strong>pro version<\/strong> and get a<strong> serial number<\/strong><\/em>.<\/li>\n\n\n\n<li>After obtaining the serial number, click &#8220;<strong>Get Pro Version<\/strong>&#8221; button in the ribbon menu of the Qborder Demo (Free) version in Excel.\n<ul>\n<li><img decoding=\"async\" loading=\"lazy\" width=\"453\" height=\"101\" class=\"wp-image-226\" style=\"width: 400px;\" src=\"https:\/\/appspoon.com\/wp-content\/uploads\/2023\/08\/get_pro_version.png\" alt=\"\" srcset=\"https:\/\/appspoon.com\/wp-content\/uploads\/2023\/08\/get_pro_version.png 453w, https:\/\/appspoon.com\/wp-content\/uploads\/2023\/08\/get_pro_version-300x67.png 300w, https:\/\/appspoon.com\/wp-content\/uploads\/2023\/08\/get_pro_version-416x93.png 416w\" sizes=\"(max-width: 453px) 100vw, 453px\" \/><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Enter the purchased serial number in the &#8220;<strong>your serial number<\/strong>&#8221; field and click the <strong>OK<\/strong> button.\n<ul>\n<li><img decoding=\"async\" loading=\"lazy\" width=\"287\" height=\"220\" class=\"wp-image-230\" style=\"width: 300px;\" src=\"https:\/\/appspoon.com\/wp-content\/uploads\/2023\/08\/user_box.png\" alt=\"\"><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>You can now freely utilize <strong>Qborder <\/strong>as the (paid, permanent version) Pro version.\n<ul>\n<li><img decoding=\"async\" loading=\"lazy\" width=\"452\" height=\"99\" class=\"wp-image-231\" style=\"width: 400px;\" src=\"https:\/\/appspoon.com\/wp-content\/uploads\/2023\/08\/pro_version.png\" alt=\"\" srcset=\"https:\/\/appspoon.com\/wp-content\/uploads\/2023\/08\/pro_version.png 452w, https:\/\/appspoon.com\/wp-content\/uploads\/2023\/08\/pro_version-300x66.png 300w, https:\/\/appspoon.com\/wp-content\/uploads\/2023\/08\/pro_version-416x91.png 416w\" sizes=\"(max-width: 452px) 100vw, 452px\" \/><\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<\/blockquote>\n\n\n\n<div class=\"wp-block-buttons is-layout-flex\">\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link has-black-background-color has-background wp-element-button\" href=\"https:\/\/appspoon.com\/index.php\/product\/qborder\/\"><em><mark style=\"background-color:#000000\" class=\"has-inline-color has-luminous-vivid-amber-color\">Go to product purchase &gt;&gt;<\/mark><\/em><\/a><\/div>\n<\/div>\n\n\n\n<p class=\"has-text-align-left has-medium-font-size\"><strong>Using the Qborder Add-in<\/strong>:<\/p>\n\n\n\n<blockquote class=\"wp-block-quote\">\n<ol>\n<li>Open an Excel workbook containing the data you want to sort and make border lines.\n<ul>\n<li><img decoding=\"async\" loading=\"lazy\" width=\"1064\" height=\"647\" class=\"wp-image-246\" style=\"width: 700px;\" src=\"https:\/\/appspoon.com\/wp-content\/uploads\/2023\/08\/header-2.png\" alt=\"\" srcset=\"https:\/\/appspoon.com\/wp-content\/uploads\/2023\/08\/header-2.png 1064w, https:\/\/appspoon.com\/wp-content\/uploads\/2023\/08\/header-2-300x182.png 300w, https:\/\/appspoon.com\/wp-content\/uploads\/2023\/08\/header-2-1024x623.png 1024w, https:\/\/appspoon.com\/wp-content\/uploads\/2023\/08\/header-2-768x467.png 768w, https:\/\/appspoon.com\/wp-content\/uploads\/2023\/08\/header-2-416x253.png 416w\" sizes=\"(max-width: 1064px) 100vw, 1064px\" \/><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Select the <strong>header<\/strong> that serves as the basis for data sorting.\n<ul>\n<li><img decoding=\"async\" loading=\"lazy\" width=\"1073\" height=\"642\" class=\"wp-image-247\" style=\"width: 700px;\" src=\"https:\/\/appspoon.com\/wp-content\/uploads\/2023\/08\/header_select-1.png\" alt=\"\" srcset=\"https:\/\/appspoon.com\/wp-content\/uploads\/2023\/08\/header_select-1.png 1073w, https:\/\/appspoon.com\/wp-content\/uploads\/2023\/08\/header_select-1-300x179.png 300w, https:\/\/appspoon.com\/wp-content\/uploads\/2023\/08\/header_select-1-1024x613.png 1024w, https:\/\/appspoon.com\/wp-content\/uploads\/2023\/08\/header_select-1-768x460.png 768w, https:\/\/appspoon.com\/wp-content\/uploads\/2023\/08\/header_select-1-416x249.png 416w\" sizes=\"(max-width: 1073px) 100vw, 1073px\" \/><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><em>Go to the menu and press the &#8220;<strong>auto border line<\/strong>&#8221; button to process.<\/em>\n<ul>\n<li><img decoding=\"async\" loading=\"lazy\" width=\"453\" height=\"101\" class=\"wp-image-237\" style=\"width: 400px;\" src=\"https:\/\/appspoon.com\/wp-content\/uploads\/2023\/08\/auto_borderline.png\" alt=\"\" srcset=\"https:\/\/appspoon.com\/wp-content\/uploads\/2023\/08\/auto_borderline.png 453w, https:\/\/appspoon.com\/wp-content\/uploads\/2023\/08\/auto_borderline-300x67.png 300w, https:\/\/appspoon.com\/wp-content\/uploads\/2023\/08\/auto_borderline-416x93.png 416w\" sizes=\"(max-width: 453px) 100vw, 453px\" \/><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><em>A message box will appear displaying information about the selected table header area and table body area. After confirming the information, click &#8220;<strong>Yes<\/strong>&#8221; to proceed.<\/em>\n<ul>\n<li><img decoding=\"async\" loading=\"lazy\" width=\"1063\" height=\"646\" class=\"wp-image-248\" style=\"width: 700px;\" src=\"https:\/\/appspoon.com\/wp-content\/uploads\/2023\/08\/table_range_column-1.png\" alt=\"\" srcset=\"https:\/\/appspoon.com\/wp-content\/uploads\/2023\/08\/table_range_column-1.png 1063w, https:\/\/appspoon.com\/wp-content\/uploads\/2023\/08\/table_range_column-1-300x182.png 300w, https:\/\/appspoon.com\/wp-content\/uploads\/2023\/08\/table_range_column-1-1024x622.png 1024w, https:\/\/appspoon.com\/wp-content\/uploads\/2023\/08\/table_range_column-1-768x467.png 768w, https:\/\/appspoon.com\/wp-content\/uploads\/2023\/08\/table_range_column-1-416x253.png 416w\" sizes=\"(max-width: 1063px) 100vw, 1063px\" \/><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><em>After running <strong>Qborder<\/strong>, the data is initially sorted in ascending order. and border lines will be added between different rows, and an outline is drawn around the table.<\/em>\n<ul>\n<li><img decoding=\"async\" loading=\"lazy\" width=\"1059\" height=\"645\" class=\"wp-image-250\" style=\"width: 700px;\" src=\"https:\/\/appspoon.com\/wp-content\/uploads\/2023\/08\/table_result.png\" alt=\"\" srcset=\"https:\/\/appspoon.com\/wp-content\/uploads\/2023\/08\/table_result.png 1059w, https:\/\/appspoon.com\/wp-content\/uploads\/2023\/08\/table_result-300x183.png 300w, https:\/\/appspoon.com\/wp-content\/uploads\/2023\/08\/table_result-1024x624.png 1024w, https:\/\/appspoon.com\/wp-content\/uploads\/2023\/08\/table_result-768x468.png 768w, https:\/\/appspoon.com\/wp-content\/uploads\/2023\/08\/table_result-416x253.png 416w\" sizes=\"(max-width: 1059px) 100vw, 1059px\" \/><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>You can merge cells with the same values by clicking the &#8220;<strong>Selection Merge<\/strong>&#8221; button.\n<ul>\n<li><img decoding=\"async\" loading=\"lazy\" width=\"453\" height=\"101\" class=\"wp-image-287\" style=\"width: 400px;\" src=\"https:\/\/appspoon.com\/wp-content\/uploads\/2023\/09\/selection_merge.png\" alt=\"\" srcset=\"https:\/\/appspoon.com\/wp-content\/uploads\/2023\/09\/selection_merge.png 453w, https:\/\/appspoon.com\/wp-content\/uploads\/2023\/09\/selection_merge-300x67.png 300w, https:\/\/appspoon.com\/wp-content\/uploads\/2023\/09\/selection_merge-416x93.png 416w\" sizes=\"(max-width: 453px) 100vw, 453px\" \/><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Select the specific range of cells that you want to merge.\n<ul>\n<li><img decoding=\"async\" loading=\"lazy\" width=\"1066\" height=\"640\" class=\"wp-image-288\" style=\"width: 700px;\" src=\"https:\/\/appspoon.com\/wp-content\/uploads\/2023\/09\/selection_m1.png\" alt=\"\" srcset=\"https:\/\/appspoon.com\/wp-content\/uploads\/2023\/09\/selection_m1.png 1066w, https:\/\/appspoon.com\/wp-content\/uploads\/2023\/09\/selection_m1-300x180.png 300w, https:\/\/appspoon.com\/wp-content\/uploads\/2023\/09\/selection_m1-1024x615.png 1024w, https:\/\/appspoon.com\/wp-content\/uploads\/2023\/09\/selection_m1-768x461.png 768w, https:\/\/appspoon.com\/wp-content\/uploads\/2023\/09\/selection_m1-416x250.png 416w\" sizes=\"(max-width: 1066px) 100vw, 1066px\" \/><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Click the &#8220;<strong>Selection Merge<\/strong>&#8221; button.<\/li>\n\n\n\n<li>You will see the selected range with cells containing the same values merged together.\n<ul>\n<li><img decoding=\"async\" loading=\"lazy\" width=\"1072\" height=\"650\" class=\"wp-image-289\" style=\"width: 700px;\" src=\"https:\/\/appspoon.com\/wp-content\/uploads\/2023\/09\/selection_m2.png\" alt=\"\" srcset=\"https:\/\/appspoon.com\/wp-content\/uploads\/2023\/09\/selection_m2.png 1072w, https:\/\/appspoon.com\/wp-content\/uploads\/2023\/09\/selection_m2-300x182.png 300w, https:\/\/appspoon.com\/wp-content\/uploads\/2023\/09\/selection_m2-1024x621.png 1024w, https:\/\/appspoon.com\/wp-content\/uploads\/2023\/09\/selection_m2-768x466.png 768w, https:\/\/appspoon.com\/wp-content\/uploads\/2023\/09\/selection_m2-416x252.png 416w\" sizes=\"(max-width: 1072px) 100vw, 1072px\" \/><\/li>\n<\/ul>\n<\/li>\n<\/ol>\n\n\n\n<blockquote class=\"wp-block-quote\">\n<p><\/p>\n<\/blockquote>\n\n\n\n<figure class=\"wp-block-video\"><video controls src=\"https:\/\/appspoon.com\/wp-content\/uploads\/2023\/08\/qborder_caption-0829.mp4\"><\/video><\/figure>\n<cite>[<strong>This is a video of the program running.<\/strong>]<br>Select the header you want to align (ex. Country) and press the &#8220;auto border line&#8221;  button.<br>If so, you can see the table automatically sorted based on the selected header  and border lines are added.<br>If you want to clear the dividing line, click &#8216;clear borderline&#8217; button.<br>If you want to sort by other column, select the header of the column(ex. industry).<br>After that, if you press the &#8220;auto border line&#8221;  button, you can see the table automatically sorted based on the selected header and <strong>border lines are added<\/strong>.<\/cite><\/blockquote>\n\n\n\n<div class=\"wp-block-buttons is-layout-flex\">\n<div class=\"wp-block-button is-style-outline\"><a class=\"wp-block-button__link has-black-background-color has-background wp-element-button\" href=\"https:\/\/appspoon.com\/index.php\/product\/qborder\/\"><strong><em><mark style=\"background-color:#000000\" class=\"has-inline-color has-luminous-vivid-amber-color\">Go to product purchase &gt;&gt; <\/mark><\/em><\/strong><\/a><\/div>\n<\/div>\n\n\n\n<p>Using Qborder, you can save time and enhance data analysis efficiency by quickly sorting and visualizing data.<\/p>\n\n\n\n<p>For questions, feedback, or support related to Qborder, please contact our support team.<br>(<code><a href=\"https:\/\/appspoon.com\/index.php\/about-us\/\">https:\/\/appspoon.com\/index.php\/about-us\/<\/a><\/code>)<\/p>\n\n\n\n<p class=\"has-text-align-left\"><strong><kbd>Comments<\/kbd><\/strong><\/p>\n\n\n\n<div class=\"wp-block-comments\"><ol class=\"wp-block-comment-template\"><li id=\"comment-9\" class=\"comment even thread-even depth-1\">\n\n<div class=\"wp-block-columns is-layout-flex wp-container-7\">\n<div class=\"wp-block-column is-layout-flow\" style=\"flex-basis:40px\"><div class=\"wp-block-avatar\"><img alt='ted Avatar' src='https:\/\/secure.gravatar.com\/avatar\/4b47a90e321893e7bbdbc89b4c56b755?s=40&#038;d=mm&#038;r=g' srcset='https:\/\/secure.gravatar.com\/avatar\/4b47a90e321893e7bbdbc89b4c56b755?s=80&#038;d=mm&#038;r=g 2x' class='avatar avatar-40 photo wp-block-avatar__image ' height='40' width='40'  style=\"border-radius: 20px\" loading='lazy' decoding='async'\/><\/div><\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow\"><div class=\"wp-block-comment-author-name has-small-font-size\"><a rel=\"external nofollow ugc\" href=\"http:\/\/ddd\" target=\"_self\" >ted<\/a><\/div>\n\n\n<div class=\"wp-block-group is-layout-flex\" style=\"margin-top:0px;margin-bottom:0px\"><div class=\"wp-block-comment-date has-small-font-size\"><time datetime=\"2023-08-29T05:18:22+00:00\"><a href=\"https:\/\/appspoon.com\/index.php\/document\/#comment-9\">August 29, 2023<\/a><\/time><\/div>\n\n<\/div>\n\n\n<div class=\"wp-block-comment-content\"><p>test.. good product<\/p>\n<\/div>\n\n<div class=\"wp-block-comment-reply-link has-small-font-size\"><a rel='nofollow' class='comment-reply-link' href='https:\/\/appspoon.com\/index.php\/document\/?replytocom=9#respond' data-commentid=\"9\" data-postid=\"53\" data-belowelement=\"comment-9\" data-respondelement=\"respond\" data-replyto=\"Reply to ted\" aria-label='Reply to ted'>Reply<\/a><\/div><\/div>\n<\/div>\n\n<\/li><\/ol><\/div>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n","protected":false},"excerpt":{"rendered":"<p>&lt;Qborder&gt; Qborder Add-in User Guide Introduction: Qborder is an Excel add-in designed to enhance data differentiation and visualization by automating the data sorting and border addition processes. The following installation and usage guide explains the steps to effectively use the Qborder add-in. Caution : This program was developed and optimized for Microsoft Office 365, and [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":[],"_links":{"self":[{"href":"https:\/\/appspoon.com\/index.php\/wp-json\/wp\/v2\/pages\/53"}],"collection":[{"href":"https:\/\/appspoon.com\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/appspoon.com\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/appspoon.com\/index.php\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/appspoon.com\/index.php\/wp-json\/wp\/v2\/comments?post=53"}],"version-history":[{"count":64,"href":"https:\/\/appspoon.com\/index.php\/wp-json\/wp\/v2\/pages\/53\/revisions"}],"predecessor-version":[{"id":291,"href":"https:\/\/appspoon.com\/index.php\/wp-json\/wp\/v2\/pages\/53\/revisions\/291"}],"wp:attachment":[{"href":"https:\/\/appspoon.com\/index.php\/wp-json\/wp\/v2\/media?parent=53"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}