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.)

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!

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 »

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 »

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 »

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 »

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)