Excel for Macintosh 2016

  1. You can type an asterisk (*) in the Find What box to match any number of characters or a question mark (?) to match any single ...
  2. You can use an ampersand (&) to concatenate text strings in a formula. For example, if A1 contains 'week' and A2 contains ...
  3. You can use custom graphics as markers in a bar, column, line, or radar chart. With the markers selected, paste a picture ...
  4. You can use page fields to view each range of data on a separate page, or to summarize all of the ranges on the same page.Microsoft ...
  5. You can use the Add-Ins command on the Tools menu to specify the add-ins you want to open each time you start Microsoft Excel. ...
  6. You can use the arrow keys to move around within a formula. First press CONTROL+U until you see the word 'Edit' at the left ...
  7. You can use the Consolidate command from the Data menu to combine corresponding values in different sheets onto a summary ...
  8. You can use the Goal Seek command on the Tools menu to reach a target value for one cell by changing the value in another ...
  9. You can use the Name box to define or go to a name. To delete a name, point to Name on the Insert menu, choose Define, select ...
  10. You can use the name box to the left of the formula bar to select from a list of names already defined on the sheet. This ...
  11. You can use the Page Setup command on the File menu to specify the size of the chart when printed. Select Full Page, Scale ...
  12. You can use the Scenarios command (Tools menu) to change the values in a set of cells and see the effect on the rest of your ...
  13. You can view two parts of the same document at once. From the Window menu, choose Split to see both parts in one window, ...
  14. You can zoom a group of sheets at once by holding down COMMAND while you click the sheet tabs to select the sheets, and then ...
  15. You can't save files directly to this location. Try saving the files to a different location, and then copying them to this ...
  16. You cannot change the chart type to a stock chart.A stock chart requires three, four, or five series of data to plot a single ...
  17. You cannot change the font of individual characters in a number or formula. Insert a ' (apostrophe) before the number to ...
  18. You cannot combine 2-D and 3-D chart types.Do you want to change the data series from the 2-D chart so that you can combine ...
  19. You cannot combine 2-D and 3-D chart types.Do you want to change the data series from the 3-D chart so that you can combine ...
  20. You cannot combine the bubble chart type with other chart types.Do you want to change the chart type of all the data series ...
  21. You cannot create a PivotTable based on source data with more than 16384 columns. Reduce the number of columns and try again. ...
  22. You cannot create or make changes to lists in a shared workbook.If you copy a list and paste it in a shared workbook, only ...
  23. You cannot create or make changes to PivotChart reports in a shared workbook. To make a copy that you can edit and rearrange, ...
  24. You cannot create or make changes to PivotTable reports in a shared workbook. If you copy a report and paste it in a shared ...
  25. You cannot edit the formulas in data cells for groups or for calculated fields.To change the formula for a calculated field, ...
  26. You cannot filter by value for this field in the PivotTable report because the OLAP data source does not contain grand totals ...
  27. You cannot group items in this field because it's set to query for each item separately when it's in the page position.Drag ...
  28. You cannot make changes to this table until you refresh it with SharePoint Foundation. Alternatively, you can unlink the ...
  29. You cannot move a part of a PivotTable report, or insert worksheet cells, rows, or columns inside a PivotTable report. To ...
  30. You cannot place a field that has more than | items in the column area.If you want to use this field in the report, click ...
  31. You cannot rename this module.Try one of the following: Choose a name that includes only alphanumeric characters. Make sure ...
  32. You cannot save the Personal Macro Workbook in the startup folder.Save it elsewhere now and move it to the startup folder ...
  33. You cannot save this workbook with the same name as another open workbook or add-in. Choose a different name, or close the ...
  34. You cannot select an item in this field by typing the item name. To select an item for display, click OK, press ESC, and ...
  35. You cannot show more detail for that selection. The data displayed is the lowest level of detail available in the source ...
  36. You cannot use a direct reference to a worksheet range in a | formula.Change the reference to a single cell, or use the reference ...
  37. You cannot use that name when you create a view in a shared workbook.Microsoft Excel reserves views named with your username ...
  38. You customized the axis of your chart by specifying a base unit for the time scale.However, the numbers you specified for ...
  39. You do not have permission to save files to this location.Make sure that you have write access for this location, or select ...
  40. You do not have permission to save files to |.Make sure that you have write access for this location, or select a different ...
  41. You do not need to use the Toolbars command to move or reshape a toolbar. You can reshape a floating toolbar by dragging ...
  42. You don't have to close the default workbook manually. Opening another workbook at the start of a session closes the default ...
  43. You don't need to select the entire list first. These commands act on the list containing the selected cell: Sort, Filter, ...
  44. You have changed the standard font for all future sessions. To change the standard font for this workbook only, choose Style ...
  45. You have configured this Web page so that supporting files are in a folder, but you don't have privileges to create a folder ...
  46. You have copied cells that are not visible. To copy only visible cells, choose Go To from the Edit menu, click the Special ...
  47. You have created several toolbars each containing a single button. If you put these buttons onto a single toolbar, you can ...
  48. You have entered an invalid source range for your PivotTable. Enter a valid range in the Ranges box and then choose Add. ...
  49. You have interrupted an AutoRecover save.AutoRecover periodically saves a backup copy of your file. Do you want to disable ...
  50. You have made changes to values in the PivotTable that will be hidden by performing this operation.If you do not calculate ...
  51. You have not specified any source ranges for your PivotTable.Type or select at least one range in the Ranges box before choosing ...
  52. You must specify a data field.The available fields appear on the right side of the wizard window. Drag a field and drop it ...
  53. You must turn off mark as final for this workbook before it can be checked out. Would you like to turn off mark as final ...
  54. You've selected a single cell for the print area. If this is correct, click OK. If you selected a single cell by mistake, ...
  55. You've selected a single cell to save as a web page. If this is correct, click OK. If you would like this macro to save a ...
  56. Your changes cannot be made because this is a protected sheet.To remove protection, on the Tools menu, point to Protection, ...
  57. Your changes could not be saved to '|1', but were saved to a temporary document named '|0'. Close the existing document, ...
  58. Your data includes both numbers and text. Type ' (apostrophe) at the beginning of each number to change it to text. Your ...
  59. Your formula cannot be entered because calculated fields cannot contain circular references. Change the formula to make sure ...
  60. Your formula contains an invalid external reference to a worksheet.Verify that the path, workbook, and range name or cell ...
  61. Your formula includes a function that cannot be used in PivotTable formulas.You cannot use functions that return variable ...
  62. Your formula is incomplete.You must include an operand following each operator. For example, =A1+A2+ is missing an operand ...
  63. Your new PivotTable might use less memory if you base it on your existing PivotTable |.Do you want this PivotTable to use ...
  64. Your new PivotTable will use less memory if you base it on your existing PivotTable |, which was created from the same source ...
  65. Your Office 365 subscription covers multiple computers and devices, including your iPad. Your documents are always in sync ...
  66. Your selection overlaps one or more external data ranges. Do you want to convert the selection to a table and remove all ...
  67. Your workbook contains a function category with a custom name. If you save as a Web Page, then open the workbook in Excel ...
  68. Your workbook contains a function category with a custom name. If you save as an XML Spreadsheet, then open the workbook ...
  69. Your worksheet is only slightly larger than one page. To print it on one page, choose Page Setup from the File menu, then ...
  70. z!This function is available for compatibility with Excel 2008 and earlier.Returns the standard normal cumulative distribution ...
  71. z,cumulative!Returns the standard normal distribution (has a mean of zero and a standard deviation of one)!is the value for ...