If the buyer initiated the cancellation of the order, the book will automatically show back up as an available listing. This occurs right after a successful cancellation.
If the seller initiated the cancellation, the book will need to be manually relisted if you wish to sell the book.