For line charts only, you can click Preferences on the Edit menu, and then specify on the Chart tab whether you want blanks and errors omitted, treated as zeros, or interpolated into the chart.
Flags the cell and enables error correction for cells that contain numbers that are stored as their textual representation, ...
Flags the cell and enables error correction for unlocked and editable cells that contain formulas, even in cases where the ...
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 ...
For help with choosing the right function and filling in its arguments, click the Edit Formula button (the = button) on the ...
For line charts only, you can click Preferences on the Edit menu, and then specify on the Chart tab whether you want blanks ...
fractional_dollar,fraction!Converts a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal ...
function_num,options,array,k!function_num,options,ref1,.!Returns an aggregate in a list or database!is the number 1 to 19 ...
function_num,ref1,.!Returns a subtotal in a list or database!is the number 1 to 11 that specifies the summary function for ...
Grouping is applied to one or more fields of this PivotTable. What-If Analysis cannot be enabled when grouping is applied. ...