Ever need to insert an Excel worksheet into a Word document and have them linked so that when you update the main Excel worksheet, it automatically updates the one in the Word document?

There are actually two ways to insert an Excel object into Word, linking and embedding. When you embed an Excel worksheet, the worksheet will not be updated when you update the main Excel file.

When you insert a linked

If you have a series of data that you want to enter into Excel, it is best to let AutoFill handle it.  With AutoFill, your serial data gets automatically  populated  – you will only need to enter the first value on the list and the software will populate the rest for you.

To use this feature, start by entering the initial values of the row.  In the example below, I entered