Excel 2016
- ref_text,a1!Returns the reference specified by a text string!is a reference to a cell that contains an A1- or R1C1-style ...
- register_id,argument1,.!module_text,procedure,type_text,argument1,.!Calls a procedure in a dynamic link library or code resource!is ...
- Remote data not accessible.To access this data Excel needs to start another application. Some legitimate applications on ...
- Removing connection(s) will separate this workbook from its data source(s), and data refresh operations in the workbook will ...
- Results of formulas may be out of date because Excel is not set to calculate automatically. Click here or press F9 to recalculate ...
- Returns the absolute cell reference of the top and leftmost cell visible in the window, based on the current scrolling position, ...
- Right-click on the table, select Table, and then select Alternative Text.2) Type a description of the table into the Title ...
- row_num,column_num,abs_num,a1,sheet_text!Creates a cell reference as text, given specified row and column numbers!is the ...
- Run cluster-safe XLL functions remotely on a High Performance Computing (HPC) Cluster. The available Cluster Connectors are ...
- sample_s,number_sample,population_s,number_pop!This function is available for compatibility with (!idspnExcel_2007) and earlier.Returns ...
- sample_s,number_sample,population_s,number_pop,cumulative!Returns the hypergeometric distribution!is the number of successes ...
- Saves dates and times in Open XML files using the ISO 8601 format. Times are rounded to the nearest ISO 8601 time value supported ...
- Saving the file as XML Data will result in the loss of worksheet features such as formatting, pictures, and objects. If you ...
- Saving this workbook's VBA project in the Excel 5.0/95 file format requires a component that is not currently installed. ...
- Saving this workbook's VBA project in the Excel 5.0/95 file format requires a component that is not currently installed. ...
- Scatter with only MarkersCompare pairs of values.Use it when the values are not in x-axis order or when they represent separate ...
- Scatter with Smooth Lines and MarkersCompare pairs of values.Use it when there are a few data points in x-axis order and ...
- Scatter with Smooth LinesCompare pairs of values.Use it when there are many data points in x-axis order and the data represents ...
- Scatter with Straight Lines and MarkersCompare pairs of values.Use it when there are a few data points in x-axis order and ...
- Scatter with Straight LinesCompare pairs of values.Use it when there are many data points in x-axis order and the data represents ...
- Select the cell containing the text you want to center and the blank cells you want to center the text across. The blank ...
- Select the cells where you want the blank cells inserted. You can choose to have the existing cells moved down or to the ...
- Select the entire outline or a level in the outline that you want to apply styles to. If you select a level that includes ...
- Select the GRG Nonlinear engine for Solver Problems that are smooth nonlinear. Select the LP Simplex engine for linear Solver ...
- Select the new data that you want to add to the chart. Include the cells containing row or column labels if you want those ...
- Select to use automatic scaling when inputs and outputs have large differences in magnitude. For example, when maximizing ...
- Selecting Convert Report Filters also permanently replaces existing report filters by substituting formulas for them, removing ...
- Send your contact an instant message containing a link to this workbook. If you want to send the file itself, first save ...
- serial_number!Returns the day of the month, a number from 1 to 31.!is a number in the date-time code used by (!idspnExcel_NV)! ...
- serial_number!Returns the hour as a number from 0 (12:00 A.M.) to 23 (11:00 P.M.).!is a number in the date-time code used ...
- serial_number!Returns the minute, a number from 0 to 59.!is a number in the date-time code used by (!idspnExcel_NV) or text ...
- serial_number!Returns the month, a number from 1 (January) to 12 (December).!is a number in the date-time code used by (!idspnExcel_NV)! ...
- serial_number!Returns the second, a number from 0 to 59.!is a number in the date-time code used by (!idspnExcel_NV) or text ...
- serial_number!Returns the year of a date, an integer in the range 1900 - 9999.!is a number in the date-time code used by ...
- serial_number,return_type!Returns a number from 1 to 7 identifying the day of the week of a date.!is a number that represents ...
- serial_number,return_type!Returns the week number in the year!is the date-time code used by (!idspnExcel_NV) for date and ...
- Sets made exclusively of measures support only a single instance of any one measure. Duplicate instances of measures will ...
- settlement,maturity,coupon,yld,frequency,basis!Returns the annual duration of a security with periodic interest payments!is ...
- settlement,maturity,coupon,yld,frequency,basis!Returns the Macauley modified duration for a security with an assumed par ...
- settlement,maturity,discount!Returns the bond-equivalent yield for a treasury bill!is the Treasury bill's settlement date, ...
- settlement,maturity,discount!Returns the price per $100 face value for a treasury bill!is the Treasury bill's settlement ...
- settlement,maturity,discount,redemption,basis!Returns the price per $100 face value of a discounted security!is the security's ...
- settlement,maturity,frequency,basis!Returns the next coupon date after the settlement date!is the security's settlement date, ...
- settlement,maturity,frequency,basis!Returns the number of coupons payable between the settlement date and maturity date!is ...
- settlement,maturity,frequency,basis!Returns the number of days from the beginning of the coupon period to the settlement ...
- settlement,maturity,frequency,basis!Returns the number of days from the settlement date to the next coupon date!is the security's ...
- settlement,maturity,frequency,basis!Returns the number of days in the coupon period that contains the settlement date!is ...
- settlement,maturity,frequency,basis!Returns the previous coupon date before the settlement date!is the security's settlement ...
- settlement,maturity,investment,discount,basis!Returns the amount received at maturity for a fully invested security!is the ...
- settlement,maturity,investment,redemption,basis!Returns the interest rate for a fully invested security!is the security's ...
- settlement,maturity,issue,first_coupon,rate,pr,redemption,frequency,basis!Returns the yield of a security with an odd first ...
- settlement,maturity,issue,first_coupon,rate,yld,redemption,frequency,basis!Returns the price per $100 face value of a security ...
- settlement,maturity,issue,rate,pr,basis!Returns the annual yield of a security that pays interest at maturity!is the security's ...
- settlement,maturity,issue,rate,yld,basis!Returns the price per $100 face value of a security that pays interest at maturity!is ...
- settlement,maturity,last_interest,rate,pr,redemption,frequency,basis!Returns the yield of a security with an odd last period!is ...
- settlement,maturity,last_interest,rate,yld,redemption,frequency,basis!Returns the price per $100 face value of a security ...
- settlement,maturity,pr!Returns the yield for a treasury bill!is the Treasury bill's settlement date, expressed as a serial ...
- settlement,maturity,pr,redemption,basis!Returns the annual yield for a discounted security. For example, a treasury bill!is ...
- settlement,maturity,pr,redemption,basis!Returns the discount rate for a security!is the security's settlement date, expressed ...
- settlement,maturity,rate,pr,redemption,frequency,basis!Returns the yield on a security that pays periodic interest!is the ...
- settlement,maturity,rate,yld,redemption,frequency,basis!Returns the price per $100 face value of a security that pays periodic ...
- Shared workbook from Microsoft Excel 95 must be opened read-only.To edit the workbook, click OK, then click Save As and save ...
- Shared workbooks cannot contain tables. You must either turn off sharing or disable the table functionality for this workbook. ...
- Shared Workbooks do not support the format of your data. Remove any Hyperlinks or Merged Cells to complete the operation. ...
- Sheet names cannot be blank, greater than 31 characters in length, start or end with a single quote, or contain any of the ...
- Sheet names should provide information about what is found on the sheet. Blank sheets should be removed.To rename a sheet:1) ...
- Show a list of relevant functions and defined names when building cell formulas.This functionality can be enabled or disabled ...
- Show Details cannot be executed when multiple items are selected in a report filter field or in a slicer. Select a single ...
- Show Details" is not available when a Timeline control is filtering the data. You could use a Slicer with a single selection ...
- Show Details" is not available when a Timeline control is filtering the data. You could use a Slicer with a single selection ...
- Show values as" calculations cannot be used with value fields for which values have been changed using PivotTable what-if ...
- Show values as" calculations cannot be used with value fields for which values have been changed using PivotTable what-if ...
- show_option,auto_text,show_key,has_leaderlines,show_seriesname,show_categoryname,show_value,show_percentage,show_bubblesizes,separator ...
- Signatures cannot be added because this workbook is embedded in another file or is hosted within another program, such as ...
- Signatures cannot be added or removed because this read-only workbook has been changed. To add or remove signatures, enable ...