Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Cell grouping
Hello, This is the problem. I have 5 columns that are in this order, Date, Req.#, Requestor, Dept. and notes. I need to know how to arrange the entire row where the departments are grouped together with the corresponding information. The dates are not important as this report is quarterly; I know how to sort a column by itself but not the entire page. Thanks, -- jackel |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Cell grouping
Select all of the cells in all columns/rows that is to be sorted. Then, from
the menu bar, use Data | Sort a 'wizard' will pop up and ask you which columns to use as the sort key(s). This will keep all of the data together as it is sorted by your departments. "jackel" wrote: Hello, This is the problem. I have 5 columns that are in this order, Date, Req.#, Requestor, Dept. and notes. I need to know how to arrange the entire row where the departments are grouped together with the corresponding information. The dates are not important as this report is quarterly; I know how to sort a column by itself but not the entire page. Thanks, -- jackel |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Cell grouping
I should add that usually Excel is smart enough to know that when you grab
one column of information to sort, and it is contiguous with other columns with data in them, to grab them all and use the one you started with as the key. But the way I laid out above is the 'sure and certain' way. "JLatham" wrote: Select all of the cells in all columns/rows that is to be sorted. Then, from the menu bar, use Data | Sort a 'wizard' will pop up and ask you which columns to use as the sort key(s). This will keep all of the data together as it is sorted by your departments. "jackel" wrote: Hello, This is the problem. I have 5 columns that are in this order, Date, Req.#, Requestor, Dept. and notes. I need to know how to arrange the entire row where the departments are grouped together with the corresponding information. The dates are not important as this report is quarterly; I know how to sort a column by itself but not the entire page. Thanks, -- jackel |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Cell grouping
JLatham Wrote: I should add that usually Excel is smart enough to know that when you grab one column of information to sort, and it is contiguous with other columns with data in them, to grab them all and use the one you started with as the key. But the way I laid out above is the 'sure and certain' way. "JLatham" wrote: - Select all of the cells in all columns/rows that is to be sorted. Then, from the menu bar, use Data | Sort a 'wizard' will pop up and ask you which columns to use as the sort key(s). This will keep all of the data together as it is sorted by your departments. "jackel" wrote: - Hello, This is the problem. I have 5 columns that are in this order, Date, Req.#, Requestor, Dept. and notes. I need to know how to arrange the entire row where the departments are grouped together with the corresponding information. The dates are not important as this report is quarterly; I know how to sort a column by itself but not the entire page. Thanks, -- jackel -- That worked perfect, Thanks for the info! -- jackel |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Cell grouping
Another! satisfied customer <g Glad I was able to assist you with this, and
thanks for letting us know it did work for you. "jackel" wrote: JLatham Wrote: I should add that usually Excel is smart enough to know that when you grab one column of information to sort, and it is contiguous with other columns with data in them, to grab them all and use the one you started with as the key. But the way I laid out above is the 'sure and certain' way. "JLatham" wrote: - Select all of the cells in all columns/rows that is to be sorted. Then, from the menu bar, use Data | Sort a 'wizard' will pop up and ask you which columns to use as the sort key(s). This will keep all of the data together as it is sorted by your departments. "jackel" wrote: - Hello, This is the problem. I have 5 columns that are in this order, Date, Req.#, Requestor, Dept. and notes. I need to know how to arrange the entire row where the departments are grouped together with the corresponding information. The dates are not important as this report is quarterly; I know how to sort a column by itself but not the entire page. Thanks, -- jackel -- That worked perfect, Thanks for the info! -- jackel |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell References | Excel Discussion (Misc queries) | |||
Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions |