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

resolvedResolved · Low Priority · Version 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:

Shared Conditional Formatting

In a shared workbook, conditional formats applied before the workbook was shared will continue to work; however you cannot modify the existing conditional formats or apply new ones.

View all Excel hints and tips


Server loaded in 0.09 secs.