Excel – Freeze top row, plus a range, in Excel

microsoft-excel-2010

Is it possible to freeze a range in Excel, and at the same time freeze the top row? I've gotten the idea of how to freeze rows and columns at the same time, but this doesn't quite accomplish exactly what I want to do.

Here's the situation:

I have a spreadsheet with information spanning A1:AB99. I want to keep all cells in A1:E20, and all of row 1, always visible while I scroll left/right/up/down through the other data.

If I use Freeze Panes at I2, it will freeze the top row and A:H. However, data in A:H below row 1 will still scroll vertically – this is undesired.

Is there a way to get Excel to do what I'm wanting it to do here?

Best Answer

I'm afraid that there is no way I can think of that will do this. Freezing stuff is about fixing full rows and/or columns.

The only thing I can think of would involve some pretty horrible programming where you would need to create your own pseudo scrolling.

It would probably be easier to do in a web page rather than Excel. Though that would still need significant JavaScript programming.

Related Solutions

Excel: Filter on column merged downwards

In Excel, merging multiple cells into one cell will keep the upper-left most data only. For example, if you merge the range A2:A6, only A2 will keep its value and A3:A6 will be blank. So, merged cells will be troublesome in your case. Instead, you can unmerge the cells in your first column, fill them with the related values (document names), and then use Filtering. Moreover, you can also use Pivot Tables (Insert > Pivot Table). Drag your first column's header (Document name) to Row Labels (in the Pivot Table Field List), and other column headers to Column Labels. You can change the design of your Pivot Table in whatever way you like.

Excel – How to convert one row of data into multiple rows in Excel

Sub convert()
    Dim intcount As Integer
    intcount = 1
    For i = 2 To **123**
        For j = 0 To 1
            If ThisWorkbook.Sheets("sheet1").Cells(i, 1 + 2 * j).Value <> vbNullString Then
                intcount = intcount + 1
                ThisWorkbook.Sheets("sheet1").Cells(i, 1).Copy Destination:=ThisWorkbook.Sheets("sheet2").Cells(intcount, 1)
                ThisWorkbook.Sheets("sheet1").Cells(i, 2 + 2 * j).Copy Destination:=ThisWorkbook.Sheets("sheet2").Cells(intcount, 2)
                ThisWorkbook.Sheets("sheet1").Cells(i, 3 + 2 * j).Copy Destination:=ThisWorkbook.Sheets("sheet2").Cells(intcount, 3)
            End If
        Next
    Next
End Sub

Best Answer

Related Solutions

Excel: Filter on column merged downwards

Excel – How to convert one row of data into multiple rows in Excel

Related Question