Excel for Macintosh 2016
- If you want the text box to automatically resize to fit the text, select the text box, click Text Box on the Format menu, ...
- If you want to be asked each time you open a workbook whether to open it as read-only, choose Save As from the File menu, ...
- If you want to define your own custom sort order, click Preferences on the Edit menu, and then click the Custom Lists tab. ...
- If you want to freeze a row at the top of the window, select the row below it, and then choose Freeze Panes from the Window ...
- If you want to permanently change the source file of a link, choose Links from the Edit menu, select the link in the list, ...
- If you want to place the PivotTable on an existing worksheet, type or select the cell reference for only for the upper-left ...
- If you want to print the worksheet with gridlines, choose Page Setup from the File menu and select the Gridlines check box ...
- If you want to print the worksheet without gridlines, choose Page Setup from the File menu and clear the Gridlines check ...
- If you want to reapply your number format when data is pivoted or refreshed, select the data field in the PivotTable, choose ...
- If you want to search only within a certain range of cells for a specific value, select the range before you choose Find. ...
- If you want to select an object that has a macro assigned to it without running the macro, hold down COMMAND while you click ...
- If you want to track reviewers' changes in this workbook, you need to make this workbook shared. Do you want to save a shared ...
- If you'd like all new workbooks to be based on the template you just opened, save the template with the name 'Workbook' in ...
- If you'd like to apply this same autoformat again, use the AutoFormat button. It remembers the last AutoFormat you applied. ...
- In languages that capitalize names of days, automatically capitalizes the first letter of the names when you enter them into ...
- In most charts, you can format an individual data marker. Click the marker until it is the only one selected, and then click ...
- In this step, you identify the ranges of data you want to combine in the PivotTable, and then assign the ranges to page field ...
- index_num,value1,value2,.!Chooses a value or action to perform from a list of values, based on an index number!specifies ...
- Indicates the earliest two-digit year that you want Excel to interpret as being in the twenty-first century. For example, ...
- Indicates where Excel will automatically put the decimal point in the numbers you enter as constants on a sheet. A positive ...
- info_type,reference!Returns information about the formatting, location, or contents of the first cell, according to the sheet's ...
- Initialization of the data source failed.Check the database server or contact your database administrator. Make sure the ...
- Inserts an icon that represents the contents of the file into your document. Changes to the source file will be reflected ...
- Inserts the contents of the file into your document and creates a link to the source file. Changes to the source file will ...
- Inserts the contents of the file into your document so that you can edit it later using the program which created the source ...
- Instead of hiding the horizontal scroll bar, you can make it smaller by dragging the handle at its left. To restore the scroll ...
- inumber!Returns the absolute value (modulus) of a complex number!is a complex number for which you want the absolute value! ...
- inumber!Returns the hyperbolic cosecant of a complex number!is a complex number for which you want the hyperbolic cosecant! ...
- inumber!Returns the imaginary coefficient of a complex number!is a complex number for which you want the imaginary coefficient! ...
- inumber,number!Returns a complex number raised to an integer power!is a complex number you want to raise to a power!is the ...
- inumber1,inumber2!Returns the difference of two complex numbers!is the complex number from which to subtract inumber2!is ...
- inumber1,inumber2!Returns the quotient of two complex numbers!is the complex numerator or dividend!is the complex denominator ...
- inumber1,inumber2,.!Returns the product of 1 to 255 complex numbers!Inumber1, Inumber2,. are from 1 to 255 complex numbers ...
- is a calculated column.Allow any values to appear in this column? If you choose Yes, the calculated formula will no longer ...
- is a calculated column.Use this new formula for all rows in the list? If you choose No, this formula will not propagate to ...
- is not recognized as a text file. Do you still want to open it?Excel can open this file as if it is a text file, but the ...
- is used to calculate other columns. Are you sure you want to delete it?If you delete |0, calculations will be adjusted in ...
- is used to calculate other columns. Are you sure you want to insert it?If you insert |0, calculations will be adjusted in ...
- issue,first_interest,settlement,rate,par,frequency,basis,calc_method!Returns the accrued interest for a security that pays ...
- issue,settlement,rate,par,basis!Returns the accrued interest for a security that pays interest at maturity!is the security's ...
- Keeps graphic objects, buttons, text boxes, drawn objects, and pictures with their associated cells when you cut, copy, filter, ...
- known_y's,known_x's!Calculates the point at which a line will intersect the y-axis by using a best-fit regression line plotted ...
- known_y's,known_x's!Returns the slope of the linear regression line through the given data points!is an array or cell range ...
- known_y's,known_x's!Returns the square of the Pearson product moment correlation coefficient through the given data points!is ...
- known_y's,known_x's!Returns the standard error of the predicted y-value for each x in a regression!is an array or range of ...
- known_y's,known_x's,const,stats!Returns statistics that describe a linear trend matching known data points, by fitting a ...
- known_y's,known_x's,const,stats!Returns statistics that describe an exponential curve matching known data points!is the set ...
- known_y's,known_x's,new_x's,const!Returns numbers in a linear trend matching known data points, using the least squares method!is ...
- known_y's,known_x's,new_x's,const!Returns numbers in an exponential growth trend matching known data points!is the set of ...
- Label references in this file will change to standard cell references.This version of Excel doesnâ t support label references. ...
- Limits iteration for goal seeking or for resolving circular references. Unless you specify otherwise, Excel stops after 100 ...
- link_location,friendly_name!Creates a shortcut or jump that opens a document stored on your hard drive, a network server, ...
- Locking objects has no effect unless the sheet is protected. To protect the sheet, choose Protection from the Tools menu, ...
- Locking objects has no effect unless the sheet is protected.To help protect the sheet, choose Format on the Home tab, and ...
- logical1,logical2,.!Checks whether all arguments are TRUE, and returns TRUE if all arguments are TRUE!are 1 to 255 conditions ...
- logical1,logical2,.!Checks whether any of the arguments are TRUE, and returns TRUE or FALSE. Returns FALSE only if all arguments ...
- logical1,logical2,.!Returns a logical 'Exclusive Or' of all arguments!are 1 to 254 conditions you want to test that can be ...
- logical_test,value_if_true,value_if_false!logical_test!Checks whether a condition is met, and returns one value if TRUE, ...
- lookup_value,lookup_array,match_type!Returns the relative position of an item in an array that matches a specified value ...
- lookup_value,table_array,col_index_num,range_lookup!Looks for a value in the leftmost column of a table, and then returns ...
- lookup_value,table_array,row_index_num,range_lookup!Looks for a value in the top row of a table or array of values and returns ...
- lower_limit,upper_limit!Returns the error function!is the lower bound for integrating ERF!is the upper bound for integrating ...
- Make sure Visual Basic for Applications is installed on your computer. If Visual Basic for Applications is installed, make ...
- Makes an adjacent cell the next active cell after you press RETURN in the current active cell. On the Direction pop-up menu, ...
- Manage the lists that you create to automatically fill cells or sort data in unique ways. For example, a custom list can ...
- may contain features that are not compatible with |1. Do you want to keep the workbook in this format? To keep this format, ...
- Memory was used up attempting to convert and save PivotTable data from a different version.Data for the saved PivotTable(s) ...
- Microsoft Excel automatically assigned names to your page fields. To give them different names, click a page field and then ...
- Microsoft Excel can convert only one column at a time.The range can be many rows tall but no more than one column wide. Try ...
- Microsoft Excel cannot access the file '|'.There are several possible reasons: The file name or path name does not exist. ...
- Microsoft Excel cannot calculate a formula.Cell references in the formula refer to the formula's result, creating a circular ...
- Microsoft Excel cannot calculate a formula.There is a circular reference in an open workbook, but the references that caused ...
- Microsoft Excel cannot complete this operation because the ODBC Driver Manager is not installed. To install the ODBC Driver ...
- Microsoft Excel cannot create or use the data range reference because it is too complex. Try one or more of the following: ...
- Microsoft Excel cannot determine which row in your list or selection contains column labels, which are required for this ...