Tips, Tricks, and Answers

The following articles are available. Click the article's title (shown in bold) to see the associated article.

Centering Across Columns Excel allows the headings of a workbook to be centered across several columns. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Changing Column Width Easily change column widths with this Excel tip. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Countering Compressed Columns If you open a workbook and find that the width of some of your columns has been changed, the discovery can be frustrating. Here’s some ideas on why this might occur in some workbooks. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Double-Clicking to Widen Columns Won't Work A common way of adjusting the width of a column is to double-click the dividing line at the right edge of the column. Such an easy approach doesn’t work in all instances, however. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Hiding and Unhiding Columns Not all columns must be visible. In fact, you can easily hide and then redisplay any columns you desire. This tip gives the rundown on how to make this change. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Hiding Columns Not within a Date Range Many people use Excel to track lots and lots of data. Hiding some of that data based upon some criteria, such as whether the data is outside of a date range, can be very helpful. This tip illustrates such a scenario and shows how you can use a macro to hide one range of columns while displaying another, all based upon the current date. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Setting the Standard Column Width Using Excel's menu option to set the standard column width for an Excel worksheet. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Understanding Column Widths A handy explanation of how Excel determines the column widths. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Unhiding a Single Column In a worksheet with lots of hidden columns it is a real pain to try to unhide just one or two columns. The best solution is to use a macro to do the unhiding, as described in this tip. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Helpful Links

Ask an Excel Question
Make a Comment

Tips.Net Home

ExcelTips FAQ
ExcelTips Premium

Learn Access Now

Beauty Tips
Bugs and Pests Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Money Tips
Organizing Tips
Pet Tips
Word2007 Tips
WordTips

Advertise on the
ExcelTips Site

 

RSS Feeds

 Daily Nuggets (an ExcelTip every day)

 Allen Wyatt's ExcelTips (the weekly classic)