Category Archives: Spreadsheets

Versions 4.x, 95 – If you have a relatively small Excel worksheet that is determined to print several blank pages, make sure you didn’t place a formula in some obscure cell far removed from your work area. Some people will … Continue reading →

Versions 4.x, 95 – Want to raise a number to a power? Excel gives you not one way to do this, but two. Let’s say you want to raise 10 to the fifth power. You can type 10^5 or Then … Continue reading →

Versions 4.x, 95 – If you’re developing a very large Excel worksheet, you may want to temporarily get rid of the automatic calculation option. This way you can enter all the formulas you want without ever having to wait for … Continue reading →

Versions 4.x, 95 – Microsoft has stated that all their current applications will deal properly with the year 2000. Don’t want to take their word for it? Check the Office applications yourself. (You can also use these same techniques to … Continue reading →

Do you use Excel 95’s Data Map? If so, you might like to transfer some of those neat maps to a Word document or a PowerPoint slide. It’s easy, you can cut and paste a If a person really wants … Continue reading →

Versions 4.x, 95 – In Excel, if you resize a worksheet’s cells, any chart on the worksheet will also be resized by default. If you’d like to change the cell sizes in one of your worksheets, but want to keep … Continue reading →

Versions 4.x, 95 – If you want to get to the last data cell in a worksheet, press Ctrl+End. There is only one problem with this, but it’s a small one: Pressing Ctrl+End will take you to the last cell … Continue reading →

Versions 4.x, 95 – Here’s a test to see how Excel deals with the year 2000: try a calculation that goes past January 1, 2000; say you want to see how many days there are between two dates. Select cells … Continue reading →

Version 4.x, 95 – Want to quickly sum a row of numbers in Excel? With all the numbers entered, click on the cell where you want the sum to appear. Now click the sum button in the toolbar This levitra … Continue reading →

Excel 7.0 and Office 95 – If you link data in Word as an Excel 7.0 worksheet, you won’t see any gridlines. However, if you make some changes to the linked worksheet in Excel, the gridlines will appear in Word. … Continue reading →