SORTING CELLS
I AM TRYING TO CREATE AN EXCEL DOCUMENT WITH 5 DIFFERENT ROW HEADINGS..FOR
EXAMPLE..ONE SAYS PURCHASE ORDER, ONE SAYS WORK ORDER, ONE SAYS DATE. I WOULD LIKE TO KNOW IF I CAN CLICK ON EACH CELL AND IT WILL SORT AUTOMATICALLY. I KNOW I CAN INDIVIDUALLY SORT EACH ROW BUT I NEED THEM ALL TO SORT JUST BY CLICKING AUTOMATICALLY |
SORTING CELLS
Please get your caps lock key repaired so that you can stop SHOUTING.
-- David Biddulph "LAURA" wrote in message ... I AM TRYING TO CREATE AN EXCEL DOCUMENT WITH 5 DIFFERENT ROW HEADINGS..FOR EXAMPLE..ONE SAYS PURCHASE ORDER, ONE SAYS WORK ORDER, ONE SAYS DATE. I WOULD LIKE TO KNOW IF I CAN CLICK ON EACH CELL AND IT WILL SORT AUTOMATICALLY. I KNOW I CAN INDIVIDUALLY SORT EACH ROW BUT I NEED THEM ALL TO SORT JUST BY CLICKING AUTOMATICALLY |
SORTING CELLS
After you fix the caps lock key please post back with answers to a couple of
questions. 1. When you use the word "Row" do you really mean "Column"? 2. Do you want all the columns to sort together or separately? Gord Dibben MS Excel MVP On Thu, 24 Jul 2008 07:04:01 -0700, LAURA wrote: I AM TRYING TO CREATE AN EXCEL DOCUMENT WITH 5 DIFFERENT ROW HEADINGS..FOR EXAMPLE..ONE SAYS PURCHASE ORDER, ONE SAYS WORK ORDER, ONE SAYS DATE. I WOULD LIKE TO KNOW IF I CAN CLICK ON EACH CELL AND IT WILL SORT AUTOMATICALLY. I KNOW I CAN INDIVIDUALLY SORT EACH ROW BUT I NEED THEM ALL TO SORT JUST BY CLICKING AUTOMATICALLY |
All times are GMT +1. The time now is 10:04 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com