Quick Note Scenario: Handy Programming Tips for Microsoft Excel 2010

Handy Programming Tips for Microsoft Excel 2010: Learn programming tips that you can apply to your own Microsoft Excel 2010 applications.

Applies to: Excel 2010 | Office 2010 | VBA

In this article
Next Steps
Additional Resources
About the Author

Published:   May 2011

Provided by:    Frank Rice, Microsoft Corporation

Quick Notes are 2-4 page tasks in a single scenario. Combined, they provide an end-to-end solution for a specific scenario. Individually, they are single-page tasks that you can print and use.

The goal of these exercises is to enable you to customize Microsoft Excel 2010 for your own applications. Each task addresses a particular scenario. After you complete an exercise, you should have a good idea of how to apply the information to your own solutions.

Next Steps

To implement this scenario, complete the following tasks:

• Clearing Hyperlinks in Excel 2010

• Exporting a Range in PDF or XPS Formats in Excel 2010

• Removing Document Properties in Excel 2010

• Removing Duplicate Values in a Range in Excel 2010

• Sorting Data Fields in Excel 2010

• Using Date Functions of the WorksheetFunction Object in Excel 2010

• Working with PageSetup Object Features in Excel 2010

• Working with Page Headers in Excel 2010

• Working with Window Properties in Excel 2010

• Additional Resources

• About the Author

Additional Resources

• Office Developer Center on MSDN

About the Author

Frank Rice, Microsoft Corporation, is a frequent contributor to the Microsoft Office Developer Center.