Allen Wyatt's ExcelTips (ribbon)

ExcelTips
(ribbon interface)
19 April 2014

Publisher's Notes

Tips

Saving Movement on Enter with a Workbook

Linked Combo Boxes

Using Named Formulas Across Workbooks

Unprotecting Groups of Worksheets

Help Wanted

Shortcut to Enter GMT

Web Addresses

ExcelTips

Tips.Net Store

ExcelTips Premium

Advertising

Help Wanted Questions

Free Business Forms

Free Personal Forms

Contact Info

Help Wanted Answers

Editor and Publisher

Allen's Blog


(Click above for more info)

Publisher's Notes

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.

—Allen

Tips

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.

Read the full tip...

(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.

Read the full tip...

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.

Read the full tip...

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.

Read the full tip...

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:

  • Finding and Replacing in Text Boxes
  • Using GEOMEAN with a Large List
  • Roman Numerals for Page Numbers
  • Resizing Checkboxes

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.

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.

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?
—Farol Cilluffo (provide an answer for this Help Wanted question)

 
Tips.Net

Publisher and Copyright Information
ExcelTips is published weekly by Sharon Parq Associates, Inc., PO Box 794, Orem, UT 84059. Copyright 2014 by Sharon Parq Associates, Inc., All Rights Reserved. All broadcast, publication, or retransmission is strictly prohibited without prior written permission from the publisher. ExcelTips is part of the Tips.Net network. Full information on distribution rights can be found in the FAQ at the ExcelTips Web site.