UI Translation

Excel for Macintosh 2016

  1. This workbook is encrypted. If you save in this format, the encryption will be removed from this workbook. Do you want to ...
  2. This workbook uses more rows and/or columns than are supported in this version of Excel. Any data outside 256 (IV) columns ...
  3. This workbook was recovered from a file that had some unreadable content. Some parts of the revision history may be missing. ...
  4. This workbook will be read-only and shared workbook features will not be available when someone opens it in an earlier version ...
  5. This XML file cannot be opened because of an error. Check to make sure the file is a valid XML file, and that the XML syntax ...
  6. time_text!Converts a text time to an Excel serial number for a time, a number from 0 (12:00:00 AM) to 0.999988426 (11:59:59 ...
  7. To add a border to the bottom of a cell, hold down COMMAND+OPTION+DOWN ARROW. You can press the other arrow keys to add borders ...
  8. To add labels to all points in a series, select the series, click Selected Data Series on the Format menu, click the Data ...
  9. To adjust column widths for best fit for many columns at once, select all the columns and then double-click the right border ...
  10. To adjust row heights for best fit for many rows at once, select all the rows and then double-click the bottom border of ...
  11. To allow multiple filters per field, you must refresh the PivotTable.On the PivotTable tab, under Data, click Refresh, and ...
  12. To apply the format shown on the button, click the button itself. To apply a different format, click the arrow next to the ...
  13. To avoid being asked if you want to replace the contents of destination cells, choose Preferences from the Edit menu, then ...
  14. To back up the previous version of a workbook each time you save a new version, choose Save As from the File menu, choose ...
  15. To begin programming in Visual Basic for Applications, first record a macro. Then point to Macro on the Tools menu, click ...
  16. To change the amount that bars or columns overlap, click a data series and then click Selected Data Series on the Format ...
  17. To change the chart type without losing custom formatting you have applied, use the Chart Type button on the Chart toolbar. ...
  18. To change the default font for workbooks created in future sessions, click Preferences on the Edit menu, then change the ...
  19. To change the default formats for the entire workbook, click Style on the Format menu, and then change the format of the ...
  20. To change the height of a row to accommodate the tallest character in that row, double-click the bottom boundary of the row ...
  21. To change the image on a button, click a toolbar button while holding down CONTROL and choose Properties. Next, click the ...
  22. To change the number of colored regions on a 3-D surface chart, select the value axis, click Selected Axis on the Format ...
  23. To change the point at which the category and value axes cross, double-click the category axis, select the Scale tab, and ...
  24. To change the point at which the category and value axes cross, double-click the value axis, select the Scale tab, and change ...
  25. To change the way an object is sized when the underlying cells are resized, select the object, click the type of object on ...
  26. To change the way an object moves when the underlying cells are moved, select the object, click the type of object on the ...
  27. To change the width of a column to accommodate the widest data in that column, double-click the right boundary of the column ...
  28. To check the spelling of text in the active worksheet or chart, choose Spelling from the Tools menu or click the Spelling ...
  29. To check the spelling of text on a chart, use the Spelling button or the Spelling command on the Tools menu. All text that ...
  30. To clear a range of cells, drag the fill handle up and to the left. The fill handle is located at the corner of the selection. ...
  31. To combine chart types in a chart, click a data series, click Chart Type on the Chart menu, and then click the chart type ...
  32. To control who can change a workbook, click Save As on the File menu, click Options, and then type a password in the Password ...
  33. To convert preformatted HTML text into a table, select the column or range of text, and then click Text To Columns on the ...
  34. To copy a chart's formats to another chart, select the chart, copy it, select the other chart, and then choose Paste Special ...
  35. To copy a picture of the selected range onto a worksheet, hold down SHIFT, and click Copy Picture on the Edit menu. Then ...
  36. To copy data into another application that supports OLE, drag the data from Microsoft Excel to the other application's window. ...
  37. To copy text into a text box, copy the text in the formula bar, position the insertion point in the text box, and then paste ...
  38. To copy the formula in the active cell to all cells in the selected range, press CONTROL+U, and then press OPTION+RETURN. ...
  39. To copy without incrementing (for most selections), hold down OPTION while you drag the fill handle at the corner of the ...
  40. To create a chart, click Add to add a data series. Then, type the series information or enter cell references in the Name ...
  41. To create a chart, click in the Data range box. Then, on the worksheet, select the cells that contain the data and labels ...
  42. To create different sets of assumptions about the variables in your sheet and then switch between these sets, choose Scenarios ...
  43. To create interactive tables that automatically total data, easily hide or show details, and pivot to change perspective ...
  44. To create this stock chart, arrange the data on your sheet in this order: opening price, high price, low price, closing price. ...
  45. To create this stock chart, arrange the data on your sheet in this order: volume traded, high price, low price, closing price. ...
  46. To create this stock chart, arrange the data on your sheet in this order: volume traded, opening price, high price, low price, ...
  47. To create your own combination chart, select a series on the chart, and then use the Chart Type button on the Chart toolbar ...
  48. To decrease all the values in a range by 10 percent, type .9 in a cell. Copy the cell and select the range. Choose Paste ...
  49. To delete a range of cells, hold down SHIFT while you drag the fill handle up and to the left. The fill handle is located ...
  50. To display long text, click the Text Box button to create a text box. You can also embed a Microsoft Word document in your ...
  51. To display numbers in thousands or millions, create a number format that ends with one or two commas. For example, the format ...
  52. To display the value of a cell in a text box, select the text box and type an equal sign (=) followed by a cell reference ...
  53. To draw multiple objects in succession, double-click a drawing button. When you're finished, click the drawing button again. ...
  54. To edit the contents of more than one sheet at a time, hold down COMMAND while you click the tabs of the sheets you want ...
  55. To edit the macro you just recorded, point to Macro on the Tools menu, click Macros, select the macro, and then choose the ...
  56. To ensure that only a particular range is printed whenever you print this sheet, choose Page Setup from the File menu, select ...
  57. To enter a reference to an entire row or column, type the row number or column letter twice, separated by a colon (for example, ...
  58. To enter cell references as an argument, click {hbmp 708} to temporarily hide the dialog box. Select the cells on the worksheet; ...
  59. To enter information down a column without having to use the Down Arrow key, choose Preferences from the Edit menu and select ...
  60. To fill down, press CONTROL+D.Some shortcut keys have changed in this version. To see a current list of shortcut keys, search ...
  61. To filter your list to show important subsets of the data, select a cell in the list, point to Filter on the Data menu, and ...
  62. To find the blank cells within a range, select that range. Then, choose Go To from the Edit menu, choose the Special button, ...
  63. To fit your sheet in one dimension only, leave one of the Fit To Page boxes blank. You can use this to make your printed ...
  64. To fix overlapping data labels in a pie chart, drag a data label to another location. Or click a data label, and then click ...
  65. To fix truncated labels on an axis, double-click the labels, and then change the rotation angle on the Alignment tab. If ...
  66. To format a PivotTable so that rearranging the table will not change the formatting, make sure Enable Selection is checked ...
  67. To format numbers so that negative values are red, you can use one of the built-in number formats. Choose Cells from the ...
  68. To format the data in a cell with single or double underlining, click Cells on the Format menu, click the Font tab, and then ...
  69. To go to a cell reference or a named area, type the reference in the Name box to the left of the formula bar, or click its ...
  70. To group several graphic objects so that you can move or size them at once, select all the objects, and then click Group ...
  71. To have subtotals inserted into your list automatically, select any cell in the list and then choose Subtotals from the Data ...
  72. To have the Trend, Growth, Linest, or Regress function return multiple values, select a range for the values, and then press ...
  73. To help eliminate circular references, use the Auditing commands on the Circular Reference toolbar to trace references on ...
  74. To hide items in a PivotTable, select the items, click the PivotTable Field button on the PivotTable toolbar, and then select ...
  75. To hide multiple items in a PivotTable, select one of the items, click the PivotTable Field button on the PivotTable toolbar, ...
Deutsch (Deutschland)
German (Germany) Español (España)
Spanish (Spain) Français (France)
French (France) italiano
Italian 日本語
Japanese 한국어
Korean Português
Portuguese Русский
Russian English
English (United States)