microsoft excel xp training - importing data
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

microsoft excel xp training - Importing data

resolvedResolved · Low Priority · Version Standard

replyReply Tue 21 Nov 2006, 17:14Delegate Jason said...

Jason has attended:
Excel Advanced course

Importing data

How do I import data from another Excel file?

For upcoming training course dates see: Pricing & availability

replyReply Wed 22 Nov 2006, 10:02Trainer Orok said...

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:

Cycling through Absoulte cell references

If you are working with formulas in excel and need to convert your formula to an absolute formula, instead on manually adding in the $dollar signs you can highlight the specific part of your formula and press the F4 key.

You can cycle through all the absolute options by pressing the button (up to four times)

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard