Excel for Macintosh 2016

  1. Excel found errors that may cause some recovered data to be put in the wrong cells. Please check your recovered data carefully. ...
  2. Excel found more than one OLAP cube named |. Your data source might contain an error.Check your data source or create a new ...
  3. Excel found unreadable content in some parts of the Shared Workbook '|'. Excel can attempt to recover the contents of this ...
  4. Excel has detected that '|' is a SYLK file, but cannot load it. Either the file has errors or it is not a SYLK file format. ...
  5. Excel is unable to load the cached records for one or more PivotTable reports. You will need to refresh those reports before ...
  6. Excel ran out of resources while attempting to calculate one or more formulas. As a result, these formulas cannot be evaluated. ...
  7. Excel repaired or removed unreadable content from this workbook. Do you want to view the log file to see what changed, or ...
  8. Excel uses structured references, which use names rather than cell coordinates to reference a table or portions of a table. ...
  9. Excel was unable to correctly paste all of the data due to incompatibilities with the current file format. Please review ...
  10. Excel was unable to get necessary information about this cube. The cube might have been reorganized or changed on the server.Contact ...
  11. Excel was unable to load a necessary component. This component might have been damaged or deleted.Reinstall the client software ...
  12. Excel was unable to save the workbook because there was a problem reading or applying part of the revision history. You can ...
  13. Exports the data on the active sheet to a text file that can be used to exchange data with other spreadsheet applications. ...
  14. Exports the data on the active sheet to a text file that is compatible with Multiplan and other spreadsheet applications. ...
  15. Exports the selected cells, the active sheet, or all sheets in the workbook to PDF files, which look the same on Macintosh ...
  16. F7 is the keyboard shortcut for checking spelling. COMMAND+G is the shortcut for Find Next and COMMAND+SHIFT+G is the shortcut ...
  17. File is locked.In order to save changes to the file, you can either close the file before making any changes and then re-open ...
  18. file_name,file_origin,start_row,file_type,text_qualifier,consecutive_delim,tab,semicolon,comma,space,other,other_char,field_info ...
  19. find_text,replace_text,look_at,look_by,active_cell,match_case,match_byte,match_ctlchars,match_diac,match_kash,match_alefhamza ...
  20. find_text,within_text,start_num! Returns the number of the character at which a specific character or text string is first ...
  21. find_text,within_text,start_num!Finds the starting position of one text string within another text string. FINDB is case-sensitive. ...
  22. find_text,within_text,start_num!Returns the number of the character at which a specific character or text string is first ...
  23. find_text,within_text,start_num!Returns the starting position of one text string within another text string. FIND is case-sensitive!is ...
  24. First, specify the ranges. Type or select a worksheet range that contains data you want to summarize, and then click Add. ...
  25. Flags formulas as inconsistent when they do not follow the same pattern as the formulas in adjoining cells. For example, ...
  26. Flags the cell and enables error correction for cells that contain dates in text form that lack four digit dates such as ...
  27. Flags the cell and enables error correction for cells that contain dates in text form that lack four digit dates such as ...
  28. Flags the cell and enables error correction for cells that contain formulas or values that are inconsistent with the column ...
  29. Flags the cell and enables error correction for cells that contain numbers that are stored as their textual representation, ...
  30. Flags the cell and enables error correction for unlocked and editable cells that contain formulas, even in cases where the ...
  31. For a quicker way to name a range, first select the range, and then type the name into the box to the left of the formula ...
  32. For help with choosing the right function and filling in its arguments, click the Edit Formula button (the = button) on the ...
  33. For line charts only, you can click Preferences on the Edit menu, and then specify on the Chart tab whether you want blanks ...
  34. fractional_dollar,fraction!Converts a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal ...
  35. function_num,options,array,k!function_num,options,ref1,.!Returns an aggregate in a list or database!is the number 1 to 19 ...
  36. function_num,ref1,.!Returns a subtotal in a list or database!is the number 1 to 11 that specifies the summary function for ...
  37. Grouping is applied to one or more fields of this PivotTable. What-If Analysis cannot be enabled when grouping is applied. ...
  38. Helps you complete formulas that are typed into a cell. If the first entry is =, Excel displays all available functions and ...
  39. Hides all graphic objects, buttons, text boxes, drawn objects, and pictures. Excel does not print hidden objects. Affects: ...
  40. hour,minute,second!Converts hours, minutes, and seconds given as numbers to an Excel serial number, formatted with a time ...
  41. If a PivotTable value is affected by two or more calculated items, the last formula in the solve order will calculate that ...
  42. If a supported e-mail client is installed on this machine, you can send your workbook by electronic mail. Point to Send To ...
  43. If colored areas on your worksheet do not print well, choose Page Setup from the File menu, and then select the 'Black and ...
  44. If one or more fields in the PivotTable have calculated items, no fields can be used in the data area two or more times, ...
  45. If the formula requires a function, select the function from the list at the left of the formula bar. You can also type a ...
  46. If the letters you type into a formula closely match a function name, named range, Excel automatically enters it in the cell. ...
  47. If the name 'Sheet_Title' is defined in the supporting sheet, the cell it refers to is used to name the data in the consolidated ...
  48. If the password is lost or forgotten, it can't be recovered and you won't be able to open this workbook. Passwords are case-sensitive. ...
  49. If the preview chart looks the way you want, the data range is already correct.To change the data and labels for the chart, ...
  50. If the user you selected is currently editing the workbook, this action will prevent the user from saving the workbook, and ...
  51. If you already specified the data for the chart on the Data Range tab, the ranges, names, and labels are correct.However, ...
  52. If you are sure this workbook is from a trusted source, click Yes. If you are not sure and want to prevent any macros from ...
  53. If you clicked a cell in your list before you started the PivotTable Wizard, Microsoft Excel has automatically detected a ...
  54. If you continue, the previous PivotTable formatting will be lost the next time you refresh the PivotTable or change the layout. ...
  55. If you do not select a range first, list management commands act on the range named 'Database'. If you want another range, ...
  56. If you don't know which function to use, type a brief description of what you want to do in the box, and then click Search. ...
  57. If you don't see the PivotTable you want in the list:The PivotTable might be in a different workbook. Copy the PivotTable ...
  58. If you don't want to be prompted for summary information when you save a new workbook, choose Preferences from the Edit menu, ...
  59. If you don't want to edit directly in cells, choose Preferences from the Edit menu and then clear the 'Edit Directly in Cell' ...
  60. If you don't want to paste objects along with cells, choose Preferences from the Edit menu, and then clear the 'Cut, Copy, ...
  61. If you double-click the Format Painter button it will stay selected so that you can paint multiple areas with the same formats. ...
  62. If you have installed the Solver add-in, you can use the Solver command on the Tools menu to optimize a formula based on ...
  63. If you have named a range of cells on a worksheet, you can go to that range if you click the arrow to the left of the formula ...
  64. If you have never created any Visual Basic code before, you may find it easier to first record a macro and then edit the ...
  65. If you know the result that you want a formula to produce, use Goal Seek on the Tools menu to try different values until ...
  66. If you modify the MDX definition of the set, any additional modifications can only be done using MDX as well. Click OK to ...
  67. If you need help choosing a function and entering its arguments, click the Paste Function button on the Standard toolbar. ...
  68. If you need more complex text editing than a text box can provide, you can embed a Microsoft Word document in a worksheet. ...
  69. If you often hide and unhide rows and columns to see different views of your data, use an outline to hide or show levels ...
  70. If you remove the change history, you will no longer be able to merge copies of this workbook. Do you want to continue?To ...
  71. If you save a workbook as a template, you can create a new workbook containing the same formatting and styles simply by opening ...
  72. If you surround your list with blank rows and columns, the Subtotals command (Data menu) will select the correct data to ...
  73. If you turn off the Accept Labels In Formulas option, Microsoft Excel replaces any labels you used in formulas with cell ...
  74. If you want a workbook to be opened whenever you start Microsoft Excel, put the workbook in the Microsoft Office X:Office:Startup:Excel ...
  75. If you want cells to always appear with a certain formatting even after they have been cut or cleared, change the Normal ...