Microsoft Office Tutorials and References
In Depth Information
Working with Range Names
Saving a Worksheet
Picture yourself working for hours
to create the perfect worksheet and then your
neighborhood or office complex suffers a power
outage and all of your hard work is lost. Well,
that might have happened in the past, but Excel
has gone a long way to dispel that disheartening
experience with its AutoSave feature. Every 10
minutes, Excel will save a copy of your file. In
this way, even in the event of a power failure,
you can be sure that you will never lose more
than 10 minutes’ worth of work.
Saving the First Time
The first time you save your file, choose File >
Save As from the Ribbon. Excel displays the Save
As dialog box, as shown in Figure 1-32. From
the Save As dialog box, enter the following
information about your document.
File name: Feel free to be as descriptive
as you want, within reason. You have 255
characters, including spaces, to name
Location: Use the Save In folder or the
favorite links area to find the perfect
location in which to store this file.
But don’t rely solely on the AutoSave feature. Get
into the habit of saving your file shortly after you
begin working on it. You will be able to replace
the temporary Book1 file name with a more
descriptive name and store the file in an
appropriate location on your computer or network.
Save As Type: Excel Workbook, as shown
in Figure 1-32, is the default file type in
Excel 2010 files.
If you need to share your file with friends
who have not yet upgraded to Excel 2010,
you should change the file type. Click
the Save As Type down arrow and select
Excel 97-2003 Workbook. Other options
for sharing your files are discussed in
Chapter 14, “Collaborating with Others.”
The Save As dialog box in Excel 2010.