I don't use A spreadsheet; I use many.
I start my trip planning by creating a workbook (it's not a spreadsheet, it's a collection of spreadsheet pages accessed by tabs); it's a single file.
The first page is my itinerary, with columns for the sequential days (1, 2, 3, etc), starting town, activity (what to see if I stay in the town or what to stop and see on the way, and the ending town. Once I pick an arrival date (day 1), I add columns for the date and the day-of-the-week. Then I add pages for each travel day and for each town I will stay in or visit, with hyperlinks on the itinerary page to these pages, i.e. the text, "day" 1, on the itinerary is a link to the day 1 spreadsheet.
Each day's page has the rail or bus schedule that I plan to take, alternate schedules in case I spend more time than anticipated, including the last possible connection, and fares.
Each town's page has a list of possible accommodations, with website and email links, garnered from the town's website. After I've booked accommodations, I add a map, extracted from Google Maps, of how to get to it, and include any other pertinent information.
Expenses are a second file or workbook. The first spreadsheet is a chronological log of all my expenses, by day. I have on column for travel mandated expenses and one for optional expenses, like souvenirs, newspapers, etc. On the next page, or spreadsheet, I have reproduced an expense sheet similar to the ones I used to have to fill out when I traveled on business, with columns for lunch, dinner, beverages, tips, total meal expenses, accommodation expenses, transportation expenses, admissions, and miscellaneous. When I get home I can see where I spent every euro.
On the next page I have an identical spreadsheet with all of my anticipated expenses already filled in and totaled by day and for the trip. All my rooms are reserved and the cost known, and all my transportation and admission expenses are known. And I know from experience approximately what my meal expenses will be. As I pay an expense, I take it off the sheet. I know how much the trip is going to cost, and at any time I can see very closely how much I will need to finish the trip. When I go to the ATM for the last time, I know how much to get so that I will come back home with about 200 euro to start my next trip.