Updates to Resources Page

I updated the new ExcelTips resource page again. I added a couple of sites (based upon reader suggestions) and I added thumbnail images for each resource.

If you haven't checked out the page, take a moment to do so, here. Then, if you have any suggestions, drop me a line and I'll see about modifying things according to your suggestion!

I hope you have a great weekend!

—Allen
     

ExcelTips (ribbon) for 23 April 2016

Find and Replace
Finding Based on Displayed Results

Want to use Excel's Find feature to locate cells based on what those cells display? It's easy if you know how to adjust where Excel looks for matches.

Read this tip »

(Thanks to Michael Avidan (MVP), Barry Dysert, Jacques Raubenheimer, Steve Viney, Mike Shellito, Bob Beechey, Alexander Guzman, Ahmed Abbas, Marjorie de Jager-Wijntuin, Bob Terrell, Henry Arthur, David Teece, Andrew McIsaac, and Rhonda Hutton for contributing to this tip.)

 
Macros extend Excel
Calculating Only the Active Workbook

When you enter information into a workbook, Excel automatically recalculates every worksheet in every open workbook on your system. If you want to limit what is recalculated, you'll need some of the techniques described in this tip.

Read this tip »

 
How to Save Your Life with the Macro Recorder

The fastest way to get the job done is by using macros and the fastest way to create them is by using the macro recorder. But you know the recorded macros are a mess and cannot be easily reused. If you want to make your recorded macros shorter, faster and adaptable to variable-size arrays and workbooks, then CLICK HERE to download the guide: How To Record Excel Macros That Work.

 
Printing
Setting Print Titles

Excel allows you to specify certain rows or columns that will be repeated on the pages of a printout. Here's how to set those titles so Excel knows what to do with them.

Read this tip »

 
Filtering
Skipping Rows when Filling

Using the fill handle is a great way to quickly fill a range of cells with values. Sometimes, however, the way to fill cells with what you want may not be immediately clear. What if you want to fill a range of cells but skip every other cell, leaving it blank?

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.

 
Locking the Size of Pictures in Comments

I routinely place pictures in comments. I then size the pictures so they are just like I need. However, if I later add or delete cells, rows, or columns near the cell to which the comment is anchored, all of a sudden the picture is huge, often 10 to 40 times the original size. Is there a way to lock the size of a picture placed into a comment?
—Jamie Jamieson (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 794  •  Orem, UT  84059  •  801-607-2035