Calculating the First Tuesday

Do you need to figure out the date for the first Tuesday of any given month? Excel is incredibly flexible when it comes to formulas to return the desired date. This tip provides access to a plethora of such formulas.

Read this tip »

(Thanks to Daniel Mariotti, Roger Mason, Denny Jansen, Jacques Raubenheimer, Ralph May, Michael Avidan (MVP), Jean-Pierre Degroote, Jim Williams, Dennis Riddle, Steve Lindquist, Andrija Vrcan, Avraham Nesselroth, Les Mitchell, James Woolley, Mike Young, Avner Shner, Ryszard Raciborski, Craig Korfanta, Junior Collins, Ron Solecki, Bob Beechey, Joel Courtheyn, Peter Crosby, John Robertson, Charlie O'Neill, Krishna Kumar, Erik Oberg, Alex Blakenburg, Fred Potter, Harold Druss, Henk Haringsma, Kevin Milner, Jan Martens, Martin Keene, John Snow, Henry Arthur, Fred van der Meulen, Jim Stevens, Kevin Keyser, Robert Kurzon, Gerhard Seljehammer, Jim Wolz, Yvan Loranger, Roger Shaw, Francis Weeks, Patrick Sedgwick, Thomas Durkin, and Ruthie Ward for contributing to this tip.)

A Fast Find-Next

Tired of the Find and Replace dialog box blocking the view of your worksheet when you are searching for information? Do what I do and get rid of the dialog box. Use the technique described in this tip to do your searching.

Read this tip »

Are You Foundering at Filtering?

We have all experienced the frustration inherent with using Excel filters. Stop foundering when filtering your data by getting your copy of ExcelTips: Filters and Filtering today. More info available online.

Specifying Date Formats in Headers

Don't like the default date format used by Excel when you place the date in a header or footer? You can use a macro to get just the exact type of date format you want.

Read this tip »

Protecting an Entire Folder of Workbooks

Want to protect the Excel information stored in a particular folder on your system? There are a number of ways you can approach the task, as described in this tip.

Read this tip »

This section is for those having problems making Excel behave. If Excel is giving you fits, feel free to submit your own Help Wanted question.

If you have a solution for the problems below, click the link after the problem to send us your answer. (All responses become the sole property of Sharon Parq Associates, Inc., and can be used in any way deemed appropriate.) If your response is used in a future issue, you will be credited for your contribution to the answer.

Ribbon Missing with a Few Workbooks

I'm having a problem with one PC on our network, but the problem occurs only when that PC opens workbooks in a specific network folder. When one of the workbooks in the folder is opened, the ribbon is missing and just a gray band shows where all the buttons should be. (It is actually missing, not minimized.) Even the Close/Minimize/Maximize buttons are missing. If I hit Ctrl+P when I have a problem file open, then choose Options, suddenly the ribbon is restored, and usually stays there after the Options dialog box is closed. However, after closing the file or opening another in the folder, the ribbon is once again missing. No other PCs on the network exhibit this problem, and I'm at a loss as to why this is happening.
—Alec Whatmough (provide an answer for this Help Wanted question)