Monthly Archives: December 1997

Version 4.x, 95 – If you’d like to add the days of the current week to your worksheet on a Monday morning, you can select a cell and type =today() Now select five cells beginning with the one you just … Continue reading →

Version 4.x – Although special date formats aren’t so obvious in the Excel shipped with Office 4.x, they’re there. Type 12/25/97 in cell A1. Let’s suppose you’d like this date to appear in its most complete form. Click on cell … Continue reading →

Version 4.x, 95 – We’ve had e-mail from subscribers indicating that they have problems using the text box in Excel. Although we’ve covered this topic before, let’s take another look. To use a text box, first you have to have … Continue reading →

Version 4.x, 95 – Let’s suppose you’re in the process of developing a very large workbook with numerous worksheets. You could make the workbook look better by placing the most important totals on the first sheet. This leaves all the … Continue reading →

Version 4.x, 95 – Word isn’t the only Office program that can use headers and footers. You can use them in Excel, too. The process just isn’t as obvious or as versatile as it is in Word. Let’s say you’d … Continue reading →

Version 4.x, 95 – Here’s an Excel function you may not have seen. It’s called Proper and its job is to render text with initial capitals. Why would you need to use Proper? Well, if you purchase mailing lists, you … Continue reading →

Version 4.x, 95 – When you’re dealing with a large worksheet, you may have trouble finding all the formulas. All you see in the worksheet are the results. You can show the formulas in a worksheet by holding down Ctrl … Continue reading →

Version 4.x, 95 – We recently ran a tip describing 1900 as a leap year. Quite a few of you noticed that it was not–among them, T. P. and P. P. Congratulations! This fact has escaped Microsoft through at least … Continue reading →