How to insert or paste an Excel worksheet in Visio

Embedded or linked Excel worksheet drawing on the Insert menu by using object commands in Visio

Loadtocnode (2, 'summary '); Use InsertMenu ObjectCommand to insert an Excel worksheet into the Visio drawing. You can embed or link an existing Excel worksheet or you can embed a new Excel worksheet. To do this, use one of the following methods based on your specific situation.

Embed or link an existing Excel worksheet loadtocnode (3, 'summary ');

1. Start Visio and open the drawing.
2. ClickInsertOn the menuObjectAnd then clickCreate from File.
3. ClickBrowse. InBrowseIn the dialog box, find the Excel worksheet you want to insert and clickOpenExcel workbooks.
4. ClickOK.
5. Perform the following steps based on your specific situation:
   • To embed an Excel worksheet, make sure it is not selected,Link to fileCheck box. IfLink to fileCheck box selected, click to clearLink to fileCheck box.
   • If you want to link an Excel worksheet, click to selectLink to fileCheck box.
6. If you want to display the icon in the drawing in an Excel worksheet, click to selectDisplayed as an iconCheck box.

   Note:When you click to selectDisplayed as an iconWhen the check box is used, the Excel worksheet is displayed as an icon in the drawing. To view the content of an Excel worksheet, double-click the icon.

7. ClickOK.

Embed a new Excel worksheet loadtocnode (3, 'summary ');

1. Start Visio and open the drawing.
2. InInsertClickObject.
3. ClickObject TypeIn the listMicrosoft Office Excel worksheet, ClickCreate newAnd then clickOK.
4. Double-click the embedded Excel worksheet and add the required data. In the Excel worksheet, click to display the area of the Visio toolbar on the drawing page of the Excel worksheet again.

Embed or link an Excel worksheet to a drawing in Visio, and use the selective paste command on the editing menu

Loadtocnode (2, 'summary '); UseEditOn the menuPaste selectivelyPaste the command to the Excel worksheet of your Visio drawing. You can use this method to embed or link all cells in an existing Excel worksheet, or to some cells in an existing Excel worksheet. To do this, follow these steps:

1. Start Excel and open the required worksheet.
2. Select the target cell. To select all cells in the worksheet, clickSelect AllButton.
3. InEditIn the menu, clickCopy.
4. Start Visio and open the drawing.
5. InEditClickPaste selectively.
6. Perform the following steps based on your specific situation:
   • To embed an Excel worksheet, clickPasteIf it is not selected, clickSaveIn the listMicrosoft Office Excel worksheet.
   • If you want to link an Excel worksheet, clickPaste Link.
7. If you want to display the icon in the drawing in an Excel worksheet, click to selectDisplayed as an iconCheck box.

   Note:When you click to selectDisplayed as an iconWhen the check box is used, the Excel worksheet is displayed as an icon in the drawing. To view the content of an Excel worksheet, double-click the icon.

8. ClickOK.

Display a large Excel worksheet in a Visio drawing

Loadtocnode (2, 'summary '); embedding a large Excel worksheet that contains many columns and rows may not be able to view all columns and the rows embedded in the worksheet in the drawing. Note that if you double-click an embedded Excel worksheet, the vertical scroll bar is displayed horizontally in the Excel worksheet. You can use the scroll bar to view all columns and rows embedded in the worksheet.

To display all cells of a Large Excel worksheet in the Visio drawing, use methods except that the drawing is embedded below the worksheet. First, copy the Excel worksheet as an image. Paste the image to your Visio drawing. To do this, follow these steps:

1. To add an Excel worksheet as an image, follow these steps:
   1. Start Excel and open the required worksheet.
   2. Press Ctrl + end to move the last cell to the worksheet.
   3. Press Ctrl + Shift + home to select cells in the entire area.
   4. Press shift, and then clickEditOn the menuCopy Image.
   5. VerifyCopy ImageDialog BoxFor the screen displayed onSelectAppearance. Then, confirmImageInFormat.
   6. ClickOK.
2. To paste the image to your Visio drawing, follow these steps:
   1. Start Visio and open the drawing.
   2. InEditIn the menu, clickPaste.

Suitable for Visio drawing pages in Excel worksheet

Loadtocnode (2, 'summary '); when you insert or paste an existing large Excel worksheet into your Visio drawing, the worksheet part may be displayed beyond the Visio drawing page. To adjust to the drawing page in an Excel worksheet, use one of the following methods based on your specific situation:

• Adjust the size of the drawing page. To adjust the drawing page, press Ctrl and drag the edge of the drawing page to fit the drawing page in the worksheet.
• Before adjusting the column size in a worksheet, you embed it in a worksheet, In a Visio drawing, or copy it as an image before the worksheet. Paste the image and draw it in Visio. When you adjust the size of a column in a worksheet, you can change the worksheet format. Therefore, you may need to test the worksheet. You need to try this method before displaying the worksheet in the Visio drawing. To adjust the column size in a worksheet, follow these steps:
  1. Start Excel and open the required worksheet.
  2. InFormatPointColumn, And then clickAutomatic Adjustment.