98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Excel
Excel
Resolved · Low Priority · Version 2003
RE: excel
Hello Adewonuola
Thank you for your question and welcome to the forum.
To import data from a table on a web page into Excel:
1. Go to Data - Import External Data - New Web Query.
2. A mini Internet Explorer window opens on your screen.
3. Go to the web page you wish to import data from.
4. Click on the arrow (in the yellow box) that points at the data you wish to import.
5. Click Import
6. Select where you want the imported data to start from in your spreadsheet (only select one cell). If you wish, use the Properties button to set things like how often the data will refresh.
7. Click OK. It will take a few seconds before the data appears in Excel.
Kind regards
Amanda
Fri 3 Apr 2009: Automatically marked as resolved.
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Rotating Text in an Excel 2010 WorksheetMaybe you want to draw attention to certain text or you just simply want to make your worksheet look more exciting! |