Contextures

Contextures News 2020-10-06

Excel Looks Strange

October 6, 2020

Excel project task tracker, things look strange, 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.

Thank you for reading the news, and you'll get the next email in two weeks, on October 20th.

Note: For some products mentioned below, I earn a commission on sales. That helps support the free tutorials on my site.

Excel Looks Strange

Have you noticed that some things in Excel look strange recently? For examples, ListBoxes have missing scroll bars (2), so they're impossible to use! But, if I drag the form to a different monitor, the scroll bar reappears (1).

missing scroll bar in monitor 2

I finally found a quick fix for this display problem, and maybe it will help you too.

  • In Excel options go to the General category
  • In User Interface Options,  choose Optimize for compatibility (application restart required)
  • Click OK to close Options, then close and restart Excel

For details on the problem, and the solution steps go to the Excel Looks Strange post on my Contextures blog.

Project Tasks

If I'm making major changes to an Excel workbook, or a set of related files, I use my Excel project task tracker. It's a simple list of what needs to be done, broken into small steps. That way, I don't forget any steps, and the notes can help in the future, if more updates are needed.

The tracker also shows a total for the estimated project time, and your actual time spent. In some projects, those totals can end up far apart!

You can read more about it, and download the workbook, on the Excel Project Task Tracker page of my Contextures site.

Excel project task tracker

Excel Articles

Here are a couple of Excel-related articles that you might find useful or interesting.

Excel Tips: In PC Mag, Eric Griffith shares 26 Excel tips -- do you use all of them? My tip- it's quicker to Paste Transpose with the right-click menu! Coincidentally, the day those tips were published, Excel turned 35 years old. (Level - All)

Dashboards: If you're running out of room in your Excel dashboard, Kelly L. Williams shows how to use the camera tool, to make things fit. (Level - Int)

Also see: My Excel Products || Previous Issues

Good Start

How is October going for you? The month got off to a good start here, when I saw this rainbow, first thing on October 1st. If you're interested in the science of rainbows, National Geographic has lots of information for you.

And remember to celebrate Spreadsheet Day on Saturday, October 17th. I'll be posting about it on my Spreadsheet Day blog, as the big day gets closer.

weekly photo

NOTE: To read this newsletter online, paste this URL into your web browser: https://www.contextures.com/newsletter/excelnews2020/20201006ctx.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
dsd@ contextures.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.

contextures newsletter info

 

Last updated: October 16, 2020 10:46 AM