Cataloguing -- Yet Another Suggestion

[lucky_kari]

Err.... I'm beginning to get Excel I think, but how do you black out a
line like you're doing in your catalogue?

Eileen

--- In HP4GU-FAQ at y..., dicentra at x wrote:
> Quoting "Cindy C." <cindysphynx at c...>:
> > Hi, all.
> > 
> > How about we agree not to put periods in any acronyms?  So LOON,
not  L.O.O.N?
> 
> I'm all for that!
> 
> > Cindy -- whipped after cataloguing 4 posts, but part of the  
> > exhaustion was from the frustration of creating a spreadsheet 
>  
> Er, if you don't mind my asking: what frustration?  AFAIK, you put the
> column names in the first row, and there you are.
> 
> Just as a tip to help your life go better, in Excel you can
automatically
> fill in the message numbers and save yourself loads of grief.  Type
in the
> first two numbers (37000 and 37001, for example) in the first two rows. 
> Then select the two cells in which those numbers reside.  At the
lower-right
> corner is a little black square.  Click on that, and your cursor
turns to a
> black cross.  Then drag the black square as far down that first
column as
> you need.  Be careful, though.  For reasons beyond my understanding,
if you
> click and drag and touch the bottom of the window, it scrolls down
> automatically at lightning speed, even after you release the button (In
> Windows 98, anyway).  I had to go back and delete a bunch of
numbers, but I
> still had the 10,000 I needed.  Woohoo!
> 
> Also, you can select the first number in the list, then go to Window
on the
> main menu and select "Freeze Panes."  That way, the column headers don't
> disappear when you page down.
> 
> --Dicey