Heading South

Today I'm off (again) to Texas to check on my father and help with some things at his place. It isn't often viewed as the best time to head to Texas (did I mention it was hot and humid there), but I think it will be a good trip all in all.

I hope that your weekend is a good one and that you enjoy the tips in this week's issue of the newsletter.

—Allen
     

ExcelTips (ribbon) for 13 July 2024

Find and Replace
Searching for Dates

If you use a worksheet that contains dates, you might want to search for those dates at some point. This isn't as simple as it may first appear. This tip discusses all the ins and outs of searching for a date in Excel.

Read this tip »

(Thanks to Steve Aprahamian, Ryszard Raciborski, Ron Solecki, Tony Greaves, Alex Blakenburg, Ira Bernstein, Jean-Marc Jousselin, Jacques Raubenheimer, Charlie O'Neill, Neil Woller, Christos Constantinou, Andrija Vrcan, Colin McCart, and Henk Haringsma for contributing to this tip.)

 
Printing
Adding Page Borders to a Printout

Need a full-page border on your Excel printouts? It's not as easy to get one as you might wish. There are a few ways you can get the border of your dreams, however.

Read this tip »

(Thanks to Willy Vanhaelen for contributing to this tip.)

 
Formatting Made Powerful

Discover one of the foundational building blocks of Excel. Custom formats are the basis for all cell-level formatting in Excel, and you can master their use. Display your data exactly and precisely as you want.

 
Advanced filtering
Advanced Filtering

Many people know how to use AutoFilter, but there are times when you need some more filtering muscle. Here's how you can use Excel's advanced filtering capabilities to see only the parts of your data that you need to see.

Read this tip »

 
Files
Full Path Names in Excel

Need to know what the full path name is for the current workbook? With a simple macro you can display the full path name in the title bar of the workbook's window.

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.

 
Making the Default Image Resolution Persistent

How can I make Excel use a specific image resolution for new workbooks? When I open a new workbook, the "Default Resolution" under the advanced file options is set to 220 ppi. I would like it set to High Fidelity. Remembering to change this setting for every new workbook I create is time consuming and open to error.
—Erik Oberg (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