So Far Away

Every time a new year rolls around, I think back to my younger years. I used to look forward and wonder "where I would be in the year 2000" or some other year. All those far-off years seemed so far distant.

Here we are now in 2015. Life still goes on with challenges and joys. I hope that as you are marching resolutely through the first month of the new year that you are enjoying what life has to throw your way.

Have a great week!

—Allen
     

ExcelTips (ribbon) for 24 January 2015

Find and Replace
Finding and Replacing with Subscripts

Want to use Find and Replace to change the formatting of a cell's contents? You would be out of luck; Excel won't let you do it. Here's a macro that can shed light on how to do the formatting, though.

Read this tip »

(Thanks to Steve Aprahamian, Jacques Raubenheimer, Andrija Vrcan, and Marcel Beugelsdijk for contributing to this tip.)

 
Excel can calculate date in lightening time
Working in Feet and Inches

Your chosen occupation may require that you work with linear distances in feet and inches. Excel can do this, to a degree, but you need to understand what the limitations are.

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.

 
Sorting
Incomplete and Corrupt Sorting

Using the sorting tools, on the toolbar, may result in some unwanted results, such as jumbled data. If this happens to you, the best thing to do (as described in this tip) is to figure out exactly what is being sorted by Excel.

Read this tip »

 
Worksheets
Detecting Types of Sheets in VBA

When processing workbook information in a macro, you may need to step through each worksheet to make some sort of changes. It is helpful to know what type of worksheets you are working with so that you don't try to make changes on an inappropriate worksheet.

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:

  • Inserting and Deleting Rows in a Protected Worksheet
  • Backing Up Custom Dictionaries
  • Adjusting Test Scores Proportionately
  • Formatting Canadian Postal Codes

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.

 
Inadvertantly Getting Rid of Frozen Panes

I have a worksheet with many rows and columns of data. I have frozen the first row and column by making cell B2 active and then freezing panes. This works as I want it to. I can even save and close the workbook, and the panes are still frozen when I reopen it. However, if I open a new window for the workbook (View | Window | New Window), the new window does not have frozen panes. As I have frozen panes on many worksheets in this workbook, I have to be very careful about which window I close first. If I close the original window first, when I save the workbook it saves all the unfrozen worksheets. Is there a way to get the new window to retain the frozen panes settings?
—Steven Morris (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