Check Out WordTips

I know that if you are using Excel, there is a good chance you are using Word, as well. If that is the case, and if you want to sharpen your Word-related skills, you really should consider signing up for my WordTips newsletter.

To do so, go take a look at the WordTips website: https://wordribbon.tips.net. You can sign up for the newsletter using the sign-up box at the right side of any page.

I hope you had a good Thanksgiving (for those in the U.S.) and that you enjoy the tips in this weeks newsletter.

—Allen
     

ExcelTips (ribbon) for 27 November 2021

Powerful spreadsheets
Using a Custom Date Format in a Header or Footer

Need to show a custom date in the header or footer of a printout? You'll need to resort to using a macro, as described in this tip.

Read this tip »

(Thanks to Steve Aprahamian, Dave Newcomer, Ryszard Raciborski, Michael Avidan (MVP), Wayne Edmondson, Bob Beechey, Tomek Dluzniewski, Mark Galloway, and Fred van der Meulen for contributing to this tip.)

 
Files
Comma-Delimited Differences for PC and Mac

When you choose to save worksheet data in CSV format, Excel gives you three choices for file formats. Those choices are detailed in this tip.

Read this tip »

 
Are You Foundering at Filtering?

We have all experienced the frustration inherent with using Excel filters. Stop foundering when filtering your data by getting your copy of ExcelTips: Filters and Filtering today. More info available online.

 
Powerful spreadsheets
Viewing More than Two Places in a Worksheet

If your worksheet gets big enough, it is easy to spend a lot of time navigating back and forth between different areas. Why not look at two places in the same worksheet at the same time? Here's how.

Read this tip »

 
Conditional formatting
Changing Shading when a Column Value Changes

If you have a data table in a worksheet, and you want to shade various rows based on whatever is in the first column, then you can use Excel's conditional formatting capabilities. There are a couple of ways you can choose to do so, however.

Read this tip »

 
Formulas
Stopping a Formula from Updating References

Insert or delete a column, and Excel automatically updates references within formulas that are affected by the change. If you don't want to have a reference updated by the change, then you can apply the techniques described in this tip.

Read this tip »

 
Workbooks
Seeing All Open Workbook Names

Ever want to see a list of all the workbooks that are open? If you open more than nine, Excel only displays the first nine without requiring you to go to a different menu to find the others. To make your job easier, this tip explains how to see every open workbook.

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.

 
Seeing Formula Cells on Different Worksheets

If I click in the Formula bar, Excel will highlight the cells used in that formula, if they are on the same worksheet as the formula. Is there a way to have this highlight work if the cells are on a different worksheet? I use two monitors so I can see both worksheets at the same time.
—Jerry Jones (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