An Upcoming Pseudo-Menu?

Have you been using Office long enough to remember the days before Office 2007, when we relied on menus instead of ribbons? I remember it; I've been publishing ExcelTips since 1998 and been using Excel since long before that.

Well, it appears that Microsoft will soon be replacing the ribbon with something a bit more reminiscent of the older menu interface that Microsoft calls a "simplified ribbon." This will be rolled out to Office 365 subscribers in the relatively near future, and it will be standard in Office 2019.

If you'd like to learn more about this upcoming change, you might enjoy this article over on Paul Turrott's website:

Even though the ribbon interface is giving way to a simplified version, I have no doubt that the updated interface won't have the amazing level of customizability that existed in the older menu interface. (Pity!)


ExcelTips (ribbon) for 16 June 2018

Date formulas
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.)

Find and Replace
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.

Powerful spreadsheets
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 workbooks
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 »


Help Wanted

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)

ExcelTips is a free service of Sharon Parq Associates. You can find thousands of tips at our website and a whole lot more. ExcelTips is part of the Tips.Net network.
Sharon Parq Associates, Inc.  •  PO Box 1187  •  Mountain View, WY  82939  •  307-200-0450