Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
HayRad
 
Posts: n/a
Default 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   Report Post  
bpeltzer
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Trying to Create a Conditional Drop down list Noel Excel Worksheet Functions 6 July 26th 05 05:18 PM
Print Spreadsheet tabs in a Workbook to a List? Jugglertwo Excel Discussion (Misc queries) 3 May 28th 05 07:04 PM
create a drop down list with the source from a different workbook Sampath Excel Discussion (Misc queries) 2 January 8th 05 07:57 PM
How do you create a drop down list? Aviator Excel Discussion (Misc queries) 2 December 28th 04 03:07 PM
how do i create a list from a cell? AT New Users to Excel 2 December 15th 04 07:40 PM


All times are GMT +1. The time now is 01:33 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"