Time is Running Out

Time is running out to take advantage of the introductory offer on the new versions of the Excel Filters and Filtering e-books. I released these updated volumes about 10 days ago, and they are great. They explain, in detail, how to use both AutoFilter and advanced filtering. The haven't been updated in over 3 years, so this is a major update!

As I mentioned when I released the e-books, the introductory sale is available only through Wednesday, November 22, which is this coming Wednesday. Through that day you can get any version of the e-books for 30% off the regular price. In addition, I provide a simple way that you can get 2 versions for free, if you need multiple versions.

But, like I said, time is running out. So make sure you check the Tips.Net Store for more information.

I hope you enjoy the tips in this issue of the newsletter, and I hope that your Thanksgiving week is a great one!


ExcelTips (ribbon) for 18 November 2017

Cell formatting
Enforcing a Desired Font

If your workbooks are shared and used by a number of different people, you may end up with some formatting in those workbooks that you don't want. This tip looks at a simple way to make sure that a particular font is always used in a workbook.

Read this tip »

(Thanks to Michael Avidan (MVP), Henk Haringsma, Bob Beechey, and Paul Thomson for contributing to this tip.)

Inserting a Picture in Your Worksheet

Worksheets can contain more than just text and numbers. Here's the low-down on the different types of pictures you can add and how to do it.

Read this tip »

Baffled by Array Formulas?

Have you heard about the special array formulas you can create in Excel? They make it a snap to perform calculations using large amounts of data and even generate results you can't get with regular formulas. Array formulas may be Excel's best-kept secret. Remove the confusion; discover how to use array formulas today.

Macros extend Excel
Converting Strings to Numbers

When working with data in a macro, there are two broad categories you can manipulate: numbers and text. Sometimes you need to convert information from one category (data type) to another. Here is how you convert text to numbers.

Read this tip »

Customizing Excel
Turning Off Display of Zeros for All Worksheets

Some people like zero values displayed; others do not. Excel allows you to easily turn the display on or off for a single workbook. Here are some ideas for doing it for all workbooks.

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.

Working with Huge Datasets

My computer has a fast processor and 32 GB of RAM. For statistical purposes, I often need to use million-line worksheets. I'm still using Excel 2007, and it doesn't work well after it's run awhile with these huge workbooks. (In fact, it frequently crashes.) Other times, after startup, it works OK. What can I do to get more reliable operation when working with such large datasets? Would Excel 365 work better? Perhaps more RAM?
—Norman Samish (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 1187  •  Mountain View, WY  82939  •  307-200-0450