Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-04-2009, 12:59 PM
mtnguye9 mtnguye9 is offline Need help with pulling out information Windows XP Need help with pulling out information Office 97
Novice
Need help with pulling out information
 
Join Date: Nov 2009
Posts: 4
mtnguye9 is on a distinguished road
Default Need help with pulling out information

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

Last edited by mtnguye9; 11-04-2009 at 06:20 PM.
Reply With Quote
  #2  
Old 11-04-2009, 04:21 PM
zyzzyva57 zyzzyva57 is offline Need help with pulling out information Windows Vista Need help with pulling out information Office 2007
Expert
 
Join Date: Mar 2009
Location: Dawsonville, Ga (NE of Atl)
Posts: 355
zyzzyva57 is on a distinguished road
Default

Select the columns > Home Tab > Cell Group > Format...
Reply With Quote
  #3  
Old 11-04-2009, 06:22 PM
mtnguye9 mtnguye9 is offline Need help with pulling out information Windows XP Need help with pulling out information Office 97
Novice
Need help with pulling out information
 
Join Date: Nov 2009
Posts: 4
mtnguye9 is on a distinguished road
Default

thanks zyz..but can you tell me more about it? I have no idea how to go from format...please review my edit
Reply With Quote
  #4  
Old 11-04-2009, 07:35 PM
zyzzyva57 zyzzyva57 is offline Need help with pulling out information Windows Vista Need help with pulling out information Office 2007
Expert
 
Join Date: Mar 2009
Location: Dawsonville, Ga (NE of Atl)
Posts: 355
zyzzyva57 is on a distinguished road
Default

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
Reply With Quote
  #5  
Old 11-05-2009, 08:16 PM
mtnguye9 mtnguye9 is offline Need help with pulling out information Windows XP Need help with pulling out information Office 97
Novice
Need help with pulling out information
 
Join Date: Nov 2009
Posts: 4
mtnguye9 is on a distinguished road
Default

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


Reply With Quote
  #6  
Old 07-16-2010, 10:10 AM
Kristiina's Avatar
Kristiina Kristiina is offline Need help with pulling out information Windows Vista Need help with pulling out information Office 2007
Advanced Beginner
 
Join Date: Apr 2010
Posts: 58
Kristiina is on a distinguished road
Default

Perhaps you think Filtering?
This you can do for specified terms.
Reply With Quote
  #7  
Old 07-24-2010, 07:52 PM
bkgashok bkgashok is offline Need help with pulling out information Windows XP Need help with pulling out information Office 2003
Novice
 
Join Date: Jul 2010
Posts: 2
bkgashok is on a distinguished road
Default

select a cell in the data then

data>filter>autofilter
Reply With Quote
Reply

Thread Tools
Display Modes


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
Need help with pulling out information no free/busy information could be retrieved jreinhardtsen Outlook 2 06-29-2006 06:23 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:44 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft