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.
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).
I finally found a quick fix for this display problem, and maybe it will help you too.
For details on the problem, and the solution steps go to the Excel Looks Strange post on my Contextures blog.
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.
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)
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.
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.
Last updated: April 4, 2021 8:55 PM