Grouped Sheets Warning
March 12, 2019
Tools for complex workbooks, grouped sheets alert, and more, in this week's Excel news. Visit my Excel website for more tips, tutorials and videos, and check the index for past issues of this newsletter.
NOTE: You'll get the next newsletter on March 26th -- I'm taking a little March break.
Note: For some products mentioned below, I earn a commission on sales. That helps support the free tutorials on my site.
In my Office 365 version of Excel, the title bar shows "Saved", at the end of the file name. Do you see it in other Excel versions too?
Also, if you have 2 or more sheets selected, the title bar shows "Group" after the file name. Grouping sheets lets you make lots of changes quickly, but it's dangerous too, if you forget to ungroup..
In a few workbooks, I use a macro to show a more noticeable grouped sheets warning. It counts how many sheets are selected, and this message appear is the count is greater than 1.
There are more Excel worksheet macro samples on my Contextures website.
Last week, you saw a simple formula to compare two tables. That's useful when you expect the 2 tables to be the same, and just want to confirm that they are.
For larger tables, where you expect differences, and want to find them, you could try the new Compare 2 Tables add-in (free) from Jan Karel Pieterse. It's still in beta, so send him feedback, if you try it.
There are other free and paid tools for managing workbooks, beyond table comparisons. For example, the Spreadsheet Inquire add-in is available in Office 365, and Office Pro Plus. If you don't see an Inquire tab, go to Options, Addins, and then COM add-ins. There's a video here that shows Inquire and Spreadsheet Compare.
Here are a couple of Excel articles that you might find useful or interesting.
AI in Excel - Last year, Microsoft announced that new AI features were being added to Excel. The Insert Data from Picture feature is rolling out now for Android users, and is coming to iOS soon. Will you use this feature? (Level - All)
Data Analysis - Excel has many uses, but Keith McNulty says that spreadsheets are slowing our progress in data analysis. Are you using Power BI and other tools now? (Level - Int/Adv)
These sliced Jackfruit sections were piled up in the grocery store, and they looked like abstract art, or a still life painting, but with price tags! The pieces were too big for us, but we'll try it one day soon.
NOTE: To read this newsletter online, paste this URL into your web browser: https://www.contextures.com/newsletter/excelnews2019/20190312ctx.html
I'll also post any article updates or corrections there.
That's it for this week! If you have any comments or questions, send me an email.
Last updated: March 21, 2019 4:25 PM