Excel for Macintosh 2016

  1. Since this workbook is protected for sharing, you cannot decrease the number of days to keep the change history. You can ...
  2. Slicers cannot be created for offline OLAP PivotTables. To create a slicer for this PivotTable, you must change the PivotTable ...
  3. Some array formulas in this workbook refer to an entire column. In earlier versions of Excel, these formulas may be converted ...
  4. Some cells contain conditional formatting with the 'Format entire row' option selected. This version of Excel does not recognize ...
  5. Some cells contain conditional formatting with the 'Stop if True' option cleared. Earlier versions of Excel do not recognize ...
  6. Some cells contain multiple conditional formatting rules that should all be evaluated and shown. This version of Excel does ...
  7. Some cells have more conditional formats than are allowed in this version of Excel. Only the first three conditions will ...
  8. Some cells have more conditional formats than are supported by the selected file format. Only the first three conditions ...
  9. Some cells have overlapping conditional formatting ranges. Earlier versions of Excel will not evaluate all of the conditional ...
  10. Some cells have overlapping conditional formatting ranges. This version of Excel will not evaluate all the conditional formatting ...
  11. Some cells in this workbook contain conditional formatting with the 'Format entire row' option selected. Earlier versions ...
  12. Some cells or styles in this workbook contain formatting that is not supported by the selected file format. These formats ...
  13. Some content in this file will not be saved because it is incompatible with the selected file format.To preserve all content, ...
  14. Some data in the workbook is filtered on cells that contain more than 255 characters. Rows that are hidden by the filter ...
  15. Some data in this workbook has a filter applied that is not supported by previous versions of Excel. Rows that are hidden ...
  16. Some data in this workbook is filtered by a cell color. Rows that are hidden by the filter will remain hidden, but the filter ...
  17. Some data in this workbook is filtered by a cell icon. Rows that are hidden by the filter will remain hidden, but the filter ...
  18. Some data in this workbook is filtered by a font color. Rows that are hidden by the filter will remain hidden, but the filter ...
  19. Some data in this workbook is filtered by a grouped hierarchy of dates, resulting in more than two criteria. Rows that are ...
  20. Some data in this workbook is filtered by more than two criteria. Rows that are hidden by the filter will remain hidden, ...
  21. Some data in this workbook is filtered in a way that is not supported in earlier versions of Excel. Rows that are hidden ...
  22. Some formulas contain arrays with more elements than are supported by the selected file format. Arrays with more than 256 ...
  23. Some formulas contain functions that have more arguments than are supported by the selected file format. Formulas that have ...
  24. Some formulas contain functions with more arguments than are supported by the selected file format. Formulas with more than ...
  25. Some formulas contain more values, references, and/or names than are supported by the selected file format. These formulas ...
  26. Some formulas contain references to tables in other workbooks that are not currently open in this instance of Excel. These ...
  27. Some formulas contain references to tables in other workbooks that are not currently open in this instance of Excel. These ...
  28. Some formulas contain references to tables or PivotTable reports that are not supported in this version of Excel. These references ...
  29. Some formulas contain references to tables that are not supported in the selected file format. These references will be converted ...
  30. Some formulas have more levels of nesting than are allowed in this version of Excel. Formulas with more than seven levels ...
  31. Some formulas have more levels of nesting than are supported by the selected file format. Formulas with more than seven levels ...
  32. Some formulas in this workbook are linked to other workbooks that are closed. When these formulas are recalculated in earlier ...
  33. Some formulas in this workbook contain functions with more arguments than are supported by this version of Excel. Formulas ...
  34. Some formulas in this workbook contain functions with more arguments than are supported in this version of Excel. Formulas ...
  35. Some formulas in this workbook contain more values, references and/or names than are allowed in this version of Excel. These ...
  36. Some formulas in this workbook use more operands than are allowed by this version of Excel. These formulas will not be opened ...
  37. Some formulas use more operands than are allowed by the selected file format. These formulas will not be saved and will be ...
  38. Some of the cells you are trying to change are password protected, but no one password will allow access to all of the cells. ...
  39. Some of the records did not import successfully.Because this workbook uses an older Excel file format, the maximum size of ...
  40. Some PivotTable cells contain circular references. Check your calculated field and item formulas to make sure that none of ...
  41. Some PivotTables in this workbook contain conditional formatting that may not function correctly in earlier versions of Excel. ...
  42. Some text formatting may have changed in this file because the maximum number of fonts was exceeded. It may help to close ...
  43. Some worksheets contain more array formulas that refer to other worksheets than are supported by the selected file format. ...
  44. Some worksheets in this workbook contain more array formulas that refer to another worksheet than are allowed in this version ...
  45. Specifies a data range that contains a list you want to use to create a custom list. To import list entries, click in the ...
  46. Specifies the entries for a custom list. Click a list that you want to edit, or click New List in the Custom Lists box to ...
  47. Specifies the folder from which Excel will automatically open files at startup. Type the path to the folder in the box to ...
  48. start_date,days,holidays!Returns the serial number of the date before or after a specified number of workdays!is a serial ...
  49. start_date,days,weekend,holidays!Returns the serial number of the date before or after a specified number of workdays with ...
  50. start_date,end_date,basis!Returns the year fraction representing the number of whole days between start_date and end_date!is ...
  51. start_date,end_date,holidays!Returns the number of whole workdays between two dates!is a serial date number that represents ...
  52. start_date,end_date,method!Returns the number of days between two dates based on a 360-day year (twelve 30-day months)!start_date ...
  53. start_date,end_date,weekend,holidays!Returns the number of whole workdays between two dates with custom weekend parameters!is ...
  54. start_date,months!Returns the serial number of the date that is the indicated number of months before or after the start ...
  55. start_date,months!Returns the serial number of the last day of the month before or after a specified number of months!is ...
  56. Stores data in binary format. Preserves VBA and Excel 4.0 macro sheets, takes less time to save, and helps keep sensitive ...
  57. sum_range,criteria_range,criteria,.!Adds the cells specified by a given set of conditions or criteria!are the actual cells ...
  58. Switching to page layout view will remove all frozen panes from this worksheet.Do you still want to switch to page layout ...
  59. Text values in formulas are limited to 255 characters. To create text values longer than 255 characters in a formula, use ...
  60. text!Changes full-width (double-byte) characters to half-width (single-byte) characters. Use with double-byte character sets ...
  61. text!Changes half-width (single-byte) characters within a character string to full-width (double-byte) characters. Use with ...
  62. text!Converts a text string that represents a number to a number!is the text enclosed in quotation marks or a reference to ...
  63. text!Converts a text string to all uppercase letters!is the text you want converted to uppercase, a reference or a text string! ...
  64. text!Converts a text string to proper case; the first letter in each word in uppercase, and all other letters to lowercase!is ...
  65. text!Converts all letters in a text string to lowercase!is the text you want to convert to lowercase. Characters in Text ...
  66. text!Removes all nonprintable characters from text!is any worksheet information from which you want to remove nonprintable ...
  67. text!Removes all spaces from a text string except for single spaces between words!is the text from which you want spaces ...
  68. text!Returns a numeric code for the first character in a text string, in the character set used by your computer!is the text ...
  69. text!Returns the number (code point) corresponding to the first character of the text!is the character that you want the ...
  70. text!Returns the number of characters in a text string!is the text whose length you want to find. Spaces count as characters! ...
  71. text!Returns the number of characters in a text string. Use with double-byte character sets (DBCS)!is the text whose length ...
  72. text,decimal_separator,group_separator!Converts text to number in a locale-independent manner!is the string representing ...
  73. text,number_times!Repeats text a given number of times. Use REPT to fill a cell with a number of instances of a text string!is ...
  74. text,num_bytes!Returns the specified number of characters from the end of a text string. Use with double-byte character sets ...
  75. text,num_bytes!Returns the specified number of characters from the start of a text string. Use with double-byte character ...