The Hot Days of Summer

Are you enjoying summer? (I hope so.) Around here the days are about as long as they will get, the days are hot, and the evenings are cool. I'm enjoying all the outdoor time as I try to get caught up on projects around the yard and house.

I hope that you enjoy the tips this week.

—Allen
     

ExcelTips (ribbon) for 24 June 2017

Macros extend Excel
Automating the Importing of Macros

Macros are great when it comes to automating how you work with your workbooks. What if you want to fundamentally change the nature of a workbook from within your macro, however? This tip examines how you can save a workbook as an XLSM file and then import macros into it.

Read this tip »

 
Editing
Combining Multiple Rows in a Column

Do you need to concatenate the contents of a range of cells in the same column? Here's a formula and a handy macro to make quick work of your editing needs.

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.

 
Editing
Using the Same Range Name on Different Worksheets

Defined names can be a great boon when working in a worksheet. Usually names are available throughout an entire workbook, but you may want to limit the scope of a name so that it is only applicable within a specific worksheet. Here's how to do it.

Read this tip »

 
Worksheets
Naming Tabs for Weeks

Need to set up a workbook that includes a worksheet for each week of the year? Here's a couple of quick macros that can do the hard work for you.

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.

 
Automatically Placing Text in a Comment

I have a cell in a worksheet that when someone starts typing in the cell, I would like whatever they type to end up in a comment attached to the cell. The cell itself should remain blank, but the comment should contain whatever was typed.
—Grant Berringer (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