Black Paint

dicentra63 dicentra at xmission.com
Thu Oct 17 14:26:03 UTC 2002


--- In HP4GU-FAQ at y..., eloiseherisson at a... wrote:
Eloise pops into the office to pick up instructions, only to find
Dicey, an e-mail in her hand and despair written on her face,
 
Dicey:
AAAAUUUUUGGGGGHHHHH!  I don't care what you do with the non-cataloged
messages! Just do what makes sense to you!!! 
> 
Eloise:
Err...Dicey?....Look, I'm really, really sorry about this but that's
kind of the point. I know what makes sense to *me*, but since I'm not
actually in Excel and have never used it (and anyway, even in MS
Works, I only understand how to put data *in*, not how to play with
the results), I can't be sure that I what makes sense to me is the
right thing. 

Dicey:
OK.  I just pulled your .xlr document into Excel and noticed that the
uncataloged messages sometimes have the message number and sometimes
don't.  If you leave out the message number from the uncatalogued
rows, it will make it easier to delete the rows. (It can be done in
one fell swoop.)  But even if the message numbers are not left out,
the blacked-out messages can still be deleted as easily as with any
other Excel file.

So.  Do this: paint the lines a transparent color (anything but black)
so that you can see what's under them.  Leave out the message number.
When you submit the finished doc, I can sort the rows, and because the
message field is blank, they'll all crowd together and I can delete
them en masse.  If deleting the message numbers is going to be a pain,
however, leave them in, and I can delete them by selecting multiple
rows, etc.

Or.

Delete the rows outright (or omit them) as you go.

Either way will work.

Eloise:
I just need a straight answer. From someone clever....and
understanding.... and patient... and sympathetic to the technically
challenged and generally wonderful.....and...and...Do you know,  we
had to write an essay at Canon College about our hero, Dicey, and *I*
 wrote about *you*?

Dicey:
::Whimpers. Begins to cloud up and rain:: WAAAAHH! I was mean and
impatient!  I bit off Eloise's head, and she has the same name as my
favorite Gran!  ::prostrates herself on floor:: I don't deserve to be
a hero. I don't even sort into Gryffindor!  Forgive me, forgive me,
and don't go Voldemort on me, please!  I forgot you weren't using
Excel.  I didn't mean it!  ::curls up into a quivering ball of pathos::

--Dicey, who had a bad day, that's all







More information about the HP4GU-FAQ archive