contador web Saltar al contenido

How To Make an Excel Spreadsheet Within Word | Productivity

Word has a feature that lets you embed spreadsheets in a document with a few clicks. With the trick, the user can edit cells with the same Excel filters and formulas without having to open the program separately, speeding up the editing of the table by the text document itself.

The information is saved in the same file, which can usually be exported in docx or pdf format. For the trick to work, I need to have Excel also installed on the computer. Here's how to make spreadsheets inside Microsoft's word processor.

Excel on Mobile: Seven Features Few People Know

Word has function for editing spreadsheets within text documents. Photo: Carolina Ochsendorf / TechTudoWord has function for editing spreadsheets within text documents. Photo: Carolina Ochsendorf / TechTudo

Word has function for editing spreadsheets within text documents. Photo: Carolina Ochsendorf / TechTudo

Want to buy a cell phone, TV and other discounted products? Meet the Compare TechTudo

Step 1. In a Word document, go to the Insert menu and press the Table option;

Access the table insertion menu in Word Photo: Reproduction / Paulo AlvesAccess the table insertion menu in Word Photo: Reproduction / Paulo Alves

Access the table insertion menu in Word Photo: Reproduction / Paulo Alves

Step 2. Select Excel Worksheet option;

Insert an Excel spreadsheet in Word Photo: Reproduo / Paulo AlvesInsert an Excel spreadsheet in Word Photo: Reproduo / Paulo Alves

Insert an Excel spreadsheet in Word Photo: Reproduo / Paulo Alves

Step 3. Then Word will display a mini spreadsheet in the body of the document and all Excel tools in the top menu;

Feed the spreadsheet inside the document Photo: Reproduo / Paulo AlvesFeed the spreadsheet inside the document Photo: Reproduo / Paulo Alves

Feed the spreadsheet inside the document Photo: Reproduo / Paulo Alves

Step 4. Edit the spreadsheet as if in Excel: replicate values, use formulas etc;

Use Excel features in spreadsheet within Word Photo: Reproduo / Paulo Alves

Use Excel features in spreadsheet within Word Photo: Reproduo / Paulo Alves

Step 5. Click outside the spreadsheet to save and view in table mode in Word. Double-click inside the table to re-edit in spreadsheet mode.

Click outside the spreadsheet to make a table Photo: Reproduo / Paulo AlvesClick outside the spreadsheet to make a table Photo: Reproduo / Paulo Alves

Click outside the spreadsheet to make a table Photo: Reproduo / Paulo Alves

How to recover text (.txt) files? Ask questions on the TechTudo forum.

How to watermark Microsoft Excel spreadsheets

How to watermark Microsoft Excel spreadsheets