98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel 2007
Excel 2007
Resolved · Low Priority · Version 2007
Thu 29 Jan 2009, 15:37Delegate Jeremy said...
Jeremy has attended:
Excel Advanced course
Excel 2007
can I download information from a web page into a spreadsheet/pivot table?
Sun 1 Feb 2009, 11:46Trainer Simon said...
RE: Excel 2007
Hi Jeremy,
Thank you for your question.
Select the Data tab and then Get External Data group. Use the From Web option.
Type in the desired web address and look for tables of data that have a yellow box at the top left. Select the data to import by clicking the yellow boxes and they will turn green and then select Import and choose a cell to import the data into it.
I hope this answers your question.
Regards
Simon
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:Outlining - Grouping rows or columnsHighlight want you want to group and press ALT + SHIFT + left cursor arrow |
