Happy Labor Day

Here we are at the end of August already. In the United States, we are also just entering into a holiday weekend (Labor Day). People will be having picnics and going on trips in order to wring the very last out of their hectic summers.

I hope that whatever is happening in your area of the world that you take some time away from the hustle and bustle to enjoy the fleeting moments that pass us all too quickly without our notice.

My best to you and yours.


ExcelTips (ribbon) for 30 August 2014

Time formulas
Automatically Entering a Data Entry Time

Excel worksheets can be used to keep track of all sorts of information. You may want to use it, for instance, to track entries made at specific times. Here are ways to "time stamp" your entries automatically.

Read this tip »

(Thanks to Steve Aprahamian, Leslie Glasser, Clive Darling, Mark Groessl, Guy Goodwin, Joyce Conklin, Bud Beaty, Jacques Raubenheimer, Bob Beechey, Peter Atherton, Ron Solecki, Brian Hershman, Rebekah Pierce, John Lindsey, Carole Haley, Don Bruck, Bruce Lyon, Cedrick McKeever, Ioannis Nikolopoulos, and Phil Pound for contributing to this tip.)

Powerful spreadsheets
Editing PivotTables without Underlying Data

If you ever try to edit a PivotTable and get an error that tells you that the "underlying data was not included," it can be frustrating. This tip looks at possible causes for this error and how you can solve the problem.

Read this tip »

Lookup Exactly the Data You Want

Excel's lookup functions are easily the most powerful worksheet functions you can use. Master these seven functions you'll never again view a worksheet full of data in the same way. The power these functions provide you is anything but small. Take your first step today!

Nifty Zooming

If you are using a mouse that has a center wheel, you can use the wheel to zoom in and out of your work. This tip shows how easy it is to make the necessary configuration change in Excel.

Read this tip »

Macros extend Excel
Maximum Length Limit for a Macro

Make your macros too long, and Excel may just refuse to run them at all. This tip explains what the limit is for macros, and provides some guidance on how you can get around the limit.

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:

  • Calculating Monthly Interest Charges
  • Controlling Entry Order on Unprotected Cells
  • Drawing Simple Objects
  • Returning the MODE of a Range

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.

F4 No Longer Changes Cell References

I recently bought a new computer that uses Windows 8.1. I've found that I can no longer use F4 as a method of toggling a cell reference through the absolute/relative settings. Instead, F4 opens a sidebar about projecting to a second monitor. As I only have one monitor, but lots of requirements to set cell references to and from absolute, this is driving me crazy! How can F4 be set to work as it has traditionally worked in Excel?
—Hazel Kohler (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