Another Holiday!

Most people know that earlier this month folks in the United States celebrated Independence Day. Well, for those of us in Utah, there is second major holiday (a state holiday) that occurs during the month. This past week, on July 24, our state celebrated what is known as Pioneer Day.

This day celebrates July 24, 1847, the day that the first pioneers entered the Great Salt Lake Valley and started establishing the first permanent settlements in what would later (in 1896) become the state of Utah.

The day is marked by parades, picnics, fireworks, and outdoor activities. In our neighborhood I believe there were just as many fireworks set off as there were three weeks before, for Independence Day. We even had a block party that drew dozens of people to our front yards.

With two major holidays, July tends to be a pretty busy months for Utah residents. The festivities are all over now, however, and we will soon enter the not-so-hectic days of August.

I hope you have a great week and enjoy the tips in this issue of the newsletter.


ExcelTips (ribbon) for 26 July 2014

Cell formatting
Select One Cell and Make Another Cell Bold

Excel provides a number of different ways you can apply formatting to a cell based upon various dynamic conditions. One condition it doesn't allow you to check, however, is which cell is selected. Here's how you can get around that and apply formatting based upon whatever cell you have selected at the time.

Read this tip »

(Thanks to Steve Aprahamian, Guy Goodwin, Peter Atherton, Bob Beechey, David Shepherd, Mike McEldowney, Piers Morgan-Harvey, and Christian Boissinotte for contributing to this tip.)

Linking workbooks
Easily Changing Links

If you have linked information in your worksheets, you may want a way you can easily change the targets to which those links are pointing. One way you can do this is to make the links dynamic, using the INDIRECT worksheet function.

Read this tip »

Enhance Your Excel Skills with Macros

Macros are a great way to increase your productivity with Excel by making the program work the way you want it to work. Discover the true power behind macros; ExcelTips: The Macros puts almost 800 pages of macro-focused information at your fingertips. Discover more...

Powerful spreadsheets
Clearing the Print Area

Excel allows you to specify which portions of a worksheet should be printed when you send output to your printer. If you want to get rid of a defined print area, there are a couple of ways you can do it.

Read this tip »

Powerful spreadsheets
Spreading Out a Table

If someone sends you a worksheet that has lots of data in it, you might want to "spread out" the data so you can have some blank rows included between each existing row. This is easy to do using the handy macro in this tip.

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:

  • Pulling a Phone Number with a Known First and Last Name
  • Understanding Manual Calculation
  • Finding the Sum of a Sequential Integer Range
  • Deleting a File in a Macro

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.

Creating a Dated Backup File

Every time I close a workbook, I'd like to have Excel create a dated backup of that workbook, meaning that it is saved using a filename that includes the date. Thus, if I save "AnyWorkbookName," it would save not just under that name, but also under the name "AnyWorkbookName [Today's Date & Time]." I'm sure this needs to be done with VBA, but I'm not sure how to go about it.
—Mathew McAllister (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