excel

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel

Excel

resolvedResolved · Low Priority · Version 2003

Adewonuola has attended:
Excel Advanced course

Excel

how do I import data from a website to excel.

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 courses

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Rotating Text in an Excel 2010 Worksheet

Maybe you want to draw attention to certain text or you just simply want to make your worksheet look more exciting!

One of the things you might consider is, rotating the text in a particular cell or set of cells.

1) Select a cell you would like to rotate
2) Click the ''Home'' tab in the Ribbon
3) Click ''orientation'' in the ''Alignment'' section
4) A pop up menu will appear with a few choices, if you want to decide yourself how many degrees to rotate the text, then click ''Format Cell Alignment.''

View all Excel hints and tips


Server loaded in 0.09 secs.