# SpreadsheetSheetSortSettingsBuilder

## Methods

### Columns(System.Action)

Specifies the sort options for individual columns.

#### Parameters

##### configurator - System.Action<[SpreadsheetSheetSortSettingsColumnFactory](https://www.telerik.com/aspnet-core-ui/documentation/api/kendo.mvc.ui.fluent/spreadsheetsheetsortsettingscolumnfactory)>

The configurator for the columns setting.

#### RETURNS

Returns the current instance of [SpreadsheetSheetSortSettingsBuilder](https://www.telerik.com/aspnet-core-ui/documentation/api/kendo.mvc.ui.fluent/spreadsheetsheetsortsettingsbuilder) .

### Ref(System.String)

The sorted range, for example, A1:D5.

#### Parameters

##### value - `System.String`

The value for Ref

#### RETURNS

Returns the current [SpreadsheetSheetSortSettingsBuilder](https://www.telerik.com/aspnet-core-ui/documentation/api/kendo.mvc.ui.fluent/spreadsheetsheetsortsettingsbuilder) instance.

#### Example

```
 
            @( Html.Kendo().Spreadsheet()
                        .Name("spreadsheet")
                        .Sheets(sheets =>
                        {
                            sheets.Add()
                                .Name("Food Order")
                                .Sort(sort => sort.Ref("A1:D5"));
                        })
            )
             
```