The weighted average maturity, or WAM, of one of these securities is the average number of months until the loans are paid off. A higher WAM means that you can expect to receive payments for a longer period of time than a lower WAM indicates.
No worries. Itâs easy to change it back. To change from the R1C1 cell reference style back to to the A1 style, we will change a setting in the options. Click the âFileâ tab. On the backstage screen, click âOptionsâ in the list of items on the left.On the âExcel Optionsâ dialog box, click âFormulasâ in the list of items on the left.In the âWorking with formulasâ section, select the âR1C1 reference styleâ check box so there is NO check mark in the box. Click âOKâ to accept the change and close the âExcel Optionsâ dialog box.n the backstage screen, click âOptionsâ in the list of items on the left. On the âExcel Optionsâ dialog box, click âFormulasâ in the list of items on the left. In the âWorking with formulasâ section, select the âR1C1 reference styleâ check box so there is NO check mark in the box.
Select Duplicate Values. Enter the values that you want to use, and then select a format. Advanced formatting. Select one or more cells in a range, table, or PivotTable report. On the Home tab, in the Styles group, click the arrow next to Conditional Formatting, and then click Manage Rules.elect the rule, and then click Edit rule. The Edit Formatting Rule dialog box is displayed. Under Select a Rule Type, click Format only unique or duplicate values. Under Edit the Rule Description, in the Format all list box, select unique or duplicate. Click Format to display the Format Cells dialog box.