If you have inserted a range of Excel data, or even an entire worksheet, you can view and modify the data without to much difficulty.

 

 

 

Here we have a range from an Excel worksheet inserted into a Word document.

 

If you right click on the Excel data and choose Worksheet Object->Edit, the worksheet will open in a restricted Excel environment from within your document.

 

 

 

You can now edit the inserted data.

 

 Even though you are editing the data in an Excel environment, the changes you make to your data in the Word document will not be carried over to the original Excel file.

 

The reverse is also true; because the worksheet data is not linked, updates to the original Excel worksheet will not be automatically updated in the Word document.

 

If you click on the margin outside the data, the Excel editing environment will close.

 

 If you right click on the Excel data, and choose Worksheet->Object->Open, the worksheet will open in a full Excel screen. This allows you to insert columns or rows, or apply formatting from the Excel toolbars. Any changes you make to the data in the word document will not be carried over to the original Excel file.

 

If you selected the formatted text option from the Paste special dialogue box when inserting the Excel data, you must edit the data directly within word. You cannot use the Excel environment to add column rows or Excel formatting styles to the data.