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

excel vba courses - importing data

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel vba courses - Importing data

excel vba courses - Importing data

ResolvedVersion Standard

Ian has attended:
Excel Introduction course

Importing data

How do I import data from word onto a spreadsheet?

RE: Importing data

Hi Ian,

Thanks for your question.

To import data from word, in Excel:

  • INSERT menu > OBJECT
  • switch to CREATE FROM FILE tab
  • Browse Word file
  • Press OK


You can then format this word object as a picture, resize or crop.

Hope this helps.

Regards,

Katie

Excel tip:

Brighten up your Excel 2010 Spreadsheet by changing the colours of the gridlines

Excel 2010 allows you to change the colour of grid lines instead of keeping them in boring black.

Select the File tab on the Ribbon, click Options, click Advanced, scroll down to ''Display options for this worksheet.'' Next to ''Gridline colour,'' choose your favourite colour, then once you've done this, click OK. Easy!

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.