[HP4GU-FAQ] Re: Cataloguing -- Yet Another Suggestion

[dicentra at xmission.com]

Quoting "Cindy C." <cindysphynx at comcast.net>:
> 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