Excel 2013

  1. To simplify the spreadsheet structure:1) Select the merged cells.2) Split merged cells by selecting Unmerge Cells from the ...
  2. 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 ...
  3. 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 ...
  4. To specify a header row:1) Select the table and click on the Table Tools | Design tab.2) Check the Header Row table style ...
  5. 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 ...
  6. To use a chart template, you can choose it when you create a chart (Insert menu, All Chart Types Dialog Box Launcher, Templates ...
  7. To use an Office Data Connection (.odc) file, click Cancel, and then click Existing Connections in the Get External Data ...
  8. To use multiple chart types, choose the Chart Type command or the chart type group command (for example, Line Group) from ...
  9. To use this feature, you must first refresh the PivotTable. On the Analyze tab, in the Data group, click Refresh, and then ...
  10. To use this Web page interactively, you must have Microsoft Internet Explorer 5.01 Service Pack 2 (SP2) or later and the ...
  11. To view the columns for data in a table, click the + sign beside it the Available Tables And Columns box.To include an available ...
  12. trials,probability_s,alpha!Returns the smallest value for which the cumulative binomial distribution is greater than or equal ...
  13. trials,probability_s,alpha!This function is available for compatibility with Excel 2007 and earlier.Returns the smallest ...
  14. trials,probability_s,number_s,number_s2!Returns the probability of a trial result using a binomial distribution!is the number ...
  15. type_text!Returns information about the current operating environment!is text specifying what type of information you want ...
  16. Unable to acquire a lock on your workbook. It is recommended that you select Open in {0:Excel} or try to save your changes ...
  17. Unable to get the required information about this cube. The cube might have been reorganized or changed on the server. The ...
  18. Unable to open Access database '{0}' due to failure of connection with the remote SQL Server database using cached authentication ...
  19. Unable to open Access database '{0}' due to failure of connection with the remote SQL Server database using integrated authentication. ...
  20. Unable to perform the operation. The operation refers to items that may not exist in the workbook, may not have been marked ...
  21. Unable to perform the requested action because of communication issues.Check that you are still connected to the Internet ...
  22. Unable to retrieve information for | filter control(s). In some cases, this can be due to a custom value in the DefaultMember ...
  23. Unable to run policy check. There is no default policy check module or and associated policy check module with the configuration. ...
  24. Unexpected file lock by |. Please try again, and then if necessary, use the Share Workbook command (Changes group on the ...
  25. Unexpected file lock by |. You can override this file lock, or continue without doing so. If you continue without overriding ...
  26. Uninitialized ActiveX controls cannot be transferred to the selected file format. The controls will be lost if you continue. ...
  27. Use the Data Analysis Expressions (DAX) Language to modify the results returned by the connection to the Workbook Data Model. ...
  28. Valid values: from -1 (no timeout) through 2073600 (24 days). 0 means that the session expires at the end of a single request. ...
  29. Valid values: from -1 (short session timeout is disabled) through 2073600 (24 days). 0 means that the session expires at ...
  30. 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 ...
  31. 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, ...
  32. value!Checks whether a value is a logical value (TRUE or FALSE), and returns TRUE or FALSE!is the value you want to test. ...
  33. 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, ...
  34. value!Checks whether a value is a reference, and returns TRUE or FALSE!is the value you want to test. Value can refer to ...
  35. value!Checks whether a value is an error (#N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!), and returns TRUE or FALSE!is ...
  36. value!Checks whether a value is an error (#VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!) excluding #N/A, and returns ...
  37. value!Checks whether a value is not text (blank cells are not text), and returns TRUE or FALSE!is the value you want tested: ...
  38. 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 ...
  39. 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, ...
  40. value!Converts non-number value to a number, dates to serial numbers, TRUE to 1, anything else to 0 (zero)!is the value you ...
  41. value!Returns an integer representing the data type of a value: number = 1; text = 2; logical value = 4; error value = 16; ...
  42. value!Returns the sheet number of the referenced sheet!is the name of a sheet or a reference that you want the sheet number ...
  43. value,format_text!Converts a value to text in a specific number format!is a number, a formula that evaluates to a numeric ...
  44. value,value_if_error!Returns value_if_error if expression is an error and the value of the expression itself otherwise!is ...
  45. value,value_if_na!Returns the value you specify if the expression resolves to #N/A, otherwise returns the result of the expression!is ...
  46. value1,value2,.!Calculates standard deviation based on an entire population, including logical values and text. Text and ...
  47. value1,value2,.!Calculates variance based on the entire population, including logical values and text. Text and the logical ...
  48. value1,value2,.!Counts the number of cells in a range that are not empty!are 1 to 255 arguments representing the values and ...
  49. value1,value2,.!Counts the number of cells in a range that contain numbers!are 1 to 255 arguments that can contain or refer ...
  50. value1,value2,.!Estimates standard deviation based on a sample, including logical values and text. Text and the logical value ...
  51. value1,value2,.!Estimates variance based on a sample, including logical values and text. Text and the logical value FALSE ...
  52. value1,value2,.!Returns the average (arithmetic mean) of its arguments, evaluating text and FALSE in arguments as 0; TRUE ...
  53. value1,value2,.!Returns the largest value in a set of values. Does not ignore logical values and text!are 1 to 255 numbers, ...
  54. value1,value2,.!Returns the smallest value in a set of values. Does not ignore logical values and text!are 1 to 255 numbers, ...
  55. Values cannot be changed when a Timeline control is filtering the data. You could use a Slicer with a single selection instead ...
  56. Values cannot be changed when multiple items are selected in a Report Filter field. Select a single item for each field in ...
  57. Values cannot be changed when multiple items are selected in a slicer. Select a single item for each slicer before changing ...
  58. values,dates,guess!Returns the internal rate of return for a schedule of cash flows!is a series of cash flows that correspond ...
  59. values,finance_rate,reinvest_rate!Returns the internal rate of return for a series of periodic cash flows, considering both ...
  60. values,guess!Returns the internal rate of return for a series of cash flows!is an array or a reference to cells that contain ...
  61. Verify that each of the columns listed below is associated with the correct data type. If a column is associated with an ...
  62. Visual Basic macro modules are now edited in the Visual Basic Editor, not the workbook. To see your modules, click Visual ...
  63. We can't activate the relationship because an active relationship already exists between tables '|0' and '|1'. Deactivate ...
  64. We can't activate this relationship because a set of active relationships already exists between tables '|0' and '|1'. Deactivate ...
  65. We can't complete the action either because the server is unavailable or your account ran out of transactions for this subscribed ...
  66. We can't complete the Data Model action because your data has automatic subtotals. For information about how to remove the ...
  67. We can't create a relationship between table '|0' column '|1' and table '|2' column '|3' because a relationship already exists ...
  68. We can't generate PivotTable Recommendations for connections that have multiple tables or use data feeds or text files as ...
  69. We can't make this change for the selected cells because it will affect a PivotTable. Use the field list to change the report. ...
  70. 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. ...
  71. We can't recommend any PivotTables for the selected data because there are too many blank cells or duplicate values, or not ...
  72. 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 ...
  73. We can't start {0:Excel} because we can't find a supported version of {0:Excel} installed on your computer, or your browser ...
  74. We can't update some of the links in your workbook right now.You can continue without updating their values, or edit the ...
  75. We can't use the data from this feed. Make sure the external data feed server is available and that your connection information ...