Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort template
Is there a way to sort a worksheet without having to highlite the worksheet
columns to be sorted? I have several rows of headings, and merged cells in the headings, so those columns won't sort, and specifying to sort with headings doesn't work because of the multiple rows of headings. Is there a way to make a Sort template so all I have to do is click on Sort and the proper rows and columns are always sorted. Also as my worksheet expands because of additional rows of data, I would like to have the new rows included in the sorts. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort template
hi
merged cells is about the dumbest thing excel programers ever came up with. your delima is one more reason NOT to use merged cells. all merged cells do is make the sheet look pretty and organized. it screws everthing else up. rid yourself of merged cells and i think your problems will go away. my thoughts......personal opinion.(extreme i admit.....but.....) regards FSt1 "Gary" wrote: Is there a way to sort a worksheet without having to highlite the worksheet columns to be sorted? I have several rows of headings, and merged cells in the headings, so those columns won't sort, and specifying to sort with headings doesn't work because of the multiple rows of headings. Is there a way to make a Sort template so all I have to do is click on Sort and the proper rows and columns are always sorted. Also as my worksheet expands because of additional rows of data, I would like to have the new rows included in the sorts. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort template
I don't think it is extreme, I have not heard anyone who is an advanced
Excel user saying he/she likes merged cells. -- Regards, Peo Sjoblom "FSt1" wrote in message ... hi merged cells is about the dumbest thing excel programers ever came up with. your delima is one more reason NOT to use merged cells. all merged cells do is make the sheet look pretty and organized. it screws everthing else up. rid yourself of merged cells and i think your problems will go away. my thoughts......personal opinion.(extreme i admit.....but.....) regards FSt1 "Gary" wrote: Is there a way to sort a worksheet without having to highlite the worksheet columns to be sorted? I have several rows of headings, and merged cells in the headings, so those columns won't sort, and specifying to sort with headings doesn't work because of the multiple rows of headings. Is there a way to make a Sort template so all I have to do is click on Sort and the proper rows and columns are always sorted. Also as my worksheet expands because of additional rows of data, I would like to have the new rows included in the sorts. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sort template | Excel Discussion (Misc queries) | |||
NCAA tournament brackets template from Template gallery. | Excel Worksheet Functions | |||
Defining Sort Order in Excel Template | Excel Discussion (Misc queries) | |||
Excel/Access template to enter/sort utility bill info | Excel Discussion (Misc queries) | |||
sort template | Excel Discussion (Misc queries) |