Excel for Macintosh 2016

  1. To hide the selected sheet, point to Sheet on the Format menu, and then choose Hide. To display a hidden sheet, choose Unhide. ...
  2. To include more than one chart type in a chart (for example, Column and Area), select a data series and change its chart ...
  3. To increment months, weekdays, quarters, or other series, select the first item in the series, and then drag the fill handle ...
  4. To insert an indent, you can click on the Increase Indent button on the Formatting toolbar. To remove an indent, click on ...
  5. To insert the current date into the formula bar, press COMMAND+HYPHEN. To insert the current time, press COMMAND+; (semicolon). ...
  6. To keep the proportions of an object constant, hold down SHIFT while dragging a corner. To align the object to the worksheet ...
  7. To link the chart title or axis title to a worksheet cell, select the title, click the formula bar, and then type an equal ...
  8. To make a chart template into a custom chart type, click Chart Type on the Chart menu, click the Custom Types tab, click ...
  9. To make text or numbers italic, you can click the Italic button on the Standard toolbar. To remove the italic format, click ...
  10. To make the active chart into a custom template, click Chart Type on the Chart menu, click the Custom Types tab, click User-Defined, ...
  11. To more easily select a large range, select one corner of the range, scroll to the other corner, and then hold down SHIFT ...
  12. To move a docked toolbar to the last floating position it occupied, double-click the toolbar background. Double-click again ...
  13. To move cell contents, drag the border of the selected cells to another location. To copy cell contents, hold down OPTION ...
  14. To move the selected cells to another part of the worksheet, drag the border; to copy the cells, hold down OPTION while dragging. ...
  15. To move to the top of a block of data, double-click the top border of the selected cell. You can double-click the other borders ...
  16. To outline rows or columns so that they can be easily shown or hidden, select the rows or columns, point to Group And Outline ...
  17. To paste a picture of a cell, chart, or graphic object into another application, select the object, then hold down SHIFT ...
  18. To perform the same action on nonadjacent ranges, select the first range, and then hold down COMMAND while you select the ...
  19. To prevent a column from being imported, use the 'Do Not Import Column (Skip)' option on the last step of the Text Import ...
  20. To prevent an object from being printed on a sheet, select the object, click the type of object on the Format menu, and then ...
  21. To prevent others from modifying a particular sheet, point to Protection on the Tools menu, and then choose Protect Sheet. ...
  22. To prevent others from opening your workbook, choose Save As from the File menu, choose the Options button, and type a password ...
  23. To prevent possible loss of data, Microsoft Excel cannot shift nonblank cells off the worksheet.Try to delete or clear the ...
  24. To prevent the footer from overlapping worksheet data, choose Page Setup from the File menu, select the Margins tab, and ...
  25. To prevent the header from overlapping worksheet data, choose Page Setup from the File menu, select the Margins tab, and ...
  26. To print a group of sheets, hold down SHIFT or COMMAND while you click the sheet tabs, and then click Print on the File menu. ...
  27. To print a sheet on a fixed number of pages, choose Page Setup from the File menu, select the Page tab, and then type the ...
  28. To print colored cells more clearly on a black and white printer, choose Page Setup from the File menu, then select the 'Black ...
  29. To print column titles on each page, choose Page Setup from the File menu, select the Sheet tab, select 'Rows to Repeat at ...
  30. To print more than one copy of a sheet, type the number of copies you want in the Copies box in the Print dialog box (File ...
  31. To print only part of the worksheet, select the area you want to print, point to Print Area on the File menu, and click Set ...
  32. To print without gridlines, choose Page Setup from the File menu, and then clear the Gridlines check box on the Sheet tab. ...
  33. To print your sheet at a different scale without changing its appearance on the screen, choose Page Setup from the File menu ...
  34. To protect a workbook so that a password is required to open it or save changes to it, click Save As on the File menu and ...
  35. To publish the entire workbook as an interactive web page, you must have at least one worksheet in this workbook. Chart sheets, ...
  36. To put an outline border around a range of cells, choose Cells from the Format menu, and then select Outline on the Border ...
  37. To remove all the page breaks on a sheet, select the entire sheet and then click Reset All Page Breaks on the Insert menu. ...
  38. To retrieve external data fields, you use Microsoft Query, a tool that lets you return external data to a PivotTable.To start ...
  39. To review the names defined in a workbook, point to Name on the Insert menu, choose Paste, and then choose the Paste List ...
  40. To run this query, you must specify an external data source.The query that you are running is dependent on an external data ...
  41. To save as XML Spreadsheet, you must have at least one worksheet in this workbook. Chart sheets, Excel 4.0 Macro sheets, ...
  42. To save time by limiting calculation to the active sheet, click Preferences on the Edit menu, then click the Calc Sheet button ...
  43. To see more of a worksheet at once, change the percentage in the Zoom box on the Standard toolbar to less than 100. Or choose ...
  44. To select all sheets, hold down CONTROL while you click any sheet tab, and then choose Select All Sheets from the shortcut ...
  45. To select only the blank cells in a region, select the region, choose Go To from the Edit menu, choose the Special button, ...
  46. To send a document to several people in turn, click Mail from the File menu, then click Send To, and then click Routing Recipient. ...
  47. To set the print layout options for a group of sheets, hold down COMMAND while you click the sheet tabs to select the sheets, ...
  48. To set the starting page number for the active sheet, choose Page Setup from the File menu, then type the number in the 'First ...
  49. To specify how to fill data, drag the fill handle at the corner of the selection while holding down CONTROL. A shortcut menu ...
  50. 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 ...
  51. To speed up scrolling for embedded charts and bitmaps, click Preferences on the Edit menu, click the View tab, and then select ...
  52. To speed up your work: click Preferences on the Edit menu, click the Calculation tab, select Manual, and click OK. To recalculate ...
  53. To split a window, either drag the split box located above the vertical scroll bar or drag the split box to the right of ...
  54. To underline currency figures, click Cells on the Format menu, click the Font tab, and select the Single Accounting or Double ...
  55. To underline text or numbers, click the Underline button on the Formatting toolbar. To remove underlining, click the button ...
  56. To undo your last action, click the Undo button on the Standard toolbar. Click it again to undo the previous action. To repeat ...
  57. To update a Microsoft Excel 4 crosstab table to a Microsoft Excel PivotTable, click the crosstab table, and then click PivotTable ...
  58. To update links without being prompted, choose Preferences from the Edit menu, and then clear the 'Ask to Update Automatic ...
  59. To use the layout of the current chart for all new charts, choose Chart Type on the Chart menu, click the Custom Types tab, ...
  60. To view the unsupported content in the file, you can open the workbook as read-only. However, if you change and then save ...
  61. To view your sheets at different levels of magnification, choose Zoom from the View menu or use the Zoom box on the Standard ...
  62. To zoom the window to exactly fit a certain area, select the area, choose Zoom from the View menu, and then select the Fit ...
  63. trials,probability_s,alpha!Returns the smallest value for which the cumulative binomial distribution is greater than or equal ...
  64. trials,probability_s,alpha!This function is available for compatibility with Excel 2008 and earlier.Returns the smallest ...
  65. trials,probability_s,number_s,number_s2!Returns the probability of a trial result using a binomial distribution!is the number ...
  66. Turn on or off the total row of the table.The total row is a row at the end of the table which displays totals for each column. ...
  67. Type a new name in the User Name box to change your user name. The name you enter is used by Excel to create file properties, ...
  68. Type a password if you'd like to password-protect this workbook. You can only add a password when the workbook isn't being ...
  69. Type or select a worksheet range that contains data you want to summarize, and then click Add. Repeat for each range you ...
  70. type_text!Returns information about the current operating environment!is text specifying what type of information you want ...
  71. Unable to convert graphic. The installed WordPerfect graphics filter is an old version. Continue with document conversion? ...
  72. Unable to retrieve information for | slicer(s). In some cases, this can be due to a custom value in the DefaultMember property ...
  73. Unexpected file lock by |.Please try again, and then if necessary, use the Share Workbook command (Tools menu) to turn off ...
  74. Unexpected file lock by |.You can override this file lock, or continue without doing so. If you continue without overriding ...
  75. Uninitialized ActiveX controls cannot be transferred to the selected file format. The controls will be lost if you continue. ...