Need help with pulling out information

mtnguye9 · #1 11-04-2009, 12:59 PM

I want to be able to create a pull down section within a column that's sorts data in a large # of rows.

This is similar to the data sort function, but the pulldowns do that sort and only show the data rows you specify.

Does anyone know how to do it?

Thanks,
M

zyzzyva57 · #2 11-04-2009, 04:21 PM

Select the columns > Home Tab > Cell Group > Format...

mtnguye9 · #3 11-04-2009, 06:22 PM

thanks zyz..but can you tell me more about it? I have no idea how to go from format...please review my edit

zyzzyva57 · #4 11-04-2009, 07:35 PM

Say you want to hide Column C, then you simply click somewhere in it
then go to your Ribbon
and on the Home Tab look to the far right
and you will see the Cells group
then Format
which when you click, you will see Hide
Click this and select Hide Column

When you are ready to Unhide column(s), simply do this again

mtnguye9 · #5 11-05-2009, 08:16 PM

No, that is not what I want. I know how to hide and unhide columns.
I want to be able to create a pull down section within a column that's sorts data in a large # of rows. This is similar to the data sort function but the pulldowns do that sort and only show the data rows you specify.

Please help me if any one knows

Thanks in advance

Kristiina · #6 07-16-2010, 10:10 AM

Perhaps you think Filtering?
This you can do for specified terms.

bkgashok · #7 07-24-2010, 07:52 PM

select a cell in the data then

data>filter>autofilter

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Mail merging and pulling varying data from Excel	shannag1881	Mail Merge	0	10-05-2009 08:51 AM
Printing Some Calendar Appointment Information for Visually Impared.	Palmettokid	Outlook	2	04-08-2009 08:39 AM
no free/busy information could be retrieved	jreinhardtsen	Outlook	2	06-29-2006 06:23 AM