For a good portion of the world's population, this weekend holds special significance. It is Easter weekend, a time to commemorate the resurrection of Christ. It signifies the conquest of life over death, belief over doubt, and light over darkness. Yesterday (Good Friday) and tomorrow (Easter Sunday) millions of people will attend to religious rites and renew their belief in a salvation confirmed and an Atonement realized.
Obviously not everyone is a Christian; this world is nothing if not diverse. Even for those without religious belief, Easter weekend can be special, as it is often a time for families and friends to gather and enjoy the warming weather of spring. (Daffodils are starting to give way to tulips in our area.)
Regardless of how you approach this holiday, I hope that you enjoy the opportunity to pause and reflect on what it means in your life. Whether it holds religious significance to you or not, I wish you a happy Easter and the best for the season.
As a special note in this week's issue of the newsletter I've included a new tip written by Mynda Treacy. (Longtime subscribers know that Mynda is the only person who I've ever invited to write any ExcelTips. She does good stuff.) Look for her article; you'll find it enlightening.
If you have an idea for a tip, send it our way. Any tips contributed will be credited in the issue in which they appear. You can learn more about the tips in this week's issue of ExcelTips by clicking the links provided below.
Saving Movement on Enter with a Workbook
Press Enter when working in a workbook and Excel moves to a cell adjacent to the one in which you were working. If you want, you can adjust the direction in which Excel makes the move. Here's how to save a direction with each workbook you create.
(Thanks to Richard Zawadzki, Martin Nicol, Zulfiqar Meghani, John Vander Linden, Chuck Trese, Aldo Santolla, Barry Keattch, Steve Aprahamian, Fred van der Meulen, Alec Whatmough, and Frank Gibson for contributing to this tip.)
Linked Combo Boxes
Want to add a great way to interact with your worksheet users? Try adding combo boxes that can modify the information shown to the users. Here's how to do it.
Baffled by Array Formulas?
Have you heard about the special array formulas you can create in Excel? They make it a snap to perform calculations using large amounts of data and even generate results you can't get with regular formulas. Array formulas may be Excel's best-kept secret. Remove the confusion; discover how to use array formulas today.
Using Named Formulas Across Workbooks
You can use the naming capabilities of Excel to name both ranges and formulas. Accessing that named information in a workbook external to your current workbook can be a challenge. Here's how to approach the problem.
Unprotecting Groups of Worksheets
Unprotecting a single worksheet is relatively easy. Unprotecting a whole lot of worksheets is harder. Here's how you can make the task simpler.
Need More ExcelTips?
You are reading the free version of ExcelTips. There is another version you could be reading right now: ExcelTips Premium. This week ExcelTips Premium subscribers also learned about:
Each weekly newsletter is in a professional PDF layout and presents double the tips (Premium subscribers see articles you won't in regular ExcelTips) with great, useful graphics. Plus, ExcelTips Premium subscribers get valuable money-saving benefits. For more information (including a sample issue), visit the Tips.Net store.
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.
Shortcut to Enter GMT
When I use the shortcut CTRL+SHIFT+; Excel enters the local time the cell. Is there any way to have it, instead, enter GMT (+7 or +8 hours) into the cell?
Publisher and Copyright Information