MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel Tips

UNIQUE Function in Excel

UNIQUE Function in Excel »

September 27, 2018

The new UNIQUE function in Excel debuts this week as part of the Dynamic Arrays formula collection. UNIQUE will return the unique values from an array.

FILTER Excel Data with a Function!

FILTER Excel Data with a Function! »

September 26, 2018

FILTER is a brand new Dynamic Array function in Excel. Announced at Ignite 2018, the function is one of several new Excel functions:

Excel Sort With a Formula Using SORT and SORTBY

Excel Sort With a Formula Using SORT and SORTBY »

September 25, 2018

Sorting with a Formula in Excel used to require an insane combination of formulas. Take a look at this data which will be used throughout this article.

Excel Formulas Now Spill Into Adjacent Cells - Major Calc Engine Change - Breaking News

Excel Formulas Now Spill Into Adjacent Cells - Major Calc Engine Change - Breaking News »

September 24, 2018

Today at the Ignite Conference in Orlando Florida, Microsoft debuted a major change to the calculation engine. Every function is now treated as an array formula and there is no more need to press Ctrl+Shift+Enter. This will lead to a rapid increase in the number of functions introduced in Office 365.

Notes and Threaded Comments in Excel

Notes and Threaded Comments in Excel »

September 18, 2018

Build 1810 of Excel in Office 365 introduces a new threaded comment style. Thankfully, the old comments are still around, now called Notes.

Tips for Customizing Excel Ribbon

Tips for Customizing Excel Ribbon »

August 30, 2018

I was doing a webinar for Excel4Apps on Modern Pivot Tables and I mentioned how I hated the default Compact Layout. Ronnie Wilson was watching the webinar and sent a note through the Q&A panel that you can add the Show in Tabular Form icon in the Quick Access Toolbar.

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.