Visiting Arizona

Did you notice that today's date is a progression of numbers? December 12, 2014 is 12/13/14, which I think is pretty cool in a trivial sort of way. It also is a once-in-a-lifetime occurrence. (This precise sequence won't happen for another 100 years.)

As many long-time readers know, I often make trips from our home in Utah down to Arizona to visit my parents. This weekend finds me in the middle of one such trip, and this is a great time to visit Arizona (weather-wise). The temperatures are mild and it is a nice break from the cold weather back home.

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

—Allen
     

ExcelTips (ribbon) for 13 December 2014

Editing
Dates Copied Incorrectly

Under the right circumstances, you may notice problems when copying dates from one workbook to another. This tip explains the cause of these types of problems and what you can do about it.

Read this tip »

(Thanks to Steve Aprahamian, Trevor Shuttleworth, Guy Goodwin, Dave Onorato, Peter Atherton, Richard Haines, Bob Beechey, Jacques Raubenheimer, Steve Tice, and Maarten Daams for contributing to this tip.)

 
Online and web
Converting to Hyperlinks in a Shared Workbook

When you enter a URL or e-mail address in a worksheet, Excel usually converts it to a clickable hyperlink. This doesn't occur, however, if the workbook is shared; the URL or address remains regular text. This tip discusses ways you can get around this behavior so that you have clickable hyperlinks in shared workbooks.

Read this tip »

 
Macros! Macros! Get Your Macros Here!

Learn all the best methods for creating and using Excel macros. ExcelTips: The Macros is the best single source for learning about macros or improving your existing skills. Be the person everyone looks to when something needs to happen in Excel. Get yours today!

 
Worksheet functions
Finding the Lowest Numbers

Need to find the lowest numbers in a range of values? It's easy to do using the SMALL worksheet function, or you can use a macro for more demanding needs.

Read this tip »

 
Sorting
Sorting while Ignoring Leading Characters

Want to ignore some characters at the beginning of each cell when sorting? The easiest way is to simply create other cells that hold only the characters you want to use in the sorting.

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:

  • Altering the Displayed Format of Numbers to the Nearest 100
  • Shortening ZIP Codes
  • Getting Rid of All Hyperlinks
  • Printing an Entire Workbook by Default

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.

 
Macro, while Running, Stops Excel from Responding

When I write a macro that must process a lot of information in a For...Next loop, I always use the status bar to indicate progress. Typically, I'll have a message displayed there such as "Processing row X of Y." When "Y" is a large value (the top end of the For...Next loop), Excel often stops updating the status bar and displays something like "Not Responding" in Excel's title bar. The macro is still running, though, and when it completes, Excel starts responding and everything works like it should. How can I make Excel stop behaving in this manner and, instead, display the status bar updates like I want?
—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