Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
New... Can I even do this?
I work in an assessment office and I enter alot of tables that involve pin
numbers, property address, owner, owner address, as well as other information. I would like to be able to 'freeze' the rows and be able to sort by these different categories without the rows getting all messed up. Can I even do this in excel? Is there a better program to work with? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
New... Can I even do this?
Here are a couple options....
Before you sort....select the ENTIRE DATA range. Then, when you sort on one or more columns, the associated data will move with the sorted data. OR.... you might be able to use an AutoFilter to hide the rows you don't want to see. Select the data range Then...From the Excel main menu: <data<filter<autofilter That will put little dropdown arrows on all of the colum headings. Play with the criteria. When you're done.... <data<filter<autofilter will turn off the autofilter Does that help? *********** Regards, Ron XL2002, WinXP "allycat1186" wrote: I work in an assessment office and I enter alot of tables that involve pin numbers, property address, owner, owner address, as well as other information. I would like to be able to 'freeze' the rows and be able to sort by these different categories without the rows getting all messed up. Can I even do this in excel? Is there a better program to work with? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
New... Can I even do this?
Yes, thank you. It is a little different than what I was after but it works.
"Ron Coderre" wrote: Here are a couple options.... Before you sort....select the ENTIRE DATA range. Then, when you sort on one or more columns, the associated data will move with the sorted data. OR.... you might be able to use an AutoFilter to hide the rows you don't want to see. Select the data range Then...From the Excel main menu: <data<filter<autofilter That will put little dropdown arrows on all of the colum headings. Play with the criteria. When you're done.... <data<filter<autofilter will turn off the autofilter Does that help? *********** Regards, Ron XL2002, WinXP "allycat1186" wrote: I work in an assessment office and I enter alot of tables that involve pin numbers, property address, owner, owner address, as well as other information. I would like to be able to 'freeze' the rows and be able to sort by these different categories without the rows getting all messed up. Can I even do this in excel? Is there a better program to work with? |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
New... Can I even do this?
I'm glad you could work with that.....and thanks for the feedback!
*********** Regards, Ron XL2002, WinXP "allycat1186" wrote: Yes, thank you. It is a little different than what I was after but it works. "Ron Coderre" wrote: Here are a couple options.... Before you sort....select the ENTIRE DATA range. Then, when you sort on one or more columns, the associated data will move with the sorted data. OR.... you might be able to use an AutoFilter to hide the rows you don't want to see. Select the data range Then...From the Excel main menu: <data<filter<autofilter That will put little dropdown arrows on all of the colum headings. Play with the criteria. When you're done.... <data<filter<autofilter will turn off the autofilter Does that help? *********** Regards, Ron XL2002, WinXP "allycat1186" wrote: I work in an assessment office and I enter alot of tables that involve pin numbers, property address, owner, owner address, as well as other information. I would like to be able to 'freeze' the rows and be able to sort by these different categories without the rows getting all messed up. Can I even do this in excel? Is there a better program to work with? |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
New... Can I even do this?
yes you can! have you tried using the auto filters?.. they can group cells
the have similar criteria... better yet the custom filters let you specify criteria in cells that you want to see... hope this helps! take care Jim "allycat1186" wrote: I work in an assessment office and I enter alot of tables that involve pin numbers, property address, owner, owner address, as well as other information. I would like to be able to 'freeze' the rows and be able to sort by these different categories without the rows getting all messed up. Can I even do this in excel? Is there a better program to work with? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|