United States
Change
|
All Microsoft Sites
Help and Support Home
|
Select a Product
|
Advanced Search
Excel 2007
Excel 2007 Solution Center
Top issues
Update Office 2007
Find out more about Office 2007 Service Pack 1
Read about the current issues that are fixed in this release of Excel
Visit Office Online to download Office 2007 Service Pack 1
Top Excel "How to" help
Step-by-step instructions to find data in an Excel table
Learn how to use startup folders in Excel
Read an overview about data tables
Get help with expired beta software
Reset the last cell in Excel
Calculate the number of months between two dates
Find and replace tildes and wildcard characters
Learn how to use the Paste Options button
Help transitioning from earlier versions of Office
Use earlier versions of Excel, PowerPoint, and Word to open and save files
Troubleshoot when Office 2007 upgrade fails on Office XP Student and Teacher products
Install the Microsoft Office Compatibility Pack to use earlier versions of Office programs
View Word and Excel 2007 files by using Word Viewer 2003
Learn more about the fixed updates to the Microsoft Office Compatibility Pack
Error messages
Top error messages
Troubleshoot errors when you try to save a worksheet
Get help for errors when you try to hide columns in Excel
Get help with "Clipart cannot complete the operation" error messages when you try to insert clip art
How to create a conditional format to hide errors in Excel
Troubleshoot when open files: "The document
caused a serious error the last time it was opened"
Resolve run-time error 1004 when copying a worksheet
Find help when starting an Office program that has the Adobe PDFMaker Add-in installed
Get help with "Filename is not valid" error messages
Alert IDs
Learn how to use the Alert ID feature in the Office 2007 programs
Downloads and updates
Keeping Office up to date
Visit Downloads on Microsoft Office Online to get the latest updates
Visit Microsoft Update to keep your PC up to date
Find converters and add-ins
Get help when add-ins do not load when using the CreateObject command
Microsoft Save as PDF download add-in
Microsoft Save as XPS download add-in
Microsoft Save as PDF or XPS download add-in
Download the Microsoft Office Compatibility Pack for Office 2007 File Formats
Installation and setup
Help installing Excel
Install and to repair Office 2007 features
Troubleshoot problems after you install an automatic update for Word 2007 on a Windows Vista-based computer
Find help when you receive the "Setup is unable to proceed" error message when installing Office 2007
Troubleshoot when Office 2007 upgrade fails on Office XP Student and Teacher products
Install add-ins
Install the Excel 2002 Report Manager and Template Wizard add-in
Read more about Adobe PDFMaker Add-in installation
How to load the Analysis ToolPak
Security and privacy
Make Excel more secure
Change your security settings through the Trust Center
Visit the Microsoft Security Center
Download a free trial of Windows Live OneCare – all-in-one PC care from Microsoft
Privacy options
Learn about privacy options for Office 2007 programs
Menus and toolbars
Word menus and toolbars
Learn about the new Office ribbon
Find help when your E-mail command is missing or is unavailable
Where did my menus and toolbars go?
Working with files
Working in Worksheets
Use form controls on a worksheet
Change the color palette for workbooks
Use addresses from an Excel worksheet to create labels in Word
Learn how to delete every other row on a worksheet
Troubleshoot when Excel opens without displaying a workbook
Use the INDEX and MATCH worksheet functions with multiple criteria
Format an Excel workbook while streaming MIME content
Create a dynamic defined range in a worksheet
Control the startup message about updating linked workbooks in Excel
Working with data
Formulas
Read how Excel determines the current mode of calculation
Correct a problem with a formula
Get more information about formulas
Macros
Use macro examples to delete duplicate items in a list
Learn how to use a macro to apply cell shading format to every other row in a selected range
Assign a macro to an option button in Excel
Learn how to loop through a list of data on a worksheet by using macros
Use a macro to change the date/time format in a header or footer
Charts
Use a macro to extract data from a chart
Create a column chart with two Y-axes
Watch a demo on how to create charts
Get information about formatting charts
PivotTables
GETPIVOTDATA formula is automatically created when you try to create simple link in Excel
Take online training to learn about PivotTable reports on Office Online
Take online training to learn about PivotTable reports on Office Online
Contacts
Contacts
Contact a support professional by e-mail, online, or phone
Ask questions, share information, and exchange ideas with others in Office discussion groups
Subscribe to e-mail news about Office
Share your feedback with the Microsoft Office product team
Need More Help?
Contact a Support Professional by Email, Online, or Phone.
Send Us Feedback
Help us improve Excel 2007
Page Tools
Print this page
E-mail this page
Last Review : April 14, 2008
Need More Help?
Contact a Support Professional by Email, Online, or Phone.
Services Agreement
Contact Us
|
Terms of Use
|
Trademarks
|
Privacy Statement
©2008 Microsoft