word edit excel table in protected document

Then press the “Delete” or “Del” key on your keyboard to delete the Excel worksheet. To delete an embedded Excel worksheet object in your document, simply click it to select it. How to Delete an Embedded Excel Worksheet in a Word Document Then click back into the document after editing it to change it back into an embedded table within Word. It then switches back to Excel so you can make the necessary changes. To return to editing mode, double-click the embedded Excel worksheet object in the document. To edit its contents again in the future or to change its display size, you must return to editing mode. How to Edit an Embedded Excel Worksheet in a Word Document Doing this then changes the display of the worksheet to a table. After entering the worksheet data and resizing its display, then click into the document area. Then click and drag to increase or decrease the size of the worksheet area that appears in the document. To resize this display area to increase the data shown or remove extra cells from appearing, place your mouse pointer over the small black resizing squares that appear around the perimeter of the embedded worksheet object until your mouse pointer turns into a double-pointed arrow. Only the information shown in this area appears in the document. Note that the embedded Excel worksheet object has a dashed border around it.

Also, apply all formatting to the cells in Excel, as you cannot make any formatting changes in Word. Edit the contents of the cells in the Excel worksheet area. Insert an Excel Worksheet into a Word Document – Instructions: A picture of a user inserting an Excel spreadsheet into a Word document.Īt that point, you are working within the Excel interface. Doing this then inserts an Excel worksheet object into that location in the document. Then click the “Excel Spreadsheet” command in the button’s drop-down menu. Then click the “Table” button in the “Tables” button group on the “Insert” tab of the Ribbon. To insert an Excel worksheet into a Word document, place the insertion marker into the document location where you want to show the worksheet data. However, it displays the data in the Word document as if it is a table.

After you insert an Excel worksheet into a Word document, you can then edit the information in the worksheet using the Excel interface.

To insert an Excel worksheet into a Word document, you must have both Microsoft Word and Microsoft Excel installed on your computer as part of the same Microsoft Office installation. This helps Word users who like creating worksheets and performing calculations in Microsoft Excel. You can easily insert an Excel worksheet into a Word document to harness the power of Excel within Word. Insert an Excel Worksheet into a Word Document: Overview How to Insert an Excel Worksheet into a Word Document QuickBooks Desktop (PC/Windows) 2022-2015.Mac OS Ventura-Mojave Keyboard Shortcuts.

Word edit excel table in protected document