Manual & Usage

<Qborder>

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 works smoothly with Microsoft Office programs running the PC version of VBA.

Demo (Free) Version Installation and (Paid) Pro Version Purchase:

1. Qborder is initially offered as a free demo version. Download the compressed zip file of the Demo (Free) version and change the file extension to “.exe” for installation.
2. To change to the (paid) Pro version, visit the website (https://appspoon.com/index.php/product/qborder/) and purchase the pro version and get a serial number.
3. After obtaining the serial number, click “Get Pro Version” button in the ribbon menu of the Qborder Demo (Free) version in Excel.
   • 
4. Enter the purchased serial number in the “your serial number” field and click the OK button.
   • 
5. You can now freely utilize Qborder as the (paid, permanent version) Pro version.
   • 

Using the Qborder Add-in:

1. Open an Excel workbook containing the data you want to sort and make border lines.
   • 
2. Select the header that serves as the basis for data sorting.
   • 
3. Go to the menu and press the “auto border line” button to process.
   • 
4. A message box will appear displaying information about the selected table header area and table body area. After confirming the information, click “Yes” to proceed.
   • 
5. After running Qborder, 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.
   • 
6. You can merge cells with the same values by clicking the “Selection Merge” button.
   • 
7. Select the specific range of cells that you want to merge.
   • 
8. Click the “Selection Merge” button.
9. You will see the selected range with cells containing the same values merged together.
   • 

[This is a video of the program running.]
Select the header you want to align (ex. Country) and press the “auto border line” button.
If so, you can see the table automatically sorted based on the selected header and border lines are added.
If you want to clear the dividing line, click ‘clear borderline’ button.
If you want to sort by other column, select the header of the column(ex. industry).
After that, if you press the “auto border line” button, you can see the table automatically sorted based on the selected header and border lines are added.

Using Qborder, you can save time and enhance data analysis efficiency by quickly sorting and visualizing data.

For questions, feedback, or support related to Qborder, please contact our support team.
(https://appspoon.com/index.php/about-us/)

Comments