Contextures

Contextures News 20190312

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.

Grouped Sheets

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.

compare two tables

Workbook Tools

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.

Spreadsheet Inquire

Excel Articles

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)

Also see: My Excel Products || Excel Events || Previous Issues || Weekly Humour

Art in Nature

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.

Thinking about art reminded me of Excel MVP, Ingeborg Hawighort (Teylyn). In addition to her spreadsheet skills, she's also a talented artist (Facebook link) and musician.

weekly photo

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.

Debra Dalgleish
dsdalg@ gmail.com

Debra Dalgleish

P.S. You can choose the full Contextures news package (news and occasional special announcements), or basic news package (news only). Click either link to change your option.

 

 

Get weekly Excel tips from Debra

 

pivot power free

 

 

 

 

 

Last updated: March 21, 2019 4:25 PM