Learning by the Book

You know that over the previous two weeks I've been accepting students into my Using Dates and Times online course. Well, the doors to that course are now closed, and I'm no longer accepting students.

I know, however, that not everyone learns in the same way. Some people learn well through the use of video courses, while others learn well through the use of "the printed word."

One of the things I did when I released the video course is that I also updated my ExcelTips: Times and Dates e-book. Now in it's ninth edition, it has been completely updated for the latest versions of Excel. (It was last updated over four years ago.)

If you are one of those who learns best through books, you'll be glad to hear that ExcelTips: Times and Dates is currently, and for a very short time, available at 30% off its regular price. You can find full information here:

https://store.tips.net/T010154

Check it out today. This special will be available only through September 29.

—Allen
     

ExcelTips (ribbon) for 18 September 2021

Column formatting
Widening a Column to a Particular Cell's Width

Do you want to set a column's width based on whatever is in the currently selected cell? There are actually a number of ways you can accomplish the task, each of which is detailed in this tip.

Read this tip »

(Thanks to Ryszard Raciborski, Neil Woller, James Woolley, Ken Cameron, Wayne Edmondson, Tomek Dluzniewski, Jacques Raubenheimer, Roy Burton, Bob Beechey, David Gray, Thomas Papavasiliou, Mark Galloway, and Rusty Chiles for contributing to this tip.)

 
Printing
Changing Cell Values while Printing

When printing mulitiple copies of the same worksheet, you may have a need to change something simple for each of the copies. This tip examines how you can easily change the value in a single cell between each printed copy.

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!

 
Online and web
Specifying Your Target Monitor

When you create a worksheet that is destined for viewing on the Web, you will want to specify the monitor resolution you expect users to have when viewing your data. This information is used by Excel as it generates HTML files from the worksheets.

Read this tip »

 
Editing
Defining Shortcut Keys for Symbols

Do you need to use symbols frequently in your Excel data? The common way to insert them is by using the Symbol dialog box. Here are some other, quicker ways to use the symbols you need.

Read this tip »

 
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 »

 
Powerful spreadsheets
Putting a Different Date in a Header

Today's date is easy to add to a header, but what if you want to add a date that is adjusted in some manner? Adding yesterday's date or tomorrow's date, for instance, is easy if you use the macro provided in this tip.

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.

 
Adding a Tool to Clear Borders

I added, on the Quick Access Toolbar, the All Borders command. I want to add a way to clear all the borders. I added the No Borders command, but it doesn't clear borders; it changes the borders to match the last border option that I chose.
—Larry Schwartz (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