The Last Month

The last month of the year is upon us. Thanksgiving is past and Christmas is rushing towards us, followed very closely by the end of the year.

In the hustle and bustle that always comes with this time of year, I hope that you had the opportunity to check out Mynda Treacy's dashboard course. I sent you an e-mail about it a few days ago, and she will be accepting new class registrations for a bit more than a week to come. Right now you can sign up for the class at 20% off the regular price, but that discount will be ending in less than a week. (I'll send out a reminder e-mail a day or so before the discount goes away.)

Anyway, I hope that your weekend is off to a great start and that you enjoy the tips in this week's newsletter!

—Allen
     

ExcelTips (ribbon) for 3 December 2016

Macros extend Excel
Generating a Keyword Occurrence List

Need to pull a list of words from a range of cells? This tip shows how easy you can perform the task using a macro.

Read this tip »

(Thanks to Mike Roycroft, Jan Vermaut, and Brian Canes for contributing to this tip.)

 
Protecting worksheets
Forcing a Worksheet to be Protected Again

Excel allows you to protect your worksheets so they can only be changed as you want to have happen. If you unprotect a worksheet and then save the workbook, that status (unprotected) is saved as well. This tip explains how you can make sure that a worksheet remains protected when saving.

Read this tip »

 
Pay a Visit to Formville

Need invoices, statements, receipts, applications, and hundreds of other business forms you can put to use right away? How about if you can get those forms for free? Discover what awaits you in Formville, your destination for free printable business forms.

 
Formulas
Determining Combinations to Make a Total

If you have a range of cells that contain values, you may wonder which combinations of those cells should be used to meet a specific target total. This can be an interesting challenge, as described in this tip.

Read this tip »

 
AutoFill
Turning Off AutoFill for a Workbook

Don't want people using your workbook to be able to use AutoFill? You can add two quick macros that disable and enable the feature when your workbook is activated and deactivated.

Read this tip »

     

Help Wanted

This section is for those having problems making Excel behave. If Excel is giving you fits, feel free to submit your own Help Wanted question.

If you have a solution for the problems below, click the link after the problem to send us your answer. (All responses become the sole property of Sharon Parq Associates, Inc., and can be used in any way deemed appropriate.) If your response is used in a future issue, you will be credited for your contribution to the answer.

 
Limiting Input by Time of Day

I need to ensure that nobody enters information into a worksheet between 4:00 pm and 6:30 pm each day. Is it possible to use Data Validation to prevent a user entering information in a worksheet during a particular time each day?
—Steven Nadel (provide an answer for this Help Wanted question)

 
ExcelTips is a free service of Sharon Parq Associates. You can find thousands of tips at our website and a whole lot more. ExcelTips is part of the Tips.Net network.
Sharon Parq Associates, Inc.  •  PO Box 1187  •  Mountain View, WY  82939  •  801-607-2035