You can sort in bible book order using the VLOOKUP function in Excel. Create a table with a column of numbers 1 through 66. In the column to the right list the books of the Bible in order. So now each book is assigned it's number. This is the lookup table.
Add the table into the worksheet that you want to sort. Now in the first cell of the column immediately to the left of the column with the unsorted book names insert the formula =VLOOKUP(C1,$A$104:$B$169,2,FALSE), where in this example C1 is the first cell to the right of the formula with the out of order book name. the $A$104:$B$169 is the location of the table, the "2" is the column in the table that has the corresponding book number( i.e. Genesis is #1 Revelation is #66), the FALSE argument is needed so excel will look at each cell in the way needed.
Now fill down the column so the formula is in each cell if the column. Then do a copy /paste to replace the formulas with their actual values.
You can now remove the table and format the worksheet to sort.