| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I'd like to Sort one column without affecting the others
And the Sort Warning dialog box has been disabled somehow, so I can't click
"Continue with the current selection." Does anyone know how to re-enable the sort warning dialog box? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I'd like to Sort one column without affecting the others
If you select the entire column by header you will get the Sort Warning dialog.
If you select just the top cell in the column Excel will automatically select the current region with no warning. Gord Dibben MS Excel MVP On Tue, 2 Oct 2007 11:44:01 -0700, Legna105 wrote: And the Sort Warning dialog box has been disabled somehow, so I can't click "Continue with the current selection." Does anyone know how to re-enable the sort warning dialog box? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I'd like to Sort one column without affecting the others
I have been trying to sort by selecting the entire column by header. I
believe another user has disabled the warning box. Any ideas on how to re-enable it? "Gord Dibben" wrote: If you select the entire column by header you will get the Sort Warning dialog. If you select just the top cell in the column Excel will automatically select the current region with no warning. Gord Dibben MS Excel MVP On Tue, 2 Oct 2007 11:44:01 -0700, Legna105 wrote: And the Sort Warning dialog box has been disabled somehow, so I can't click "Continue with the current selection." Does anyone know how to re-enable the sort warning dialog box? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I'd like to Sort one column without affecting the others
This is not a setting that can be disabled/enabled.
I have never seen the warning box fail to appear when I have selected the entire column unless there is a blank column between my selected column and the next column with data. Gord On Tue, 2 Oct 2007 12:45:02 -0700, Legna105 wrote: I have been trying to sort by selecting the entire column by header. I believe another user has disabled the warning box. Any ideas on how to re-enable it? "Gord Dibben" wrote: If you select the entire column by header you will get the Sort Warning dialog. If you select just the top cell in the column Excel will automatically select the current region with no warning. Gord Dibben MS Excel MVP On Tue, 2 Oct 2007 11:44:01 -0700, Legna105 wrote: And the Sort Warning dialog box has been disabled somehow, so I can't click "Continue with the current selection." Does anyone know how to re-enable the sort warning dialog box? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I'd like to Sort one column without affecting the others
Is the sheet protected? That is, can you sort at all?
Mark Lincoln On Oct 2, 2:44 pm, Legna105 wrote: And the Sort Warning dialog box has been disabled somehow, so I can't click "Continue with the current selection." Does anyone know how to re-enable the sort warning dialog box? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I'd like to Sort one column without affecting the others
No it is a shared workbook. I have been able to sort just one column in the
past, but now that other users have been using it, when i try to sort just one column, a dialog box fails to appear. I thought perhaps there was a "never ask again" feature on the dialog box that someone else clicked. "Mark Lincoln" wrote: Is the sheet protected? That is, can you sort at all? Mark Lincoln On Oct 2, 2:44 pm, Legna105 wrote: And the Sort Warning dialog box has been disabled somehow, so I can't click "Continue with the current selection." Does anyone know how to re-enable the sort warning dialog box? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| data, sort option is grayed. how to sort on a column? | Excel Discussion (Misc queries) | |||
| How can I sort data without affecting formula? | Excel Discussion (Misc queries) | |||
| sort multiple rows without affecting others rows | Excel Discussion (Misc queries) | |||
| sort worksheet without affecting workbook | Excel Worksheet Functions | |||
| Changing column widths w/o affecting all rows | New Users to Excel | |||
Hybrid Mode
