Contextures

Contextures News 20181009

Excel Date and Time Formulas

October 9, 2018

Date and time formulas, missing arrows, 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: For some products mentioned below, I earn a commission on sales. That helps support the free tutorials on my site.

Missing Arrows

To make data entry easier, you can create drop down lists in a worksheet, with Data Validation. Usually, things go smoothly, but sometimes the arrows for those drop down lists disappear.

On my website, I've got details on some of the reasons for missing arrows, such as incorrect settings, and even a linked picture.

missing arrow

Last week, I added another cause to that page -- macros that accidentally delete those arrows. If a macro deletes shapes on a worksheet, it might also delete the drop down arrow. Excel sees that as a shape!

To delete other worksheet shapes safely, without deleting the data validation arrows, see the macros to delete objects on Ron de Bruin's website.

Macro Training

If you're tired of doing repetitive tasks in Excel, learn how you can save time with macros. Jon Acampora is running free webinars on macros & VBA next week. Choose any date from Monday, October 15th to Friday, October 19th.

The free webinar is titled, "The 7 Steps to Getting Started with Macros & VBA". Jon will explain why you'd want to learn VBA and show how to get started writing your own macros.

Then if you want to dig deeper into Excel macros, Jon is running a new session of his popular VBA Pro Course. Sign up soon - registration is open for a short time only -- from Oct. 15 - 25, 2018.

Excel Articles

Here are a few Excel articles that you might find useful or interesting.

Time Formulas - Doug Jenkins shows how to calculate the number of hours between two dates, and format the results in different ways. Read the update at the end, about the [h] format. (Level - All)

Automation - I love creating macros to save time in Excel, but are you automating yourself out of a job? What happens to all those free hours that you create at work? Thank to UniMord for the link. (Level - All)

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

On the Wall

There is a lovely new wall hanging in our front hall, thanks to my daughter, who started doing macramé this summer. Wikipedia says that macramé has been around since the 13th century, and I remember when it was popular in the 1970s. Back then, we used rough twine for our creations, not fancy coloured cord like this. And we even went to the Binder Twine Festival every year. Those were simpler times!

weekly photo

That's it for this week! If you have any comments or questions, send me an email.

NOTE: For the online version, paste this URL into your web browser: https://www.contextures.com/newsletter/excelnews2018/20181009ctx.html
I'll also post any article updates or corrections there.

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: October 5, 2018 2:23 PM