MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel Tips

Help Tab Added to Ribbon

Help Tab Added to Ribbon »

August 29, 2018

A new Help tab appears in Excel during 2018. The Excel 2003 Help menu was reduced to a circled question mark at the top right corner of Excel 2007 - Excel 2016. Help is now a full Ribbon tab.

New Ribbon and Help Screen

New Ribbon and Help Screen »

August 28, 2018

In a was against their customers stuck on buying perpetual licenses of Excel 2016 or Excel 2019, Microsoft introduced a new Ribbon shortly *after* finishing Excel 2019. You read that correctly - if you fork over $399 to buy Excel 2019 when it is released later this fall, you will be stuck with the older-looking interface. Customers with Office 365 will have the new interface.

Cell-level Formatting in a Pivot Table

Cell-level Formatting in a Pivot Table »

August 27, 2018

Pivot tables now support cell-level formatting. Office 365 version Version 9029.2xxxx or later has the feature.

Select Slicer With Keyboard

Select Slicer With Keyboard »

August 23, 2018

How can you select an Excel slicer using the keyboard? Yesterday, I covered the Excel F6 Loop, but that won't let you select a slicer. Is there a way using only the keyboard to select and interact with Slicers in Excel?

Rename Excel Sheet Without A Mouse Using the F6 Loop

Rename Excel Sheet Without A Mouse Using the F6 Loop »

August 22, 2018

I love keyboard shortcuts. I use hot keys for everything. But I've got a real doozy for you today. I have a worksheet named "Podcast Content". My mouse and trackball are dead. How can you rename the worksheet?

Check Accessibility in Excel

Check Accessibility in Excel »

August 21, 2018

Inclusive Design benefits everyone. Excel has a new focus on helping you to make sure the workbooks you create are easier for someone using a screen reader or other adaptive technologies.

How to Use RegEx in Microsoft Word

How to Use RegEx in Microsoft Word »

August 20, 2018

Word comes with a powerful search capability. Using wildcards is also a great feature. However, it is possible to use VBA and VBScript Regular Expressions library together for more sophisticated searches. Today we discuss how to get RegEx into the VBA, and make complicated searches easier.

Geography Data Type

Geography Data Type »

August 7, 2018

Office 365 subscribers will soon start seeing a new feature on the Data tab: Linked Data Types for geography or stocks.

Sentence Case in Excel

Sentence Case in Excel »

August 6, 2018

Although Excel is not a word processing application, sometimes you might need to change the given text to Sentence Case. There is a way to do this by combining some text functions for a single sentence, but multiple sentences. Today we will discuss about a VBA solution to achieve this in Excel.

Surveys and Forms in Excel

Surveys and Forms in Excel »

July 26, 2018

A new survey tool debuted on the Excel Insert tab on July 24. The official name of the feature is Forms... complete with a new Office-type "F" logo. But that seems confusing since Excel VBA already has User Forms and the Developer tab has Forms controls. This Forms tool is very easy to use. I've been using an online version of this in my live Power Excel seminars since March 2018 and it works very well. The change today is the perfect embedding of the Forms experience in the workbook.

Checkmarks in Excel

Checkmarks in Excel »

July 19, 2018

Creating checkmarks in Excel is usually a hassle. Yes, you could type a capital letter P and change the font to Wingdings 2, but who can remember that combination?

Magnifier in Excel

Magnifier in Excel »

July 12, 2018

When I am doing a presentation at a Staff Meeting or my Live Power Excel Seminar, I have started to use the Windows Magnifier to show details in the Ribbon or dialog boxes.