FEU FERN COLLEGE
uthorized duplication not allowed
Saving
FEU FERN COLLEGE
Introduction
Are you saving a workbook for the first
time?
Saving it as another name?
Sharing it with someone who doesn't have
Excel 2010?
There are many ways you share and
receive workbooks, which will affect
how you need to save the file.
uthorized duplication not allowed
FEU FERN COLLEGE
Introduction
In this lesson, you will learn how to use the
Save and Save As commands how to
save as an Excel 97-2003 compatible
workbook, and how to save as a PDF.
uthorized duplication not allowed
FEU FERN COLLEGE
uthorized duplication not allowed
Saving
Workbooks
FEU FERN COLLEGE
Saving workbooks
When you create a new workbook in Excel,
youll need to know how to save it to
access and edit it later.
Excel allows you to save your documents in
several ways.
uthorized duplication not allowed
FEU FERN COLLEGE
To use the Save As command
Save As allows you to choose a name and
location for your workbook.
Use it if you are saving a workbook for the
first time or if you want to save a
different version of a workbook while
keeping the original.
uthorized duplication not allowed
FEU FERN COLLEGE
To use the Save As command
1.
2.
3.
4.
Click the File tab.
Select Save As.
The Save As dialog box will appear.
Select the location where you want to
save the workbook.
Enter a name for the workbook, then
click Save.
uthorized duplication not allowed
FEU FERN COLLEGE
To use the Save As command
uthorized duplication not allowed
FEU FERN COLLEGE
To use the Save command
1.
Click the Save command on the Quick
Access toolbar.
2.
The workbook will be saved in its
current location with the same file
name.
uthorized duplication not allowed
FEU FERN COLLEGE
To use AutoRecover
Excel automatically saves your workbooks
to a temporary folder while youre
working on them.
If you forget to save your changes or if Excel
crashes, you can recover the autosaved
file.
uthorized duplication not allowed
10
FEU FERN COLLEGE
To use AutoRecover
1.
Open a workbook that was previously
closed without saving.
2.
In Backstage view, click Info.
3.
If there are autosaved versions of your
workbook, the will appear under
Versions. Click the file to open it.
uthorized duplication not allowed
11
FEU FERN COLLEGE
uthorized duplication not allowed
To use AutoRecover
12
FEU FERN COLLEGE
To use AutoRecover
4.
A yellow caution note will appear on the
Ribbon of the workbook. To restore this
version of the workbook, click Restore,
then click OK.
uthorized duplication not allowed
13
FEU FERN COLLEGE
To use AutoRecover
By default, Excel autosaves every 10
minutes.
If you are editing workbook for less than 10
minutes, Excel may not create an
autosaved version.
uthorized duplication not allowed
14
FEU FERN COLLEGE
To use AutoRecover
If you do not see the file you're looking for
or if you're looking for an autosaved
version of a file that has no previously
saved versionsyou can browse all
autosaved files by clicking the Manage
Versions button and selecting Recover
Unsaved Workbooks from the drop-down
menu.
uthorized duplication not allowed
15
FEU FERN COLLEGE
uthorized duplication not allowed
To use AutoRecover
16
FEU FERN COLLEGE
To save an as Excel 97-2003
You can share your workbooks with anyone
using Excel 2010 or 2007 because they
use the same file format.
However, earlier versions of Excel use a
different file format, so if you want to
share your workbook with someone
using an earlier version of Excel you will
need to save it as an Excel 97-2003
workbook.
uthorized duplication not allowed
17
FEU FERN COLLEGE
To save an as Excel 97-2003
1.
2.
3.
4.
5.
Click the File tab.
Select Save As.
In the Save as type drop-down menu,
select Excel 97-2003 Workbook.
Select the location where you want to
save the file.
Enter a name for the file, then click
Save.
uthorized duplication not allowed
18
FEU FERN COLLEGE
To save as a PDF
Saving your workbook as an Adobe
Acrobat Documentwhich is called a
PDF filecan be especially useful when
your recipients do not have Excel.
A PDF will make it possible for recipients to
view the content from your workbook,
but they will not be able to edit
anything.
uthorized duplication not allowed
19
FEU FERN COLLEGE
To save as a PDF
1.
2.
3.
4.
5.
Click the File tab.
Select Save As.
In the Save as type drop-down menu,
select PDF.
Select the location where you want to
save the file.
Enter a name for the file, then click
Save.
uthorized duplication not allowed
20
FEU FERN COLLEGE
uthorized duplication not allowed
To save as a PDF
21
FEU FERN COLLEGE
To save as a PDF
Excel defaults to saving the active
worksheet only.
If you have multiple worksheets and want
to save all of them in the same PDF file,
click Options. The Options dialog box
will appear. Select Entire workbook
from the Options dialog box, then click
OK.
uthorized duplication not allowed
22
FEU FERN COLLEGE
uthorized duplication not allowed
To save as a PDF
23
