Excel 2013
- 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 Excel 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 ...
- Unable to retrieve information for | filter control(s). In some cases, this can be due to a custom value in the DefaultMember ...
- Unable to run policy check. There is no default policy check module or and associated policy check module with the configuration. ...
- 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 ...
- 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. ...
- Valid values: from -1 (no timeout) through 2073600 (24 days). 0 means that the session expires at the end of a single request. ...
- Valid values: from -1 (short session timeout is disabled) through 2073600 (24 days). 0 means that the session expires at ...
- 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 ...
- value1,value2,.!Counts the number of cells in a range that are not empty!are 1 to 255 arguments representing the values and ...
- value1,value2,.!Counts the number of cells in a range that contain numbers!are 1 to 255 arguments that can contain or refer ...
- value1,value2,.!Estimates standard deviation based on a sample, including logical values and text. Text and the logical value ...
- value1,value2,.!Estimates variance based on a sample, including logical values and text. Text and the logical value FALSE ...
- value1,value2,.!Returns the average (arithmetic mean) of its arguments, evaluating text and FALSE in arguments as 0; TRUE ...
- value1,value2,.!Returns the largest value in a set of values. Does not ignore logical values and text!are 1 to 255 numbers, ...
- value1,value2,.!Returns the smallest value in a set of values. Does not ignore logical values and text!are 1 to 255 numbers, ...
- Values cannot be changed when a Timeline control is filtering the data. You could use a Slicer with a single selection instead ...
- Values cannot be changed when multiple items are selected in a Report Filter field. Select a single item for each field in ...
- Values cannot be changed when multiple items are selected in a slicer. Select a single item for each slicer before changing ...
- values,dates,guess!Returns the internal rate of return for a schedule of cash flows!is a series of cash flows that correspond ...
- values,finance_rate,reinvest_rate!Returns the internal rate of return for a series of periodic cash flows, considering both ...
- values,guess!Returns the internal rate of return for a series of cash flows!is an array or a reference to cells that contain ...
- Verify that each of the columns listed below is associated with the correct data type. If a column is associated with an ...
- Visual Basic macro modules are now edited in the Visual Basic Editor, not the workbook. To see your modules, click Visual ...
- We can't activate the relationship because an active relationship already exists between tables '|0' and '|1'. Deactivate ...
- We can't activate this relationship because a set of active relationships already exists between tables '|0' and '|1'. Deactivate ...
- We can't complete the action either because the server is unavailable or your account ran out of transactions for this subscribed ...
- We can't complete the Data Model action because your data has automatic subtotals. For information about how to remove the ...
- We can't create a relationship between table '|0' column '|1' and table '|2' column '|3' because a relationship already exists ...
- We can't generate PivotTable Recommendations for connections that have multiple tables or use data feeds or text files as ...
- We can't make this change for the selected cells because it will affect a PivotTable. Use the field list to change the report. ...
- We can't paste because the | area and paste area aren't the same size.Try one of the following: Click one cell, then paste. ...
- We can't recommend any PivotTables for the selected data because there are too many blank cells or duplicate values, or not ...
- We can't save '|' because the file is read-only.To keep your changes, you'll need to save the workbook with a new name or ...
- We can't start {0:Excel} because we can't find a supported version of {0:Excel} installed on your computer, or your browser ...
- We can't update some of the links in your workbook right now.You can continue without updating their values, or edit the ...
- We can't use the data from this feed. Make sure the external data feed server is available and that your connection information ...