Getting Help And Maintenance
If
you have forgotten certain commands or you want to explore new
features, the built-in Excel Help can be very useful. When you
access the Help system, the details and execution of every task is
just a mouse click away. You can search for topics and move forward
and back through topics.
Note:
The new design of the Help feature in the 2007 Microsoft Office
system does not include the Microsoft Office Assistant.
Getting
Help From The Microsoft Office Excel Help
You
can type specific words or phrases in the Search
box to return a list of possible answers.
You
can click on the Table
of Contents
link to browse for the help you need.
|
If
you are connected to the Internet, you can access the Microsoft
Office Online
web site, which offers online help. .documents, templates, add-ins,
and online training.
Microsoft
Office 2007 provides convenient ways to help you maintain and update
Office 2007.
Getting
Office Updates From Microsoft Update Site
You
can get the latest updates and new features to keep your programs
up-to-date from the Microsoft
Update
Site. From time to time, you should check for any updates and new
features from this site. The website checks your programs and lists
the latest updates for you to download.
Maintaining
The Excel Program
Office
2007 is able to detect and repair problems such as missing files and
registry settings associated with all installed Microsoft Office
programs. However, it does not repair user-created files, such as
spreadsheets or documents. If the problem persists after using the
Microsoft Office Diagnostics, you might need to reinstall Microsoft
Office.
Microsoft
Office Diagnostics is a new feature in the 2007 Microsoft Office
system that provides more comprehensive testing and repair
capabilities. It replaces the Detect and Repair feature in Microsoft
Office 2003.
Recovering
Files
Excel
will automatically recover a corrupted data file when it encounters a
problem such as power failure. The Document Recovery task pane
appears the next time you open Excel, giving you the options to open
the files, save, delete or show repairs. You can change the
AutoRecovery settings or disable the feature if you want.
How To Search Help
SUMMARY
Click
the Microsoft Office Excel Help
button.
In
the Search box,
enter a word, phrase, or question for which you want to get
help, and then press <Enter>.
In
the Help window, click a blue topic and read more information
about the topic.
|
TIPS
|
C
lick
the Microsoft
Office Excel Help button.
You
can also press <F1> to open the Excel Help window.
In
the Search box,
type print
and press <Enter>.
Excel
displays the search results with topics that may provide the help
you need.
I
n
the Excel Help window, click Print
a worksheet or workbook.
You
can click and read the information in the Help window to learn
more about the topic.
|
How To Use The Help Contents
SUMMARY
Click
the Microsoft Office Excel Help
button.
Click
the Show Table of Contents.
Click
a help topic to expand its subtopics and click the link to get
further information.
|
|
Click the Microsoft
Office Excel Help button.
You
can also press <F1> to open the Excel Help window.
Click
Show Table of Contents.
A
list of help topics appears in the window, as shown below.
Click
a help topic to expand its subtopics and click the link to get
further information on the related topics.
Here,
you can click the Accessibility topic, and then click the Excel
shortcut and function keys to display the related information, as
shown below.
Then, click the
Close
button to close the Help window.
|
How To Get Help From Office Online
SUMMARY
Click
the Microsoft Office Excel Help
button.
Click
the Offline button.
Click
Show content from Office Online.
|
TIPS
|
You can choose to access
Microsoft Office Online directly from Microsoft Excel 2007 instead
of those help installed on your computer. By using the Microsoft
Office Online command on the Help menu. This makes it
possible to get accurate, up-to-date and additional resources for
getting assistance and solving problems in Office Excel 2007.
Click the Microsoft
Office Excel Help button.
You
can also press <F1> to open the Excel Help window.
Click
the Offline
button.
It
is located at the lower right corner of the Help window. The
Connection Status menu appears, as shown below.
Click
Show
content from Office Online.
Basically,
Microsoft Office Online services can be classified into different
sections as shown in the following table. The button changes to
`Connected to Office Online’ and the information on the Help
window is updated, as shown below.
|
How To Get Help On A Command
SUMMARY
Place
your pointer on the command button, for which you want to get
help.
If
you see the message `Press F1 for more help’, press <F1>.
|
|
Mouse your mouse
pointer over the Font
Color button on the Ribbon.
A
ScreenTip is displayed. Some of the ScreenTips have the message
`Press F1 for more help’, as shown below.
Press
<F1>.
Only
the command button that has the message `Press F1 for more help’
will display the help content related to the command button you
are pointing at.
|
How To Get Help In A Dialog Box
SUMMARY
Display
the dialog box in which you want to get help.
Click
the
Help button in
the upper-right corner of the dialog box.
|
|
Display
the dialog box in which you want to get help.
In
the example below, click the Home tab. Then, click the Font
Dialog Box Launcher
to
display the Format Cells dialog box.
Click
the
Help button in
the upper-right corner of the dialog box.
Excel
displays the help content in the help window, as shown below:
|
How To Get Office Updates From Microsoft Update Site
SUMMARY
Click
the Office Button.
Click
the Excel Options
button.
Click
Resources, and then
click the Check for updates
button.
Follow
the instructions on the Microsoft Update site.
|
|
Click
the Office
Button, and then click the Excel
Options
button.
Excel
Options dialog box appears.
Click
Resources,
and then click the Check
for Updates button.
The
Microsoft Office Online checks your Office programs and list the
updates you need.
Follow
the instructions that appear on the Microsoft Update site.
Your
Microsoft Office is updated.
|
How To Run Microsoft Office Diagnostics
SUMMARY
Click
the Office Button.
Click
the Excel Options
button.
Click
Resources, and then
click the Diagnose
button..
Click
the Start button.
Click
the Continue
button.
Click
the Run Diagnostics
button.
|
TIPS
If
I can't run an Office program, you can still run the Office
Diagnostics, as shown below.
1. In Microsoft
Windows, click the Start button >> All Programs >>
Microsoft Office >>Microsoft Office Tools.
2.
Click Microsoft
Office Diagnostics.
|
|
Click
the Office
Button, and then click the Excel
Options
button.
Excel
Options dialog box appears.
Click
Resources,
and then click the Diagnose
button.
The
Microsoft Office Diagnostics dialog box appears, as shown
below.
Click
the Continue
button, and then click the Run
Diagnostics
button.
During
this process, you may be asked to insert the Office 2007
installation CD and/or exit any open applications. If the errors
persist, try to reinstall your Microsoft Office programs
|
How To Repair A Corrupted Workbook Manually
SUMMARY
Click
the Office Button.
Select
the corrupted workbook.
Click
the Open drop-down
arrow
Click
Open and Repair
Click
the Repair button.
|
|
Click
the Office
Button, and then click Open.
The
Open dialog box appears.
Select
the corrupted workbook that you want to open. Then, click the
Open
drop-down arrow.
A
menu appears, as shown below.
Click
Open
and Repair.
A
dialog box appears, as shown below.
Click
the Repair
button.
Excel
will try to recover as much of the workbook data as possible. If
you have failed to repair the workbook, click the Extract Data to
extract values and formulas from the workbook.
|
How To Set The AutoRecover Options
SUMMARY
Click
the Office Button.
Click
the Excel Options
button.
Click
Save, and then
change the options you want.
Click
the OK button.
|
TIPS
|
Click
the Office
Button, and then click the Excel
Options
button.
Excel
Options dialog box appears.
Click
Save.
Change the options you want.
You
can reduce the AutoRecover time interval so that Excel will save
the changes more frequently.
Click
the OK
button.
The
dialog box closes and you return to Excel.
|
How To Recover An Excel File
SUMMARY
Click
the file drop-down arrow.
Click
to select the option you want.
|
|
From
the task pane, click the drop-down arrow of the file which you
want to recover.
If
you have corrupted files, Excel displays a list of the files in
the task pane. The drop-down menu lists the options, as shown
below.
Click
to select the option you want.
The
following are the options you can choose from the list.
-
Options
|
Description
|
Open
|
Opens
the file for you to review and work on it.
|
Save
As
|
By
default, the recovered file is saved in the same folder as the
original file. If you use the same name as the original file,
it replaces the original file. A message appears to ask if
you want to replace the existing file (with the changes you
made up to the last time you saved the file).
|
Delete
|
Deletes
the file.
|
Show
Repairs
|
Displays
how Office recovers the file.
|
Close
the Document Recovery task pane.
Make
sure you have opened or saved all of the files you want to keep.
|
