Grid filter row filter mode
Name Surname Marital status Age Birthday Employed
Joe Crosswave Married 33 1/5/1988 False
Merry Lisel Widowed 43 5/6/1978
Henry Crux Single 30 11/19/1990 True
Cody Jurut 51 8/11/1970 False
Simon Scranton Single 35 10/10/1985
Leena Laurent Divorced 21 7/1/2000 False
Ode Cosmides Married 55 4/17/1966 True
Diandra Mizner Single 22 8/20/1999 False
Pete Cassel Married 24 3/13/1997 False
Nicky Tremblay Married 33 1/5/1988 True
Grid excel row filter mode
Name Surname Marital status Age Birthday Employed
Joe Crosswave Married 33 1/5/1988 False
Merry Lisel Widowed 43 5/6/1978
Henry Crux Single 30 11/19/1990 True
Cody Jurut 51 8/11/1970 False
Simon Scranton Single 35 10/10/1985
Leena Laurent Divorced 21 7/1/2000 False
Ode Cosmides Married 55 4/17/1966 True
Diandra Mizner Single 22 8/20/1999 False
Pete Cassel Married 24 3/13/1997 False
Nicky Tremblay Married 33 1/5/1988 True
Grid header row filter mode
Joe Crosswave Married 33 1/5/1988 False
Merry Lisel Widowed 43 5/6/1978
Henry Crux Single 30 11/19/1990 True
Cody Jurut 51 8/11/1970 False
Simon Scranton Single 35 10/10/1985
Leena Laurent Divorced 21 7/1/2000 False
Ode Cosmides Married 55 4/17/1966 True
Diandra Mizner Single 22 8/20/1999 False
Pete Cassel Married 24 3/13/1997 False
Nicky Tremblay Married 33 1/5/1988 True
Filter row view

@model IQueryable<Person>

@(Html
    .Grid(Model)
    .Build(columns =>
    {
        columns.Add(model => model.Name);
        columns.Add(model => model.Surname);
        columns.Add(model => model.MaritalStatus);

        columns.Add(model => model.Age);
        columns.Add(model => model.Birthday).Formatted("{0:d}");
        columns.Add(model => model.IsWorking);
    })
    .UsingFilterMode(GridFilterMode.Row)
    .Empty("No data found")
    .Filterable()
    .Sortable()
)

Excel row view

@model IQueryable<Person>

@(Html
    .Grid(Model)
    .Build(columns =>
    {
        columns.Add(model => model.Name);
        columns.Add(model => model.Surname);
        columns.Add(model => model.MaritalStatus);

        columns.Add(model => model.Age);
        columns.Add(model => model.Birthday).Formatted("{0:d}");
        columns.Add(model => model.IsWorking);
    })
    .UsingFilterMode(GridFilterMode.Excel)
    .Empty("No data found")
    .Filterable()
    .Sortable()
)

Header row view

@model IQueryable<Person>

@(Html
    .Grid(Model)
    .Build(columns =>
    {
        columns.Add(model => model.Name);
        columns.Add(model => model.Surname);
        columns.Add(model => model.MaritalStatus);

        columns.Add(model => model.Age);
        columns.Add(model => model.Birthday).Formatted("{0:d}");
        columns.Add(model => model.IsWorking);
    })
    .UsingFilterMode(GridFilterMode.Header)
    .Empty("No data found")
    .Filterable()
    .Sortable()
)