Comments for Contextures Blog

Comment on Build a Daily Events Calendar in Excel by Debra Dalgleish

Debra Dalgleish — Mon, 29 Jun 2026 19:32:06 +0000

Thanks Carolyn, and I’ve uploaded a full-year calendar to the Excel Calendars page
https://www.contextures.com/excelcalendarformulas.html
You could format the calendar cells to Wrap Text, to see all the text. Try to keep the descriptions short though!
To colour the cells, you could create a category column in the Events list, then use that to apply conditional formatting in the calendar. I don’t have an example of that on my site, but there are lots of conditional formatting example that might help you get started.

Comment on Build a Daily Events Calendar in Excel by Carolyn Gray

Carolyn Gray — Wed, 10 Jun 2026 00:49:02 +0000

I have downloaded this excel spreadsheet. It is exactly what I need. Can you please advise how to get the calendar to show more than 6 weeks ahead. I would like it to show the rest of the year similar to a yearly planner or Month by month if possible.

Also is it possible to change the colour of the font to highlight the events on the calendar ? So that the same type of event appears the same colour on the calendar. ie. meetings one colour, lunch one colour etc etc

Also, how do I get the event info to fit within the calendar square? Is it possible to wrap the text within the cell?

I have also sent you an email with my sample excel sheet attached

Thanks
Carolyn

Comment on 25 Years of Contextures – 40 Years of Excel by Debra Dalgleish

Debra Dalgleish — Mon, 17 Nov 2025 15:07:51 +0000

In reply to Omar. Thank you, Omar, and I really appreciate your longtime support!

Comment on 25 Years of Contextures – 40 Years of Excel by Omar

Omar — Sun, 16 Nov 2025 13:04:57 +0000

Congratulations! That’s an amazing accomplishment. Thank you for all the careful tutorials. I’ve learned lots since I started following. Maybe 20 years ago?

Comment on Clear Old Items from Pivot Table Drop Downs by Debra Dalgleish

Debra Dalgleish — Thu, 06 Nov 2025 17:36:41 +0000

In reply to Carl. You're welcome, Carl, and thanks for letting me know that it helped you find the default settings too!

Comment on Clear Old Items from Pivot Table Drop Downs by Carl

Carl — Sun, 02 Nov 2025 16:56:47 +0000

Debra – Great job on two levels of correcting this error. But even better, you helped me find the default setting location for pivots. There are a few changes I like to make on all pivots to start and now they are set without me doing every time. Thank you!

Comment on 30 Excel Functions in 30 Days: 24 – INDEX by 30 Excel Functions in 30 Days: Conclusion - Contextures Blog

30 Excel Functions in 30 Days: Conclusion - Contextures Blog — Tue, 21 Oct 2025 20:09:28 +0000

[…] – INDEX — returns value or reference, based on row and column […]

Comment on 30 Excel Functions in 30 Days: 15 – REPT by 30 Excel Functions in 30 Days: Conclusion - Contextures Blog

30 Excel Functions in 30 Days: Conclusion - Contextures Blog — Tue, 21 Oct 2025 20:02:44 +0000

[…] – REPT — repeats a text string a specified number of […]

Comment on 30 Excel Functions in 30 Days: 07 – CODE by 30 Excel Functions in 30 Days: Conclusion - Contextures Blog

30 Excel Functions in 30 Days: Conclusion - Contextures Blog — Tue, 21 Oct 2025 20:02:28 +0000

[…] – CODE — returns a numeric code for the first character in a text […]

Comment on 30 Excel Functions in 30 Days: 23 – FIND by 30 Excel Functions in 30 Days: Conclusion - Contextures Blog

30 Excel Functions in 30 Days: Conclusion - Contextures Blog — Tue, 21 Oct 2025 20:02:12 +0000

[…] – FIND — finds text within another string, and is case […]