MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Notes and Threaded Comments in Excel


September 18, 2018 - by Bill Jelen

Notes and Threaded Comments in Excel

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

Note

If you have been using Excel forever, you will remember that Notes debuted in Excel 97 and were called Notes. My take: The odd name "Comments" was a bug that debuted in 2000 and was just corrected on September 10, 2018! I am glad that notes are back to their original name.

This figure compares an old style Note (red triangle) to a new Threaded Comment (purple indicator).

Different cell indicators call out the different comment types.
Different cell indicators call out the different comment types.

Both Notes and Comments are found on the Review tab of the Ribbon. The Comment section is larger and is the new threaded comments.

continue reading »

More Reading


Tips for Customizing Excel Ribbon

Tips for Customizing Excel Ribbon »

August 30, 2018 - by Bill Jelen


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 - by Bill Jelen


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.

read more articles »


IMA Data Analytics Leveraging Excel

Featured Products


Excel JavaScript UDFs Straight to the Point

Excel JavaScript UDFs Straight to the Point »


JavaScript custom functions - UDFs can be used like any other native functions or UDFs in Excel. This book shows the process of creating JavaScript UDFs in Excel Developer Preview for Office Insider program subscribers.

Pivot Table Data Crunching: Microsoft Excel 2016

Pivot Table Data Crunching: Microsoft Excel 2016 »


Use Excel 2016 pivot tables and pivot charts to produce powerful, dynamic reports in minutes instead of hours… understand exactly what’s going on in your business… take control, and stay in control! Even if you’ve never created a pivot table before, this book will help you leverage all their amazing flexibility and analytical power.

Learn to Write DAX

Learn to Write DAX »


Data analysis expressions (DAX) is the formula language of PowerPivot and Power BI. Simply reading a book is normally not enough to help Excel users learn DAX skills – you need to complete exercises and get plenty of practice to make the transition.

Power Pivot and Power BI

Power Pivot and Power BI »


Power Pivot for Excel and its close cousin Power BI Desktop are Microsoft’s tightly-related pair of revolutionary analytical tools – tools that are fundamentally changing the way organizations work with data.

M is for (DATA) MONKEY

M is for (DATA) MONKEY »


Despite the moniker "data monkey", we information workers are often more like data magicians. Our data seldom enters our world in a ready-to-consume format; it can take hours of cleaning, filtering, and reshaping to get things ready to go. Power Query will make this process faster the first time and reduce it to a single button click every subsequent time.

Power Excel With MrExcel - 2017 Edition

Power Excel With MrExcel - 2017 Edition »


This is the print book edition of "Power Excel with MrExcel - 2017 Edition" - by Bill Jelen. Master Pivot Tables, Subtotals, Visualizations, VLOOKUP, Power BI and Data Analysis.

see more products »