• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL

Hour 3. Organizing Your Files > Saving Your Workbook

Saving Your Workbook

If you don't save your workbooks, you're playing a form of computerized Russian roulette. Your unsaved work is unprotected. If the power goes off or your system crashes, your worksheet is gone forever. Saving your work takes a few brief seconds and ensures that you or your colleagues will be able to open the workbook later. A saved workbook can be stored indefinitely.

When you save your work in Excel, you need to consider a few points:

  • The location of the saved file— You can save to your computer's hard drive or to a floppy disk. If you're working on a network, you can save your files to a drive and folder on the network.

  • The name of the file— The filename should be descriptive so that you or someone else can identify it. A cryptic name like SMBUD might make sense at the time you save the file, but will probably confuse you and everyone else later, especially if you need to locate that one file from a long list.

  • The format of the file— If everyone in your office is using the same version of Excel, you won't have any problems. However, in many offices, multiple versions of Excel are in use. If you use a feature that isn't present in an earlier version of Excel, someone opening your file in an earlier version won't see that feature's results.

Navigating Through Files and Folders

In most cases, when you save a file, Excel automatically saves it to the My Documents folder located on your computer. However, you can place the file anywhere you like. If you're working on a network, your network administrator must have granted you access rights to save a file in a network folder.

Network folder A folder that's located on one of the network drives. Network folders can be shared so that everyone on the network can access them, or they can be private, so that only you or your workgroup can access them.

Many Excel users are confused by the storage system that Windows uses for files and folders. Actually, the file system is simple to understand. Windows uses a file folder metaphor for organizing the files on your computer. Both the files you create and the software programs you used to create them are stored in folders. You work with computer folders just the way you work with the paper files in your office. You can create a filing system that contains many subfolders, or you can use a top-level folder to store your files.

The folders are stored on drives that are lettered alphabetically. A computer drive is the electronic equivalent of a filing cabinet. The hard drive on your computer is usually called the C: drive. If you're working on a newer computer with a large hard drive, your hard drive might be partitioned into more than one drive—say C, D, and E. Network users can have many drives available.

Picture your drives and folders arranged in one large file room. The order of your drives and folders is arranged hierarchically. Each filing cabinet in the room represents another drive. Within each drive is a group of folders. A folder can contain files, subfolders, or a combination of both.

If you were actually filing papers in a real file room, you'd need to put away the folders in one filing cabinet before you could open the drawers on another cabinet. Electronic filing is much the same. You need to navigate up through the folders on one drive before you can go to another drive.

If you're familiar with the old MS-DOS filing system, a folder is the equivalent of a directory, and a folder within a folder is analogous to a sub directory.

  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint