Sort loosing blank lines (spaces)
Martin 忽帕
Artist name in col. a
Painting number in col. b
Painting name in col. c
Medium in col. d
Price in col.e
Each artist has a space between his/her's and the next artist's
collection
When i sort by painting numbers b, then a, the blank lines\spaces get
removed from between artists and are put to the top of the list - and
any cell formatting, usually borders, doesn't stay where it was
The list\worksheet uses 3 pages, each with a header row. header and
footer
What should I be doing to get around this prob?
Using XL 2000
Martin
忽帕
removethis to reply
Martin 忽帕
<mar...@removethismartinmcd.fsnet.co.uk> wrote:
>I have a worksheet with
>Artist name in col. a
>Painting number in col. b
>Painting name in col. c
>Medium in col. d
>Price in col.e
>
>Each artist has a space between his/her's and the next artist's
>collection
>
>When i sort by painting numbers b, then a, the blank lines\spaces get
>removed from between artists and are put to the top of the list -
Sorry that should be bottom of list
David McRitchie
You could have a header or not for the Artist, either way
simply make the row height for the first row for the artist
be double height then as long as that remains the
sorted first entry for each artist you will have accomplished
your goal. Sort Column A then Column B
with headers:
artist-1
artist-1 #104
artist-1 #110
artist-2
artist-2 #088
without headers:
artist-1 #104 (double height row)
artist-1 #110
artist-2 #088 (double height row)
HTH, [DNS is 209.68.48.119 should the URLs below fail]
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Macros: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
"Martin 忽帕" <mar...@removethismartinmcd.fsnet.co.uk> wrote in message news:4po4fu4958o2f2tn9...@4ax.com...
Dave Peterson
If you want to insert them again, you can select your range and do a
Data|Subtotals.
You could even use count (or sum or average) to add a little value to the
separator row (not blank).
This will also create outline symbols on the left hand side. You can use them
to collapse the details and just show summaries.
--
Dave Peterson
ec3...@msn.com
Dallman Ross
<ec3...@msn.com> spake thusly:
> I don't think I'd use the blank rows between groups.
The suggestion someone made of doubling the height of the header
row sounds like a likely winner. But if tht doesn't work, or
if it is distasteful for some other reason, here's another
idea: put something in the "blank" rows that isn't really blank.
But color the font the same as the background, rendering it
invisible. E.g., duplicate each data row in the "blank" row
beneath it, but with the font color that renders it hidden
to the viewer's eye.
--
dman
Dave Peterson
rows back.
If that's the solution that the OP likes the best, I'm sure someone will jump in
with a macro solution.
One of the reasons I don't like blank rows is what they do with sorts,
subtotals, & pivot tables. It also becomes a pain to just do things like
End|DownArrow to get to the bottom of the range.
--
Dave Peterson
ec3...@msn.com
Martin 忽帕
Thanks for the reply Dallman
Needs some trial and error testing, but seems to do the job
Dave Hawley
Haven't read the thread, but Excel won't sort hidden Rows and Columns. Maybe
you can hide them?
--
Kind Regards
Dave Hawley
www.MicrosoftExcelTraining.com
www.OzGrid.com
FREE EXCEL NEWSLETTER
http://www.ozgrid.com/News/2home.htm
Get the OzGrid Add-in
http://www.ozgrid.com/Services/AddinExamples.htm
If it's Excel, then it's us!
"Martin 忽帕" <mar...@removethismartinmcd.fsnet.co.uk> wrote in message
news:3jj6fuo9a952he424...@4ax.com...