Excel - split view of sheet horizontally but viewing two separated sets of columns instead of rows

I have a sheet in excel 2007 which is quite long horizontally. I'd like to see the 'first' columns of the sheet at the same time as the 'last' columns. If I split the sheet horizontally (with a top and bottom windows) it only lets me see two separated sets of rows (like A1 to A10 and A100 to A110). Is there a way to split horizontally but to see A1 to L1 in the top view and M1 to Z1 in the bottom one, for instance?

Solution 1:

Copying blatantly from jcbermu's answer to Excel - Vertical scroll columns A, B, C, D, E but F, G, H stay the same,

• On the "View" tab, "Window" panel, click on "New Window".  This gives you two windows of the same worksheet, which you can scroll independently.

• Click the next button over (in the "View" tab, "Window" panel): "Arrange All".  In the "Arrange Windows" pop-up, select "Horizontal".  (You may also want to check "Windows of active workbook" if you have other files open.)

                

  This will give you the layout that you want:

You can scroll the two windows independently horizontally, which, if I understand you correctly, is what you want.  You can scroll the two windows independently vertically (i.e., the windows are not synchronized vertically).  This might be useful or an inconvenience.