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

microsoft excel xp training - importing data

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel xp training - Importing data

microsoft excel xp training - Importing data

ResolvedVersion Standard

Jason has attended:
Excel Advanced course

Importing data

How do I import data from another Excel file?

RE: Importing data

Hi Jason,

The most straight forward way to share data between two or more Excel documents is to use the Copy and Paste the data. That is;

1 Highlight the range of cells in the first or source Excel document that holds the data you wish to copy

2. Select the Edit menu and choose the Copy option. Note the "marching ants" around the highlighted area

3. Move to the other or destination Excel document and place the cusor where you wish to display the copied data

4. From the Edit menu select the Paste option

If there are other issues of that wish to bring to my attention please get back

Hope this helps

Excel tip:

Hiding Formulae in the Formula Bar

It is possible to protect the contents of a cell reference(s) from amendment by applying cell protection. The contents of the cell reference can also be stopped from displaying in the formula bar.

Step 1: Select Format > Cells > Protection.

Step 2: Tick Hidden option. Ensure Locked is ticked

Step 3: Select Tools > Protection > Protect Sheet

(Ensure "Protect worksheet and contents of locked cells" is ticked)


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.18 secs.