Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how do I sort and filter by different criteria
I have input all my recipes into excel and I want to be able to sort them by
category, ie. according to type of food, rating, ease of preparation, etc. The whenI tried to sort by clicking on the category title, only that column sorted and it messed up the data because the rows didn't match up. I'd like to be able to click on a column heading, rating for example, and have all my favorite recipes appear according to the rating. I am using Microsoft Excel 2003. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how do I sort and filter by different criteria
Have you saved the workbook with the messed up rows?
If not, Undo should reverse the action of your sort. Just make sure when sorting to pre-select all data columns before the sort. Don't let Excel guess. As far as filtering...........with no idea of your data layout it is hard to visualize your needs. Gord Dibben MS Excel MVP On Mon, 4 Aug 2008 16:25:00 -0700, hebgengirl wrote: I have input all my recipes into excel and I want to be able to sort them by category, ie. according to type of food, rating, ease of preparation, etc. The whenI tried to sort by clicking on the category title, only that column sorted and it messed up the data because the rows didn't match up. I'd like to be able to click on a column heading, rating for example, and have all my favorite recipes appear according to the rating. I am using Microsoft Excel 2003. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how do I sort and filter by different criteria
Right click sheet tabview codeinsert thisdefine a name for your sort
range =OFFSET(yourshtname!$A$7,0,0,COUNT(yourshtname!$A: $A),10) you may prefer countA Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Excel.Range, Cancel As Boolean) [sortrange].Sort Key1:= _ Cells(1, ActiveCell.Column), Order1:=xlAscending, Orientation:=xlTopToBottom End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "hebgengirl" wrote in message ... I have input all my recipes into excel and I want to be able to sort them by category, ie. according to type of food, rating, ease of preparation, etc. The whenI tried to sort by clicking on the category title, only that column sorted and it messed up the data because the rows didn't match up. I'd like to be able to click on a column heading, rating for example, and have all my favorite recipes appear according to the rating. I am using Microsoft Excel 2003. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sort & Filter | Excel Discussion (Misc queries) | |||
Filter, sort and sum | Excel Discussion (Misc queries) | |||
Saving Sort Criteria (or Sort Lists) | Excel Worksheet Functions | |||
Filter and sort | Excel Discussion (Misc queries) | |||
"Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions |