freeze and split at the same time?

B

Betty11

How to split column "B" and "C" vertically and mark column "I" of the right
pane of the worksheet as a first column? Microsoft's sources I came across
say that: "You cannot split panes and freeze panes at the same time. When you
freeze panes within a split pane, all rows above and columns to the left of
the selection will be frozen and the split bar will be removed."
Is it possible anyway?
 
G

Gord Dibben

One freeze panes or one split per worksheet.

Not both nor any multiples of either.

Maybe a couple of separate Windows would do?

Window>New Window

Window>Arrange>Vertically to get two side by side windows.



Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Any way to get Freeze Panes to work with Split View? 2
Freeze Panes bug when grouping columns and sharing a workbook 1
split and freeze 2
Freeze multiple rows/columns in Excel 2007 11
Split Windows 2
Excel Date Setting 1
Freeze panes grayed out 3
How do i use multiple splits or frozen panes? 2

Top