Archive Discount Ending Soon

Just a quick reminder that the annual ExcelTips archives are still avaialble at a 30% discount. This is a limited-time offer, though; it ends this coming Wednesday.

Each annual archive provides a complete year of tips published in the pages of this newsletter, organized by topic. You'll at least want to check it out, as this offer only rolls around once a year. You can find full information at this page:

I hope you have a great day and enjoy the tips in this week's newsletter!


ExcelTips (ribbon) for 16 January 2021

Date formulas
Using a Single Digit for a Year

Excel works very well with dates and times. One thing you cannot do, however, is to create a custom format that displays a single digit for a year. This tip looks at a couple of ways you can get around this limitation.

Read this tip »

(Thanks to Michael Avidan (MVP), Harold Druss, Ryszard Raciborski, Steve Aprahamian, Stephen Argent, Henk Haringsma, Ron Solecki, Howe Shou, David Gray, Robert Williams, Patrick Sedgwick, Tomek Dluzniewski, Wayne Edmondson, Corrie Buitendag, Fred van der Meulen, David Teece, Norman Harker, James Hoyt, and Mike Dawson for contributing to this tip.)

Printing Workbooks in a Folder

This tip presents two techniques you can use to print multiple workbooks all at the same time. Both techniques involve creating selection sets and then acting on those sets.

Read this tip »

ExcelTips at Your Fingertips

Support ExcelTips and obtain a valuable resource—your own copies of the ExcelTips archives. Each archive contains all the tips for a calendar year; often over 500 pages of detailed info on how to better use Excel. Learn more about Excel today!

Charts and charting
Smoothing Out Data Series

One way you can make your charts look more understandable is by removing the "jaggies" that are inherent to line charts. This is done through a process called smoothing.

Read this tip »

Cell formatting
Partially Blocking Social Security Numbers

Need to protect a series of Social Security Numbers in a worksheet? The techniques provided in this tip might be a good starting point for your endeavors.

Read this tip »

Macros extend Excel
Renaming a File

Need to rename a file in a macro? It's easy to do using the Name command, as discussed in this tip.

Read this tip »

Extracting Numbers within a Range

If you have a large number of values in a column, you may want to move the values that meet specific criteria to another column. This tip examines several different approaches to such a need.

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.

Automatically Displaying Thumbnails of a Graphic File

I have a worksheet that includes a column containing filenames such as "abcdef." This corresponds to a JPG file ("abcdef.jpg") in the same folder as the worksheet. Is there a way to make Excel automatically display, in the cell just to the right of the filename, a thumbnail of the JPG file?
—Ron Takens (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