![]() Once an Excel sheet is complete you can sort your list of titles by author’s last name, title, etc.ĭo the same for the second list of the books. I then go into each title and separate each component of the listing by tabs (title, tab, authors last name, tab, authors other name, etc.) Once the entire Word document is formatted you can simply copy and paste the material into an Excel sheet and each component of the list that is separated by a tab will fall into a different column. What I do when I have a problem similar to yours is to block, copy, and paste each list into a Word document using text only paste. If you did, you can sort your sheet by author and title. ![]() When you set up your Excel sheets did you set up one column of book titles, one column of authors last name, one column of authors other names, etc.? ![]()
0 Comments
Leave a Reply. |