Tips for Excel 97/98/2000/XP

You can find tips about Microsoft Excel 97/98/2000. Most of the tips are english version, a few are german version.
New tips are marked with

English articles

Add a dropdown list to a cell in Excel
An organization tip for (UserForm) control freaks in Excel
Automatically display a specific Excel sheet
Calculate the number of days between two dates
Change Excel's default number of worksheets
Change the way you enter formulas in Excel revisited
Changing quickly relative cell reference
Copying data validation rules to other cells
Create an Outlook 98 task item from directly from Excel
Creating a custom fill series in Excel
Creating hyperlinks using Excel's HYPERLINK() function
Create links in Excel to Outlook contacts
Disable in-cell editing or create hyperlinks to recapture an old shortcut in Excel
Disabling truncated pull-down menus
Easily create multiple sums in Excel at once
Eight timesaving Excel shortcuts
Enter repetitive data quickly
Freeze Excel column and row titles
Go to the cell at the end of a range
Moving worksheets between Excel workbooks
Quickly add sheets to an Excel workbook
Quickly create weekly column headings in Excel revisited
Quickly sum cell values without modifying a worksheet
Restrict cell data input to certain values
Select an Entire Range of Cells in Excel
Setting Excel's print area
Share a workbook
Taking advantage of Excel's Name box
The One Excel 2000 Keyboard Shortcut Everyone Should Know Turn off the Excel splash screen

 

German articles

Anzahl der Werte größer Null ermitteln
Differenz bis zum Monatsende berechnen

Doppelte Einträge in Excel verhindern
Fehlende Datenpunkte in Diagrammen
Formatierungen schnell kopieren
Formelzellen in einer Tabelle einfärben
Hyperlink in ein Diagramm einfügen
Leistungsfähige Auswertungen mit wenigen Mausklicks
Rahmenlinien in Excel-Tabellen zeichnen
Symbole per Doppelklick einfügen
Tastenkombinationen innerhalb der Datei-Dialoge von Office 2000
Tastenkombinationen für Excel
Undokumentierte Doppelbelegung von Excel-Symbolen
Verknüpfte Dateien schnell öffnen und relevante Bereiche finden
Verknüpfungen in Excel 2000/2002 optimal im Griff haben
Wie kann ich mit Excel die Differenz zweier Zeiten berechnen?

 

Some useful links

Excel 2000 Tips on Microsoft`s Webpage