how to freeze cells in excel 2010?

I just heard frreeze panes in MS Excel 2010..but how about freeze a cell in excel 2010?

Answered Jun, 21 2010

public static void SaveToExcel(object[,] data)
    {
        Excel = Microsoft.VisualBasic.Interaction.CreateObject("Excel.Application", String.Empty);
        Excel.ScreenUpdating = false;
        dynamic workbook = Excel.workbooks;
        workbook.Add();

        dynamic worksheet = Excel.ActiveSheet;

        const int left = 1;
        const int top = 1;
        int height = data.GetLength(0);
        int width = data.GetLength(1);
        int bottom = top + height - 1;
        int right = left + width - 1;

        if (height == 0 || width == 0)
            return;

        dynamic rg = worksheet.Range[worksheet.Cells[top, left], worksheet.Cells[bottom, right]];
        rg.Value = data;

        // Set borders
        for (var i = 1; i <= 4; i++)
            rg.Borders[i].LineStyle = 1;

        // Set header view
        dynamic rgHeader = worksheet.Range[worksheet.Cells[top, left], worksheet.Cells[top, right]];
        rgHeader.Font.Bold = true;
        rgHeader.Interior.Color = 189 * (int)Math.Pow(16, 4) + 129 * (int)Math.Pow(16, 2) + 78;
        rg.EntireColumn.AutoFit();

        // Show excel app
        Excel.ScreenUpdating = true;
        Excel.Visible = true;
    } may it can help you!

Answered Nov, 09 2010

1. Freeze the Top Row

Click on the View tab.

Click on Freeze Panes from the ribbon to open the features drop down list.

Click on Freeze Top Row option in the list.
.
A black border should appear beneath row 1 in the worksheet indicating that the area above the line has been "frozen".

Scroll down through the worksheet. If you scroll far enough, the rows below row 1 will begin disappearing while row 1 will stay on the screen.
2. Freeze the First Column

Click on the View tab.

Click on Freeze Panes from the ribbon to open the features drop down list.

Click on Freeze First Column option in the list.

A black border should appear to the right of column A in the worksheet indicating that the area to the right of the line has been "frozen".

Scroll to the right in the worksheet. If you scroll far enough, the columns to the right of column A will begin disappearing while column A will stay on the screen.

read more:spreadsheets.about.com/od/exceltools/ss/81027freezepane_3.htm Answered Jun, 15 2011

Easiest way to freeze panes in excel 2010 using a c# excel component, I use it long time, name Spire.XLS, may help to you.

http://www.e-iceblue.com/Introduce/excel-for-net-introduce.html

Answered Aug, 13 2010