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 / dnetc
Want to buy a cell phone, TV and other discounted products? Meet the Compare dnetc
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 Alves
Step 2. Select Excel Worksheet option;
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 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
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 Alves
How to recover text (.txt) files? Ask questions on the dnetc forum.
How to watermark Microsoft Excel spreadsheets