Step 1: Install the Qborder Add-in (One-time Setup)
- Open Microsoft Excel.
- Click on the “File” tab in the top-left corner.
- Select “Options” at the bottom of the navigation pane.
- In the Excel Options window, click on “Add-Ins” from the left sidebar.
- In the “Manage” dropdown menu at the bottom, select “Excel Add-ins” and click “Go…”
- Check the box next to “Qborder” in the Add-Ins available list.
- Click “OK” to close the Add-Ins dialog box.
Step 2: Apply Qborder Styling to a Table
- Open the Excel workbook containing the table you want to style.
- Select the entire table (including headers and data) by clicking and dragging your cursor over the range. Note: Make sure the table is selected with all its headers and data, and that the first cell of the selection is within the table’s headers.
- With the table selected, go to the “Add-Ins” tab in the Excel ribbon. Note: This tab should appear after you’ve installed the Qborder add-in.
- In the “Add-Ins” tab, you should see the “Qborder” section.
- Click the “Apply Qborder” button in the “Qborder” section. Note: This action will trigger the VBA code to add border lines to the selected table.
- A confirmation message may appear, informing you that Qborder will automatically add border lines to the table. Click “OK” to proceed.
Step 3: Review and Adjust Styling (Optional)
- After applying Qborder styling, review your table to see the added border lines.
- If desired, you can customize the styling further:
- To adjust the appearance of the headers, you can manually format the header cells (font, color, etc.).
- To modify the border lines or remove them, you can manually make changes using Excel’s formatting tools.
- Save your workbook to retain the Qborder styling changes.
Step 4: Sorting the Table (Optional)
- If you want to sort the data within the table, click on any cell within the column you wish to sort by.
- Go to the “Data” tab in the Excel ribbon.
- Click on the “Sort A to Z” or “Sort Z to A” button, depending on whether you want an ascending or descending sort.
Step 5: Update Qborder Styling (Optional)
- If you make changes to the table’s data or structure, you can refresh the Qborder styling by reapplying the “Apply Qborder” action from the “Add-Ins” tab.
That’s it! You’ve successfully used the “Qborder” Excel add-in to enhance the styling of your table. Remember that this guide assumes you’ve installed the Qborder add-in and provided it with the VBA code you shared earlier.
Please note that the instructions may vary slightly depending on your version of Excel and the specific layout of your spreadsheet. Always make sure to save a backup of your work before applying any changes.