Saving Word Form Data for Use in Excel
By James Marshall, About.com Guide
For some reason, Microsoft doesn’t make it easy for users to extract their form data for use in Excel. While they should give you the option of simply saving the form data as an Excel spreadsheet, they make users go through a few extra steps to transfer the data. Although this is a bit of a hassle, it is easy enough to do. With the form document open, select Options from the Tools menu:
Prev
- Select Options
- Select Save data only for forms
- Open the Save As Dialog Box
- Name Your File
- Save Your File
Working With Word and Excel
Learn About Charts and Tables in Word
Explore Word Processing
Must Reads
About.com Special Features
Holiday Central
What to eat, where to go, fun things to do and how to save money on the perfect gifts. More >
Family Tech Center
Stay connected and entertained with reviews on tips on the latest HDTVs, cellphones and more. More >
©2009 About.com, a part of The New York Times Company.
All rights reserved.