Setting up frames in Excel using a pull down menu

A little more information about your data would help. What do you have in your drop-down? What data do you want to display based on the value selected in the drop-down? Please mock up a few scenarios in an Excel file (not a picture!!) and post it here.

You can use View | Freeze Panes to "lock" the top "x" number of rows and leftmost "y" number of columns. You could use Data Validation for your selection and populate the lower "half" of the sheet based on the value selected.

But that's not a spreadsheet on the web site ... it's a table with CSS formatting for odd and even lines.

Regards, TMS

Something like that could be achieved with an Excel table, a data validated field to pass a parameter to some VBA to apply filtering of the table.

Again, a sample spreadsheet would be a great starting point.

create range names in each sheet, e.g. chart1, chart2, chart3

Create a list of charts and create a range name for the chart list. Use this in a Data Validation field on the Main sheet. Don't use a combo box!!

Create another range name called "ShowChart" and let it refer to =INDIRECT(Main!$C$4).

Copy one of the chart sheet ranges as a picture and paste it into the Main sheet. Select the pasted picture, click the formula bar, enter a = sign and the range name "ShowChart". The formula bar will look like this

=ShowChart

Now select a chart in the drop down box in cell C4 and the display will change.

Oh, and don't split the screen. Use freeze frames instead. See attached.