Microsoft Office Tutorials and References
In Depth Information
The various sections in the Excel Options window let you tweak a wide variety
of different details. Some of these details are truly handy, like the options for
opening and saving files (which are described at the end of this chapter). Others
are seldom-used holdovers from the past, like the option that lets Excel act like
Lotus—an ancient piece of spreadsheet software—when you hit the / key.
Tip: Some important options have a small i-in-a-circle icon next to them, which stands for “information.”
Hover over this icon, and you see a tooltip that gives you a brief description about that setting.
While you’re getting to know Excel, you can comfortably ignore most of what’s in the
Excel Options window. Later on, though, you might want to return to adjust these
settings and fine-tune the way Excel works.
As everyone who’s been alive for at least three days knows, you should save your
work early and often. Excel is no exception. You have two choices for saving a
• Save As . This choice allows you to save your spreadsheet file with a new name.
You can use Save As the first time you save a new spreadsheet, or you can use
it to save a copy of your current spreadsheet with a new name, in a new folder,
or as a different file type. (Alternate file formats are discussed starting on page
374.) To use Save As, select File ➝ Save As, or press F12.
• Save & Send. The File ➝ Save & Send page in Excel’s backstage view provides
several of the same options you get from the Save As dialog box. The difference is
that it makes them a bit more convenient. Figure 14-16 shows what to look for.
• Save . This option updates the spreadsheet file with your most recent changes.
If you use Save on a new file that hasn’t been saved before, it has the same
effect as Save As: Excel prompts you to choose a folder and file name. To use
Save, select File ➝ Save, or press Ctrl+S. Or look up at the top of the Excel
window in the Quick Access toolbar for the tiny Save button, which looks like
an old-style diskette.
Tip: Resaving a spreadsheet is an almost instantaneous operation, and you should get used to doing it
regularly. After you’ve made any significant change, just hit Ctrl+S to make sure you’ve stored the latest
version of your data.