Selecting columns

Switch to the Columns tab in the SQL Spreads Designer to setup how your columns will be shown.

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.

Read Only Columns
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