Use the Information property with a Selection object to return the current row and column number. The following example changes the width of the first cell in the selection and then displays the cell's row number and column number.
Word Object Model Reference. Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback. Skip to main content. This browser is no longer supported. Download Microsoft Edge More info. Contents Exit focus mode. You can add, subtract, multiply, and divide numbers in Word table cells.
Also, you can calculate averages, percentages, and minimum as well as maximum values. To add the formula in the Word table, do the following: 1. Failed to send the question. Please try again. How to reference a cell of a Word table If you have a table in the Word document, you can insert some formulas and functions in it without using an Excel table.
It is easy and fast to insert a formula to the Word table that use the values of some table cells. How to add, subtract, multiply and divide cells in a Word table Most of the people know that Word is for writing texts sometimes containing tables, and Excel is all about tables and calculations for them. But what if you need to create a Word table with formula. Just remember about the order of calculations PEMDAS : parentheses, exponentiation, multiplication or division whichever comes first, addition or subtraction whichever comes first.
To multiply two cells in Excel, use a multiplication formula like in the above example, but supply cell references instead of numbers. For example, to multiply the value in cell A2 by the value in B2, type this expression:. To multiply multiple cells , include more cell references in the formula, separated by the multiplication sign.
For example:. To multiply two columns in Excel, write the multiplication formula for the topmost cell, for example:. After you've put the formula in the first cell C2 in this example , double-click the small green square in the lower-right corner of the cell to copy the formula down the column, up to the last cell with data:. In my opinion, this is the best but not the only way to multiply one column by another. You can learn other approaches in this tutorial: How to multiply columns in Excel.
Multiplying rows in Excel is a less common task, but there is a simple solution for it too. To multiply two rows in Excel, just do the following:. As with multiplying columns, the relative cell references in the formula change based on a relative position of rows and columns, multiplying a value in row 1 by a value in row 2 in each column:. Where number1 , number2 , etc. Instead of percentages, you can multiply by a corresponding decimal number. For example, knowing that 10 percent is 10 parts of a hundred 0.
As shown in the screenshot below, all three expressions yield the same result:.
0コメント