You're not the only one who is confused. If I follow what you are doing,
you are doing a lot of work. I suggest you let Excel do the work. You paid
for it. Get your money's worth!
This is just a suggestion, mind you, but it might make your life easier.
Why not type in all the titles and authors in 2 columns, Columns A & B. All
of them. Excel has 65,536 rows so that should hold all of them. If you
want to insert a new title/author in alphabetical order, just type it at the
bottom and sort the whole thing. These 2 columns would always stay there
and you would do all of your editing in those 2 columns.
Now, if you want to print or just display the whole list in 3 double
columns like you say you now have, you can tell Excel to "snake" the
columns. Excel will then list them as you have them. Columns A & B will
stay as you typed them, for future editing.
If you want to print these snaked columns and you want just yea many
rows per page, you can tell Excel to insert page breaks every so many rows
and Excel will do that, then print it all out. If all this sounds like
something you think you want, post back and I'll help you with it. HTH
Otto

"confusedteacher" wrote in
message ...
Hello-

I am trying to do an excel spreadsheet where I am typing in book titles
and
authors. I have it set up where I have 25 titles and authors, in three
"columns" per page, then it would print out to the next page. Ex:

title : author title : author title : author
title : author title : author title : author
title : author title : author title : author, etc

(next page)
title : author title : author title : author, etc.

If I need to insert a new title and author in alphabetical order, I am
wanting the bottome title and author to shirt up to the next column, and
the
last title and author combination of the third column of the page to shift
to
the firt column of the second page. How would I do this?

Hope this makes sense! thanks