Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
How do I create a list from a large spreadsheet without headings
I have typed a large list of staff without headings, but want to list them by
their type of job - worksheet includes person and the type of job they do |
#2
|
|||
|
|||
How do I create a list from a large spreadsheet without headings
I'm not clear on exactly what's the desired result, but a couple things come
to mind. First, DO insert that header row (click on row 1, then on the menu bar Insert Rows, and enter labels: Name, Job). Now, you can sort: click a cell in your table and Data Sort, and choose to sort by Job then by Name, so now your table is organized by job. Or you can filter so that you see only one job type listed at a time. Click a cell in your table and Data Filter Autofilter. Use the drop-down in the Job column and choose a particular job; the others will be hidden (though still present). So you could, for instance, easily print a list of all the Administrators, etc. If you can be more specific about what you want to do with each group, perhaps we can be more helpful. --Bruce "HayRad" wrote: I have typed a large list of staff without headings, but want to list them by their type of job - worksheet includes person and the type of job they do |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trying to Create a Conditional Drop down list | Excel Worksheet Functions | |||
Print Spreadsheet tabs in a Workbook to a List? | Excel Discussion (Misc queries) | |||
create a drop down list with the source from a different workbook | Excel Discussion (Misc queries) | |||
How do you create a drop down list? | Excel Discussion (Misc queries) | |||
how do i create a list from a cell? | New Users to Excel |