He is Risen

As millions of Christians around the world know, yesterday was Good Friday and tomorrow is Easter Sunday. In some Christian traditions, today is known as Holy Saturday. Tomorrow, though, is the climax of Holy Week--the day when millions celebrate the risen Christ.

In our family we will gather with others and worship the Lord of Lords and King of Kings. We will do so with prayers and songs that focus on the significance of the event. I will, no doubt, shed tears as I sing "I know that my Redeemer lives. What comfort this sweet sentence gives! He lives, He lives who once was dead. He lives, my ever-living Head!"

I don't know how you will celebrate Easter in your family. I don't even know if you believe in the Christ; I know that many don't. Whether you believe or not, whether you celebrate or not, whether you sing or not, I wish for you an Easter Sunday filled with peace, joy, and a hope for a brighter future.

—Allen
     

ExcelTips (ribbon) for 19 April 2025

Filtering
Filtering Addresses for a Group of States

If you have a lot of data in a worksheet, you may want to filter it to display rows that match a particular criterion. This tip looks at five or six different ways you can filter your data to display just what you want.

Read this tip »

(Thanks to Ryszard Raciborski, Michael Avidan (MVP), Brian Dorey, Alan Cannon, James Woolley, Steve Aprahamian, Greg Presnall, Don Lastine, Steven Morgenstern, Ronald Doeleman, Jay Wind, Yvan Loranger, and Bob Beechy for contributing to this tip.)

 
Printing
Fitting Your Printout on a Page

Tired of wasting paper when you print a worksheet? You can scale Excel's output so that it fits only the number of pages you want to use.

Read this tip »

 
Enhance Your Excel Skills with Macros

Macros are a great way to increase your productivity with Excel by making the program work the way you want it to work. Discover the true power behind macros; ExcelTips: The Macros puts almost 800 pages of macro-focused information at your fingertips. Discover more...

 
Powerful spreadsheets
Editing the Custom Spelling Dictionaries

When spell-checking a worksheet, Excel relies on both built-in and custom dictionaries. Here's how to edit the content of your custom dictionaries so that it represents your individual spelling needs.

Read this tip »

 
Macros extend Excel
Delimited Text-to-Columns in a Macro

The Text-to-Columns tool is an extremely powerful feature that allows you to divide data in a variety of ways. Excel even makes it possible to use the tool in your own macros, as described in this tip.

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.

 
Tying a Named Range to a Value Instead of a Cell

In my data I have a named range that refers to cell C7. If I sort my data, the value that was in cell C7 is now in cell C15. I would like the named range, after the sort, to refer to cell C15, but it still refers to cell C7. Is there a way to make a named range refer to the value in a cell (so it travels with the value) rather than to the cell itself?
—Larry Solesbee (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