In Excel, the new blank rows appear at the bottom of the worksheet, but this
isn't convenient to me because I am using the program for a daily log of
incoming inventory. I've figured out how to lock the top row of cells so that
my column headings are visible as I scroll down, but what I really prefer to
do is have my earliest entries be the bottom of the list and my most recent
at the top without having to insert rows at top all the time. Is there a way
to alter a worksheet so that the infinite field is at the top and not the
bottom of the worksheet? Can I keep my column headings locked so that they
consistently appear at the top despite this direction change?