Finding Beauty

It has been a busy week around the Wyatt household. This past week required three separate trips to Salt Lake City (about 125 miles away). One was for a business meeting, and the other two were for doctor appointments. So, a lot of time was spent on the highway, watching the scenery go by.

One thing I noticed is that this year is different than the last decade or so. There has been a lot of precipitation this year, which means that the foliage is greener than normal this year, and all the reservoirs in our area are quite full. (Their normal condition in late September is quite depleted.)

I hope that in your area of the world you are able to find beauty and that your schedule allows you to enjoy that which you find.

My best to you.

—Allen
     

ExcelTips (ribbon) for 23 September 2023

Charts and charting
Showing Elapsed Time in a Graph

Working with elapsed times can be a bit tricky in some situations. One such situation involves the displaying of elapsed times in a graph. This tip, however, shows how easy it can be.

Read this tip »

(Thanks to Michael Avidan (MVP), Steve Aprahamian, Stephen Farrell, Ryszard Raciborski, Ron Solecki, and Bob Koning for contributing to this tip.)

 
Worksheet functions
Calculating the Day of the Year

Need to know what day of the year a certain date is? You can figure it out easily using the formulas in this tip.

Read this tip »

 
Journal Your Life

Journals go by many names--diaries, sketchbooks, or simply blank books. Regardless of the name, though, journals provide a way for you to record, track, create, dream, and illustrate your life. Journals make it not only possible, but easy. Check out our complete line of high-quality, convenient journals today!

 
Worksheets
Making Multiple Worksheet Copies

If you spend a lot of time creating a worksheet, you might want to make multiple copies of that worksheet as a starting point for additional work. This tip discusses several ways you can easily make the copies you need.

Read this tip »

 
Powerful spreadsheets
Changing Default Row Height

Changing the default row height used for a worksheet is relatively easy, as long as you don't mind the row height never varying from what you set. If you want Excel to be able to still adjust the row height above your default, things get a bit trickier.

Read this tip »

 
Sorting
Sorting Dates and Times

One of the strong features of Excel is its ability to sort information in a worksheet. When it doesn't sort information as you expect, however, it can be confusing. Here's a look at why your dates and times might not sort the way you want them to.

Read this tip »

 
Editing
Default Cell Movement when Deleting

Delete a cell or a range of cells, and Excel needs to figure out how to rearrange the void left by the deletion. You can control how the remaining cells are moved, and you can even create tools to do the movement automatically.

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.

 
Highlighting an Entire Row for the Current Date

I have a worksheet with 365 or 366 rows, one for each day. The date is in column B. Using conditional formatting I can highlight the current date, but how can I highlight the whole row for the current date?
—Ronald Jordan (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  •  307-200-0450