Prev: Print Titles
Next: Set up form fields to that Tab can be used to move from one to ano
From: Sam Nichols Sam on 10 Feb 2010 16:06
The problem that I have and the original poster might have is that there is a
lot of data to be sorted. Adding the blank rows and columns is NOT an option
for me. Is there a way to just turn off this "helpful" (extremely
aggravating) reminder?

"Gord Dibben" wrote:

> Is it possible in your layout to isolate the groups of data by inserting
> blank columns left and right of your selection?
>
> And blank rows above and below.
>
> Or create separate "Tables" for each section.
>
>
> Gord Dibben MS Excel MVP
>
> On Wed, 9 Dec 2009 20:01:02 -0800, M. E. Kabay, PhD, CISSP-ISSMP <M. E.
> Kabay, PhD, CISSP-ISSMP(a)discussions.microsoft.com> wrote:
>
> >Has anyone figured out how to stop EXCEL 2007 from constantly asking if it
> >should "Expand the selection" or "Continue with the current selection?" I
> >have to sort answers I'm creating for multiple-choice tests, so my data bank
> >has groups of four answers that I sort alphabetically one group after
> >another. The wretched program constantly pops up this "Sort Warning" that
> >forces two extra clicks or keystrokes for every sort!
> >
> >I'm sure that someone thought the warning would be useful, but I'M SICK OF
> >IT! It should be possible to TURN IT OFF!!!
> >
> >[And no, I cannot apply a general sort to the entire sheet to avoid the
> >question-by-question sort....]
>
> .
>
From: Dave Peterson on 10 Feb 2010 18:18
No. And I for one am exceedingly happy that MS added this warning.

Sam Nichols wrote:
>
> The problem that I have and the original poster might have is that there is a
> lot of data to be sorted. Adding the blank rows and columns is NOT an option
> for me. Is there a way to just turn off this "helpful" (extremely
> aggravating) reminder?
>
> "Gord Dibben" wrote:
>
> > Is it possible in your layout to isolate the groups of data by inserting
> > blank columns left and right of your selection?
> >
> > And blank rows above and below.
> >
> > Or create separate "Tables" for each section.
> >
> >
> > Gord Dibben MS Excel MVP
> >
> > On Wed, 9 Dec 2009 20:01:02 -0800, M. E. Kabay, PhD, CISSP-ISSMP <M. E.
> > Kabay, PhD, CISSP-ISSMP(a)discussions.microsoft.com> wrote:
> >
> > >Has anyone figured out how to stop EXCEL 2007 from constantly asking if it
> > >should "Expand the selection" or "Continue with the current selection?" I
> > >have to sort answers I'm creating for multiple-choice tests, so my data bank
> > >has groups of four answers that I sort alphabetically one group after
> > >another. The wretched program constantly pops up this "Sort Warning" that
> > >forces two extra clicks or keystrokes for every sort!
> > >
> > >I'm sure that someone thought the warning would be useful, but I'M SICK OF
> > >IT! It should be possible to TURN IT OFF!!!
> > >
> > >[And no, I cannot apply a general sort to the entire sheet to avoid the
> > >question-by-question sort....]
> >
> > .
> >

--

Dave Peterson
 | 
Pages: 1
Prev: Print Titles
Next: Set up form fields to that Tab can be used to move from one to ano