Better Weather

The trees have finally budded in this part of Wyoming, and some have even bloomed (leaved?) I hope you, too, are enjoying temperate weather this week and that things are going well in your corner of the world. I also hope you enjoy this week's tips.

—Allen
     

ExcelTips (ribbon) for 14 May 2022

Powerful spreadsheets
PivotTable Aggregating Incorrect Data

PivotTables can be a great tool for analyzing large amounts of data. If you have a PivotTable that is pulling information from the wrong information, it can mess up your analysis efforts. This tip presents a few ideas for fixing a problem of data coming from the wrong place.

Read this tip »

(Thanks to Raymond Guzman, Tom Santi, Dave Newcomer, and Penny Edwards for contributing to this tip.)

 
Powerful spreadsheets
Printing Multiple Worksheet Ranges

Need to print more than one portion of your worksheet? If you use named ranges for the different ranges you want to print, you can apply the technique in tip to print whatever named ranges you want.

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.

 
Editing
Moving Cells Using the Mouse

Want to easily move information from one cell to another? A quick way to do it is to simply drag and drop using the mouse.

Read this tip »

 
Time formulas
Working with Elapsed Time

Work with times in a worksheet and you will eventually want to start working with elapsed times. Here's an explanation of what they are and how to best work with them in Excel.

Read this tip »

 
Worksheets
Turning Off Worksheet Tabs

Look at the bottom of a worksheet and chances are you will see tabs for all the worksheets in the current workbook. Want to hide those tabs? You can do so by using the steps described here.

Read this tip »

 
Macros extend Excel
Getting User Input in a Dialog Box

Want to get some input from the users of your workbooks? You can do it by using the InputBox function in a macro.

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.

 
Calling a Subroutine from a UDF

I have two macros in a workbook: a UDF and a subroutine that (among other things) adds a worksheet to the workbook. I cannot seem to call the subroutine from within the UDF. Is there a restriction about using CALL within a UDF? If so, why? If not, what can I do to call the subroutine?
—Yair Babad (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