ExcelTips (ribbon) for 31 October 2026

I hope that your Halloween is going well and that you get more treats than tricks. We will be sitting in our driveway this evening, awaiting any visitors who may come our way. Living in a new neighborhood, we have no idea if few or many come.

(Hmmm... perhaps I can use Excel to track counts by 15-minute intervals during the evening.) ;-)

Anyway, I hope you find the tips in this week's newsletter to be of value.

Getting a Project Count for Days in a Month

If you use Excel to track project dates, you may want to summarize your project information with as count for each day in a month. This tip explains how you can derive the desired counts by using just a couple of formulas.

Read this tip »

(Thanks to Brian Dorey, Rudi Olivier, Ryszard Raciborski, Steve Aprahamian, and Michael Avidan (MVP) for contributing to this tip.)

Entering Characters with Diacritical Marks

Entering characters that use diacritical marks is easy as pie in Word and some other programs. Not so in Excel, it takes a bit more work. This tip, however, provides you with several different ways you can get the exact characters you need.

Read this tip »

Colors and Fonts for Worksheet Tabs

Changing the color used on a worksheet tab is easy. Just follow the three steps in this tip.

Read this tip »

Running a Macro while in Edit Mode

Excel doesn't allow you to run a macro while editing the contents of a cell. The only solution is to get out of Edit mode, as discussed in this tip.

Read this tip »