Excel formulas allow you to modify your spreadsheets. But how do you apply it to the text of the Word? Here are two ways to do it!

Use prominent word formulas

While you can always combine Excel data into a Word document, it is usually unnecessary when all you need is a small table. Fortunately, it’s easy to create a table and use Excel formulas in a Word document. However, there are only a limited number of formulas that can be used.

For example, if you are trying to enter sales data into a table, you can add a sales column, one for total costs, and a third for calculating profits using a formula. For each of these columns, you can also calculate the average or maximum rating.

Method 1: Paste spreadsheet data into Word

If you already have the full data in the spreadsheet, you can simply copy it to your Word document.

1. Copy the cells that contain the data and open the Word document.

2. From the top bar, click on the arrow below the attachment button, then click Special Attach.

3. You will see a new pop-up for windows where you will need to select what you want to paste copied content as. Select the Microsoft Excel Worksheet Object and select OK.

Ms excel into

4. information should now appear in Word text, and cells should also have formulas.

If you want to edit, you can double-click on the attached content, and your Word document will be converted into an Excel document, and you will be able to do all you can in a standard spreadsheet.