Re: "Sort Data" omits Row 1
- From: Dave Peterson <ec35720@xxxxxxxxxxxxxxxxx>
- Date: Mon, 23 May 2005 07:52:34 -0500
Try giving the header row a different format--bold, underlined.
Sometimes that's enough to give excel the hint that that row is not part of the
data.
(Although, I find the Sort buttons on the toolbar too dangerous--it's too easy
to not include adjacent columns by mistake.)
Philip Hinton wrote:
>
> I _WANT_ "Sort Data" to omit Row 1 when I select a cell in a column and use
> the Sort Ascending button. This works in data tables with not many rows but
> won't with the 583 rows in the one I'm working on. How do I force it to do
> this without a hidden Row 2, or using "Data>Sort>Header Row" each time (which
> doesn't "stick")?
>
> "Frank Kabel" wrote:
>
> > Hi
> > goto 'Data - sort' and uncheck that row 1 is a heading row
> >
> > --
> > Regards
> > Frank Kabel
> > Frankfurt, Germany
> >
> > Zyvind wrote:
> > > I have many times experienced that when I select a range of data
> > > (e.g. 100 rows), and ask Excel to sort it in ascending/descending
> > > order, it only sorts rows 2-100. The values in row 1 are left in
> > > their original position, regardless of where they rank according to
> > > my criteria.
> > > I am now buliding a database in which I want to include several
> > > sort-macros, where this problem appears. Any suggestions for me?
> > >
> > > Thanks
> >
> >
> >
--
Dave Peterson
.
- Follow-Ups:
- Re: "Sort Data" omits Row 1
- From: Philip Hinton
- Re: "Sort Data" omits Row 1
- References:
- Re: "Sort Data" omits Row 1
- From: Philip Hinton
- Re: "Sort Data" omits Row 1
- Prev by Date: Re: Link to Workbook
- Next by Date: How can i stop same data being repeated in a column
- Previous by thread: Re: "Sort Data" omits Row 1
- Next by thread: Re: "Sort Data" omits Row 1
- Index(es):
Relevant Pages
|
