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