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

ms excel training - workbook new material

Forum home » Delegate support and help forum » Microsoft Excel Training and help » ms excel training - Workbook new material

ms excel training - Workbook new material

ResolvedVersion Standard

Paul has attended:
Excel Introduction course

Workbook new material

How do I import data into an existing workbook

RE: Workbook new material

Hi Paul,

Thanks for the question.

Firstly it would depend on what type of data you want to import. However, most of the options can be found under "Data" > "Import external Data">...

Have a look there and see whether you can import the data, if not come back to me.

Tracy

Excel tip:

Turn off AutoComplete in Excel

You may have noticed when typing into your spreadsheets that if you start to enter labels that begin with the same letters as a label that has been previously entered in the same spreadsheet, Excel will try and automatically complete the text for you. This feature is called AutoComplete.

If you find this feature more annoying than useful, you can turn it off by:

1. Going to Tools - Options.

2. Select the Edit tab.

3. Remove the tick from next to the "Enable AutoComplete for cell values" option.

4. Click OK.

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.