Back Home Again

I'm not sure if you've gathered it from my newsletter musings or not, but April has been a busy travel month. In fact, it has been much busier than normal. Today is (obviously) April 25, and I've only spent 6 nights at home this whole month. That makes it a challenge to stay on top of work that needs to be done (as I've found out).

But, I'm back home now and not traveling for a while, which is a good thing. Be it ever so humble, there's no place like home.

I hope you enjoy the tips in this week's newsletter.

—Allen
     

ExcelTips (ribbon) for 25 April 2015

Customizing Excel
Getting Rid of Numbered Columns

Excel normally refers to columns as A, B, C, etc. It also has a referencing format that allows columns to be referred to by number (1, 2, 3, etc.). Having Excel pop into this alternative referencing format all on its own can be a frustrating experience. Here's what is happening and how to fix it.

Read this tip »

(Thanks to Janet Donbavand, Guy Goodwin, David Prout, Harvey Phillips, Steve Aprahamian, Steve Lindquist, Barb Lange, Keith Waid, Mick Weiss, Bob Abrams, Nikolopoulos Ioannis, Jacques Raubenheimer, Bob Beechey, Dan Liddle, Carl Willems, Cindy Hannah, and Sew Sewram for contributing to this tip.)

 
Custom formats
Using a Custom Format to Add Dashes

Want some dashes automatically added in values you display in a cell? It may be trickier to develop a custom format than you thought, particularly if the values are alphanumeric.

Read this tip »

 
Save Time In Microsoft Excel with Add-ins from Add-ins.com

Add the features Microsoft forgot to Microsoft Excel! Add-ins.com has over 80 time saving, charting, data, and specialty add-ins designed to make Microsoft Excel easier to use. All the features can be easily added to the Quick Access toolbar or your own custom tab for ease of use. Trial versions available. Compatible with Excel 2003 to Excel 2013 (Office 365). Visit Add-Ins.com.

 
Charts and charting
Printing a Chart Across Multiple Pages

Wouldn't it be great to have your huge charts print out on multiple pieces of paper that you could then piece together? While Excel doesn't provide this capability directly, this tip looks at some ways that you can get the multi-page printout you want.

Read this tip »

 
Graphics
Pulling Text from a Cell and Placing It in a Shape

Graphic shapes you add to your worksheet can easily contain text-just click on the shape and start typing away. You may want the text in the shape to be based on the contents of a cell in your worksheet. This is easy to do by following these steps.

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.

 
Changing Cell Values while Printing

I want to print four copies of a worksheet, but have the value of cell A7 change for each copy. The four values are "Original," "Duplicate," "File," and "Driver." All other data being the same, how can I change the text of cell A7 while printing?
—Madhabi Roy (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