Monthly Archives: June 1997

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 →