MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel Tips


The Excel Window Becomes Invisible And You Can not Click What is Behind It

The Excel Window Becomes Invisible And You Can not Click What is Behind It »


March 23, 2018

A couple of times a week, one of my Excel windows becomes completely transparent. Is this happening to anyone else?

Prevent Tiny Blank Columns By Using an Accounting Underline for Your Headings

Prevent Tiny Blank Columns By Using an Accounting Underline for Your Headings »


March 22, 2018

I worked for some truly annoying managers. Lousy people skills. Arrogant. But the one who really fried my shorts was the guy who had this bad habit in Excel.

Fixing Excel Data Using Flash Fill

Fixing Excel Data Using Flash Fill »


March 21, 2018

Every Wednesday, I am feating a favorite Excel tip from Excel Project Manager Ash Sharma. This week, Flash Fill. Introduced in Excel 2013, Flash Fill will allow you to extract characters from a column of data or concatenate data from columns without writing a formula.

Split by Delimiter to New Rows

Split by Delimiter to New Rows »


March 20, 2018

Instead of designing a real database, many people will tuck a repeating group all in one cell, separated by commas or semi-colons. A great new feature in Power Query allows you to turn each item in the cell into a new row.

Using Alt to Access Your First Quick Access Toolbar Icons

Using Alt to Access Your First Quick Access Toolbar Icons »


March 19, 2018

To be fast in Excel, you need to know important shortcut keys. Today, our mouse-free Monday article focuses on your first 9 icons on the Quick Access Toolbar.

I Use Excel to Type Letters Instead of Microsoft Word

I Use Excel to Type Letters Instead of Microsoft Word »


March 17, 2018

The old joke is that Microsoft Word is some freeware for people who can't figure out how to type their letters in Excel. My confession for today: I often will type letters or at least paragraphs of text in Excel. One obscure command will help make your letters look good in Excel.

Pivot Table Timelines Forget What Year it Is

Pivot Table Timelines Forget What Year it Is »


March 16, 2018

Today's bug in Excel was discovered by Mynda Treacy and involves the timeline slicer in Excel. Mynda was working on videos for one of her awesome courses and found a pivot table where the timeline slicer kept adding new years.

Merge Worksheets Using Consolidate

Merge Worksheets Using Consolidate »


March 15, 2018

Excel offers a Consolidate command on the Data tab. This ancient command lets you consolidate data from multiple worksheets or workbooks, even if the data is a different shape.

Using AutoSum in Tables

Using AutoSum in Tables »


March 14, 2018

Direct from the Excel development team, Project Manager Ash Sharma shares another of his seven favorite tips about Excel. This is one that I never knew.

Set Defaults For All Future Pivot Tables

Set Defaults For All Future Pivot Tables »


March 13, 2018

I was horrified when I saw my first Excel 2007 pivot table. For some inconceivable reason, Excel was putting three different row fields in column A. Why would anyone think this was a good idea?

Alt+E+S for Paste Special Options

Alt+E+S for Paste Special Options »


March 12, 2018

It is mouse-free Monday. Today, I want to introduce you to Alt+E+S which is the gateway to the wonderful world of Paste Special options.

I Use VLOOKUP Far More Often than Index and Match

I Use VLOOKUP Far More Often than Index and Match »


March 10, 2018

I conceptually know in my head that INDEX and MATCH are superior to VLOOKUP. But to this day, I will confess that I use VLOOKUP 99% of the time. Here's why.