freeze and split at the same time?

  • Thread starter Thread starter Betty11
  • Start date Start date
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?
 
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
Split Windows 2
Unable to freeze panes 16
How do I use freeze pane and split in the same excel spreadsheet 2
Freeze multiple rows/columns in Excel 2007 11
Freeze Panes bug when grouping columns and sharing a workbook 1
split and freeze 2
How do i use multiple splits or frozen panes? 2

Back
Top