The Larger Network

Hopefully everyone is aware that ExcelTips is part of the Tips.Net family of websites. What you may not know is that I publish quite a bit more information than just about how to use Excel.

If you haven't checked out the sister sites in the Tips.Net network, you really should do so. You can find them all at a single spot:

http://www.tips.net

—Allen
     

ExcelTips (ribbon) for 28 February 2015

Charts and charting
Changing Text in Text Boxes on a Chart

Macros allow you to make changes to virtually anything you can see in Excel. This tip examines how to make changes (even without a macro) to the text displayed in a text box inserted in a chart.

Read this tip »

(Thanks to Steve Aprahamian, Bob Beechey, David Sheperd, Brent Montague, and Don Bruck for contributing to this tip.)

 
Workbooks
Creating a Workbook Clone

If you are afraid of messing up a workbook, consider doing your work on a clone of the workbook. Excel provides an easy way to create the clone.

Read 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.

 
Column formatting
Hiding Columns Based on a Cell Value

Need to hide a given column based on the value in a particular cell? The easiest way to accomplish the task is to use a macro; several are highlighted in this tip.

Read this tip »

 
Macros extend Excel
Clearing the Undo Stack in a Macro

Excel keeps track of the actions you take so that you can undo those actions if any are taken in error. You may want to clear that list of actions (called the undo stack); it's easier than you think.

Read this tip »

 
     

Need More ExcelTips?

You are reading the free version of ExcelTips. There is another version you could be reading right now: ExcelTips Premium. This week ExcelTips Premium subscribers also learned about:

  • Single-Use Drop-Down List
  • Using the IF Worksheet Function
  • Creating a Log/Log Chart
  • Aborting a Macro and Retaining Control

Each weekly newsletter is in a professional PDF layout and presents double the tips (Premium subscribers see articles you won't in regular ExcelTips) with great, useful graphics. Plus, ExcelTips Premium subscribers get valuable money-saving benefits. For more information (including a sample issue), visit the Tips.Net store.

     

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.

 
Dividing the Screen Unevenly between Two Workbooks

Often when I have two workbooks open, I use Arrange | Horizontal to view them simultaneously. This divides the space evenly between the two workbooks. However, it often happens that I would like to see only a few rows of data in one workbook and many rows in the other. Is there a convenient way to manually size the smaller workbook and have Excel fill the remaining space on the screen with the second workbook?
—Dave Kerr (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