Catching Up

Things have been quiet around the Wyatt household this week. I've gotten caught up on a couple of projects that I inadvertently neglected; that always is satisfying for me. Now I've got another week to look forward to and (hopefully) get better organized with respect to those projects.

I hope your weekend is going well and you are looking forward to the coming week. Enjoy the tips!


ExcelTips (ribbon) for 29 August 2015

Macros extend Excel
Finding Positions of Formatted Characters in a Cell

With a little bit of work, Excel allows you to format individual characters of the text you place in a cell. If you want to later find which characters are formatted as, say, bold or italic, you'll need to use one of the macros provided in this tip.

Read this tip »

(Thanks to Steve Aprahamian, Juan de Frutos, David Shepherd for contributing to this tip.)

Finding the First Non-Digit in a Text Value

If you have a string of text that is composed of digits and non-digits, you may want to know where the digits stop and the non-digits begin. There are a couple of ways you can determine this demarcation line, as described in this tip.

Read this tip »

(Thanks to Michael Avidan, MVP, for contributing to this tip.)

PivotTables Make You Feel Faint?

Do you get weak in the knees when asked to deal with huge amounts of data? Forget feeling faint ever again when you are asked to deal with PivotTables. Learn much more than the basics with PivotTables for the Faint of Heart, now available in three great versions.

Data forms
Using Data Forms

Lots of people prefer to enter information directly into Excel, but there is another way that may be helpful: Using data forms. This tip introduces data forms, explains how to display them, and shows how easy it is to use them for editing your data.

Read this tip »

Excel can calculate date in lightening time
Excluding Values from Averaging

Calculating an average of a group of numbers is easy. What if you want to exclude a couple of the numbers from the group you are averaging? Here's the tools you need to develop a formula that will give you what you want.

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.

Remembering Workbook Position and Size

I have a need to always open a particular Excel workbook in the same location on the screen and with a particular window size. Is there a way to have Excel remember this location and size information upon closing the workbook so it is used when that same workbook is next opened?
—Walter Rosocha (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