utilising drop down lists

O

OTS

i need help using excel's drop down lists. i've searched through the
group but can't make sense of anything to be used in my case. i have
different columns as different categories and the rows make up the
data. i want to make it such that each header is a drop down list,
which will be made up of the data under it. when i select that data, it
will show the data. however, i want the headers to be a split window up
top, and when i select a value, the value is shown in the bottom split.
is this possible? hope i was clear. thanks for any help.
 
P

Priya

I think data validation will be helpful here.

Enter your header on the cell. Then select Data -> validation. Choose 'List'
in the Allow Drop Down. Select the range of values for that particular
header in 'Source'

I am not clear about what exactly the second task is. You can freeze panes
going to Window - > Freeze Panes or use Window -> Split, im guessing.

Priya
 
D

Debra Dalgleish

You can use and AutoFilter to add dropdown list to the heading cells:

Select a cell in the table, then choose Data>Filter>AutoFilter

Select an item from one of the dropdown lists, and only that item will
be displayed in the table.

To keep the heading cells visible at all times, you can freeze the top
row(s):
Select the row below the heading cells
Choose Window>Freeze Panes
 
O

OTS

my thanks to both of you for replying. i think i have an idea of what
to do now. i'll mess around with your suggestions myself to try and get
a feel of how it works. cheers!
 
Top