Category Archives: Spreadsheets

Let’s say you have a worksheet designed to handle your widget sales. Here you are at the start of your fiscal year and you know you must realize at least $2,000,000 in widget sales during the coming year to meet … Continue reading →

In the last tip, we showed you how to modify the colors of the bars in a bar chart. You can do the same for your pie charts, but the method is slightly different. Insert your pie chart. You’ll get … Continue reading →

When you create a chart in Excel (or any other Office program) you may find the default chart colors a bit drab. Let’s say you have three bars in a bar chart. By default, the bars will appear as light … Continue reading →

In Excel, you can copy a group of cells by selecting them and then pressing Ctrl-C. This copies the cells to the Windows Clipboard. Now you can move to another cell range and press Ctrl-V to paste the cells to … Continue reading →

In Microsoft Office 97 for Windows (or Excel 97, Word 97, or PowerPoint 97), if you use the Microsoft Web browser control to go from one document to another of the same kind, you may get one of these error … Continue reading →

Version 4.x, 95 – If you’d like to know how many days left until St. Patrick’s day, run Excel and type =”03/17/98″ – “01/15/98” ‘ or today’s date into a cell. Excel will return the number of days (61) between … Continue reading →

Version 4.x, 95 – There are times when you might need to use an Excel file in some program that doesn’t use Excel files. If this happens to you, check to see what kind of files the program will handle. … Continue reading →

Version 4.x, 95 – You can do more with Excel’s date formatting than you might think. Suppose you’d like a particular cell to show only the month and the day. Click the cell (to select it) then choose Format, Cells … Continue reading →

Links go only so far between Access and Excel. If you create a link table in Microsoft Access 97 that links to a worksheet in an Excel 97 for Windows workbook, be careful. If you change a value or values … Continue reading →

Here’s the latest chapter in the long-standing, barely veiled reluctance of Lotus and Microsoft to make their programs work well together. Lotus has confirmed that there is a potentially serious problem when using Lotus Notes 4.x’s viewer for Excel files. … Continue reading →