I'm building a book reading tracker on excel.
I have the simple formatting done. I'll provide a screenshot of my template. But, there are some things i want to add that seem too complicated for me. I'm just beginning to use excel again after many years of not using it. Excel Reading List
- Is there a way to add another log into my sheet without adding another page of data? I don't want to clutter the reading list with all of the following data: I want to record each reading session: how many pages I read that date, how long I read for, the number of sessions.
with that being said, is there a way i can insert that kind of table or link that can show up when I hover over a certain book? i don't want to create another excel page for each book with all that data and i don't want to clutter up the spreadsheet.
-
also, can anyone tell me why G3 is a different color than the rest of the row? I thought I formatted each row to be in uniform color.
-
lastly, on E2 there's a little red note on the top right hand side of the cell. how would i take that off? and what exactly it is?
Posted Apr 24, 2017, 6:01 PM UTC · edited
Welcome to the world of Excel. :)
First, the easy ones: it doesn't appear that G3 is a different color in your screenshot. Just the way light hits your screen perhaps? Either way, rather than having to manually color separate lines, you should probably use an XL table. You can do this by selecting your data (at least the headers) then go to Insert - Table. This will create a nice formatted area, it auto-expands as you add more rows, and will make formulas/analysis easier.
E2 has a comment attached. If you hover cursor over E2, you might see it. To remove this, right-click on cell, delete comment.
For the questions you asked at beginning, I think you'll be able to answer them all easily with a PivotTable. So, assuming you've got your table create, you can go to Insert - PivotTable. This will then create a powerful tool where you can move different fields around, and XL will auto-calculate different statistics, like how many pages read on a date, or how long, etc.
Intro lesson: http://www.contextures.com/CreatePivotTable.html
Thanks for that. I dont know how i inserted that comment.