Understanding Excel Filenames


Each workbook that you create in Excel can be saved with a unique, meaningful name . Filenames can contain up to 256 characters and include both uppercase and lowercase letters , spaces, and punctuation. However, just because you can use up to 256 characters doesn't mean that each filename should be a long, rambling sentence . Filenames that are too long are almost as frustrating as filenames that are too short! Try to use as few words as possible to name your workbooks.

graphics/bookpencil_icon.gif

Check with your co-workers or network administrator to determine whether your company has adopted naming standards for files. For example, filenames might include a departmental name, the project title, or the year.


graphics/alarmclock_icon.gif

If you're using Excel in the office or you're going to share your files with others, make sure that everyone is using a version of Excel (and Windows) that supports long filenames. Excel for Office 95, Excel 97, Excel 2000, Excel 2002, Excel 2003, and Excel XP all support long filenames. If you're working with an earlier version of Excel , a long filename is truncated and contains a tilde (~) character at the end, such as LEGALDE~.


File Extensions Tell a Tale

You might have noticed when you saved the practice file that Excel assigned a period character and then a three-letter suffix at the end of the filename. The software program generally assigns file extensions. Excel workbook files are assigned the extension .XLS by default.

graphics/lightbulb_icon.gif

It's not necessary to type the file extension when you're naming a file. Excel looks at the file type that's selected and adds the correct extension.


graphics/alarmclock_icon.gif

Make sure that you don't change the file extension. Although you might think that using a file extension like .BUD to identify all your budget files is a good idea, you'll have a hard time finding those files later.


The extension on a filename is a road map for Windows. When you open a file, Windows uses the file extension to determine which program that file belongs to. Table 3.2 shows the most common file extensions used by Excel and explains a bit about them.

Table 3.2. Excel File Extensions

File Extension

What It Means

XLS

Microsoft Excel workbook

XLT

Microsoft Excel template

HTM or HTML

Web page

XLA

Microsoft Excel add-in

XLW

Microsoft Excel workspace



Sams Teach Yourself Microsoft Office Excel 2003 in 24 Hours
Sams Teach Yourself Microsoft Office Excel 2003 in 24 Hours (Sams Teach Yourself in 24 Hours)
ISBN: 1435276337
EAN: 2147483647
Year: 2003
Pages: 279
Authors: Trudi Reisner

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net