Multi Split Screen/Freeze Panes i.e. print titles for the screen

I have a number of projects with long lists where I'm trying to look at or operate on some subset of the long list but would like to keep the column titles visible.

The problem is if I split the screen and/or freeze panes with titles, I can't figure out how, if it is possible, to split the screen below a second time for looking at or conveniently selecting a group that starts at say line 3318 and goes to line 9965.

This would be more equivalent to print titles metaphorically speaking.

thanks,

brian

Originally Posted by romperstomper

If you make your data into a table, then when you scroll down (in 2007, not in 2004) the table header rows will become the column headings. You can then also have a split window to do what you want.
Other than that, yes you would need code.

Cool, I tried this but I don't have the header names right. I selected a rectangle of data that included the headers and chose INSERT>TABLE

It made the whole selection data and created headers titled Column 1, Column 2, etc.

I don't know how to select the table as a table and give it a reference for where to find the correct labels. I assume that works similar to telling a chart where it's labels are.

The only other thing necessary for this to be a perfect solution for a lot of my work (assuming I don't run into any downsides of having this stuff in a table when I start sorting or working on the data) is that I have to either append an alpha or numeric reference to the column to my title for that column so that if I am programming I know how to refer to it. maybe something like &COLUMN(RC) would add a numeric reference, no idea how to add an flexible alpha reference. I could create a row of ALPHA series and then concatenate that reference maybe. But I can't figure out how to use the series function to fill alpha. MAybe I could make a numeric series and then use the inverse of the CHAR function to convert that to an alpha reference, but I can't figure out what the inverse of CHAR is.

Thanks,

brian

Originally Posted by romperstomper

CODE is the opposite of CHAR.

had it backwards. CHAR is actually what I want. I thought CHAR returned the number of the character but it returns a character from a numerical input.

A table has to have its headers in the first row. They cannot be anywhere else.

They were in the first row, I was surprised it didn't automatically recognize them the way a sort does. I'll try a few other simpler takes on that. So this isn't something I can tell it where the labels are under DATA>TABLE TOOLS or FORMAT > TABLE or something.

brian

Originally Posted by romperstomper

When you insert the table there is an option to use the top rows as headers.

no dice in my version 2011 on a MAC.

TABLE has no . . .
I go insert table and it just makes a table. No options available prior to inserting the table. no dialogue box. nothing like that.

There is a checkbox in the control bar area at the top of the worksheet that says "header row" and it is checked but it inserts a row and labels it Column 1, Column 2, etc. rather than using the top row of the table.

I tried unchecking the option and it eliminates those labels and leaves an empty extra row at the top where it had inserted them, but will not let me recheck the option. I tried deleting the extra row and then rechecking with my labels as the top row but no dice.

The Table Tools option in the Data menu is greyed. No idea if there is anything there to work with. I aslo can't figure how to select the table so I could try the format menu which is a fairly facile area for managing inserted charts.

Don't know if the MAc version is that much different from 2010 on a PC or if I'm just missing something obvious (which is often the case).

Brian

Originally Posted by romperstomper

The Mac version is quite different from 2010 in many ways (and there is no mention at all of 2011 in your profile by the way).
If I remember I'll test it on 2011 later when I get home.

Benefited from an upgrade a month ago and haven't upgraded my profile.

sorry.