Excel 2016
- To create a set, you must specify a set name and add at least one row to the set. Before you click OK, enter a set name and ...
- To create a table from an AutoFiltered range, turn off AutoFilter. Or, when inserting the table, enable the option: My table ...
- To create this stock chart, arrange the data on your sheet in this order: high price, low price, closing price. Use dates ...
- To create this stock chart, arrange the data on your sheet in this order: opening price, high price, low price, closing price. ...
- To create this stock chart, arrange the data on your sheet in this order: volume traded, high price, low price, closing price. ...
- To create this stock chart, arrange the data on your sheet in this order: volume traded, opening price, high price, low price, ...
- To create this stock chart, you must arrange the data on your worksheet in the following order: high price, low price, closing ...
- To create this stock chart, you must arrange the data on your worksheet in the following order: opening price, high price, ...
- To create this stock chart, you must arrange the data on your worksheet in the following order: volume traded, high price, ...
- To create this stock chart, you must arrange the data on your worksheet in the following order: volume traded, opening price, ...
- To display a workbook in this Web Part, you must first select the workbook.To select a workbook, open the tool pane, and ...
- To edit in the browser, a copy of the file will be created in a supported format.To edit this workbook without creating a ...
- To edit in the browser, a copy of the file will be created. Features that are not supported in the browser will be removed ...
- To edit this in your browser, we will create a copy that doesn't include unsupported features.To edit this workbook with ...
- To edit this workbook you first need to save it in a supported format. To do this, open the workbook for viewing and select ...
- To enable this option, you must install a High Performance Computing (HPC) Cluster Connector. A Cluster Connector enables ...
- To finish the query and retrieve the data, click Finish.If you want to add this query to the list of queries that are available ...
- To get data from a Web Page into (!idspnExcel_NV), you must open Excel as an independent application and then perform a Web ...
- To keep data in the order it's received from the data source, go on to the next step.To sort the data, choose a column in ...
- To prevent possible loss of data, Microsoft Graph cannot shift nonblank cells off the datasheet. Try to delete or clear the ...
- To prevent possible loss of data, you cannot shift nonblank cells off of the worksheet. Select another location in which ...
- To publish the entire workbook as an interactive web page, you must have at least one worksheet in this workbook. Chart sheets, ...
- To publish to a SharePoint list, Excel must force columns to use certain recognized data types. All cells with individual ...
- To refresh an external data range automatically when the parameter value changes, you must select a single cell to supply ...
- To refresh an external data range automatically when the parameter value changes, you must select the parameter cell from ...
- To remove blank rows from a PivotTable:1) Select the PivotTable.2) On the PivotTable Tools | Design tab, point to the Blank ...
- To resolve this conflict, you can discard your changes and keep the other changes, you can retry your changes, or you can ...
- To save a file with these features, click No, and then choose a macro-enabled file type in the File Type list.To continue ...
- To save as XML Spreadsheet, you must have at least one worksheet in this workbook. Chart sheets, MS Excel 4.0 Macro sheets, ...
- To save this web page to the current location, it needs to be saved using short file names, which requires organizing supporting ...
- To select a column, click the button to the right of the text box, select a column or cell within the column, and then click ...
- To simplify the spreadsheet structure:1) Select the merged cells.2) Split merged cells by selecting Unmerge Cells from the ...
- To sort a column, click the button to the right of the text box, select a column or cell within the column, and then click ...
- To sort a row, click the button to the right of the text box, select a row or cell within the row, and then click the button ...
- To specify a header row:1) Select the table and click on the Table Tools | Design tab.2) Check the Header Row table style ...
- To specify the data and labels for the chart now, click in the Data Range box, and then select the cells on your worksheet.To ...
- To use a chart template, you can choose it when you create a chart (Insert menu, All Chart Types Dialog Box Launcher, Templates ...
- To use an Office Data Connection (.odc) file, click Cancel, and then click Existing Connections in the Get External Data ...
- To use multiple chart types, choose the Chart Type command or the chart type group command (for example, Line Group) from ...
- To use this feature, you must first refresh the PivotTable. On the Analyze tab, in the Data group, click Refresh, and then ...
- To use this Web page interactively, you must have Microsoft Internet Explorer 5.01 Service Pack 2 (SP2) or later and the ...
- To view the columns for data in a table, click the + sign beside it the Available Tables And Columns box.To include an available ...
- trials,probability_s,alpha!Returns the smallest value for which the cumulative binomial distribution is greater than or equal ...
- trials,probability_s,alpha!This function is available for compatibility with (!idspnExcel_2007) and earlier.Returns the smallest ...
- trials,probability_s,number_s,number_s2!Returns the probability of a trial result using a binomial distribution!is the number ...
- type_text!Returns information about the current operating environment!is text specifying what type of information you want ...
- Unable to acquire a lock on your workbook. It is recommended that you select Open in {0:Excel} or try to save your changes ...
- Unable to get the required information about this cube. The cube might have been reorganized or changed on the server. The ...
- Unable to open Access database '{0}' due to failure of connection with the remote SQL Server database using cached authentication ...
- Unable to open Access database '{0}' due to failure of connection with the remote SQL Server database using integrated authentication. ...
- Unable to perform the operation. The operation refers to items that may not exist in the workbook, may not have been marked ...
- Unable to perform the requested action because of communication issues.Check that you are still connected to the Internet ...
- Unexpected file lock by |. Please try again, and then if necessary, use the Share Workbook command (Changes group on the ...
- Unexpected file lock by |. You can override this file lock, or continue without doing so. If you continue without overriding ...
- Unfortunately, the workbook needs to be closed or checked in before you can edit it. If everyone uses {0:ExcelWebApp}, you ...
- Uninitialized ActiveX controls cannot be transferred to the selected file format. The controls will be lost if you continue. ...
- Use the Data Analysis Expressions (DAX) Language to modify the results returned by the connection to the Workbook Data Model. ...
- value!Checks whether a reference is to an empty cell, and returns TRUE or FALSE!is the cell or a name that refers to the ...
- value!Checks whether a value is #N/A, and returns TRUE or FALSE!is the value you want to test. Value can refer to a cell, ...
- value!Checks whether a value is a logical value (TRUE or FALSE), and returns TRUE or FALSE!is the value you want to test. ...
- value!Checks whether a value is a number, and returns TRUE or FALSE!is the value you want to test. Value can refer to a cell, ...
- value!Checks whether a value is a reference, and returns TRUE or FALSE!is the value you want to test. Value can refer to ...
- value!Checks whether a value is an error (#N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!), and returns TRUE or FALSE!is ...
- value!Checks whether a value is an error (#VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!) excluding #N/A, and returns ...
- value!Checks whether a value is not text (blank cells are not text), and returns TRUE or FALSE!is the value you want tested: ...
- value!Checks whether a value is text, and returns the text if it is, or returns double quotes (empty text) if it is not!is ...
- value!Checks whether a value is text, and returns TRUE or FALSE!is the value you want to test. Value can refer to a cell, ...
- value!Converts non-number value to a number, dates to serial numbers, TRUE to 1, anything else to 0 (zero)!is the value you ...
- value!Returns an integer representing the data type of a value: number = 1; text = 2; logical value = 4; error value = 16; ...
- value!Returns the sheet number of the referenced sheet!is the name of a sheet or a reference that you want the sheet number ...
- value,format_text!Converts a value to text in a specific number format!is a number, a formula that evaluates to a numeric ...
- value,value_if_error!Returns value_if_error if expression is an error and the value of the expression itself otherwise!is ...
- value,value_if_na!Returns the value you specify if the expression resolves to #N/A, otherwise returns the result of the expression!is ...
- value1,value2,.!Calculates standard deviation based on an entire population, including logical values and text. Text and ...
- value1,value2,.!Calculates variance based on the entire population, including logical values and text. Text and the logical ...