Selecting columns

In the Columns tab in the SQL Spreads Designer you can setup how your SQL Server table columns will be shown in Excel.

Note: Changes only affect what is shown in Excel, not how your table is setup in SQL Server.  

Show or hide columns

Use the checkboxes in the Show column to select which columns to show in Excel.


Use the header checkbox to select/unselect all.

Set columns to Read Only

Use the checkboxes in the Read Only column to select which columns that should be locked for editing in Excel.


Use the header checkbox to select/unselect all.

Rename columns

Update the Header texts that are shown in Excel by editing the name for each column in the Designer.


Rearrange column order

To rearrange the order of the columns in Excel, use "drag and drop" to move the columns up and down in the designer.

Feedback and Knowledge Base