Excel Tips

Shorten ZIP Codes in Excel

If you are an Excel worksheet that contains address information, you may want to convert nine-digit ZIP Codes to their five-digit equivalent.

Excel.Tips.Net: Single-Use Drop-Down List

This list allows users to select the cell and then select from a list of pre-defined values for that cell. Once the user makes a selection and moves to a different cell, the arrow for the drop-down list disappears.

Excel.Tips.Net: Ages in Years and Months

Many times in early childhood education, a child’s age in Years.Months format is needed for reporting, admitting, and evaluation. Basically, this format shows the number of elapsed years and months since birth, separated by a period.

Excel.Tips.Net: Importing Multiple Files to a Single Workbook

Let’s say that you have a folder on your hard drive that contains thirty text files, and you want to import all of them to an Excel workbook. You want each text file to end up on its own worksheet in the workbook, so that you will have a total of thirty worksheets.