If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Worksheet sorts on first 5 columns only
I have a worksheet with 3 rows of columns headings.
The first row is standard columns headings. The second row is a merged cell text line. The third row is a blank row - which allows me to selct A4 and do a nrmal sort...but it only allows a sort on columns A to E . The scroll bar for the columns is greyed out I know I can enter the selection range for all the data in the upper left field, but it would be more convenient to be able to select cell A4 for a normal sort on any column. Thanks for your help. Joan |
#2
|
|||
|
|||
Worksheet sorts on first 5 columns only
Joan,
Do you have a column that is completely blank and hidden? That may prevent your selecting more than 5 columns automatically. Do you have frozen panes or split screen? That may make it seem that you cannot select all columns. HTH, Bernie MS Excel MVP "Quimera" wrote in message news:BTQvm.46847$PH1.3845@edtnps82... I have a worksheet with 3 rows of columns headings. The first row is standard columns headings. The second row is a merged cell text line. The third row is a blank row - which allows me to selct A4 and do a nrmal sort...but it only allows a sort on columns A to E . The scroll bar for the columns is greyed out I know I can enter the selection range for all the data in the upper left field, but it would be more convenient to be able to select cell A4 for a normal sort on any column. Thanks for your help. Joan |
#3
|
|||
|
|||
Worksheet sorts on first 5 columns only
Hi Bernie,
I unhid the columns and unfroze the panes - but no luck. It must be something to do with the multiple line headings, so I have re-formatted them into a single line and all is well. Thanks, Joan "Bernie Deitrick" deitbe @ consumer dot org wrote in message ... Joan, Do you have a column that is completely blank and hidden? That may prevent your selecting more than 5 columns automatically. Do you have frozen panes or split screen? That may make it seem that you cannot select all columns. HTH, Bernie MS Excel MVP "Quimera" wrote in message news:BTQvm.46847$PH1.3845@edtnps82... I have a worksheet with 3 rows of columns headings. The first row is standard columns headings. The second row is a merged cell text line. The third row is a blank row - which allows me to selct A4 and do a nrmal sort...but it only allows a sort on columns A to E . The scroll bar for the columns is greyed out I know I can enter the selection range for all the data in the upper left field, but it would be more convenient to be able to select cell A4 for a normal sort on any column. Thanks for your help. Joan |
Thread Tools | |
Display Modes | |
|
|