To create different sets of assumptions about the variables in your sheet and then switch between these sets, choose Scenarios from the Tools menu.
To copy the formula in the active cell to all cells in the selected range, press CONTROL+U, and then press OPTION+RETURN. ...
To copy without incrementing (for most selections), hold down OPTION while you drag the fill handle at the corner of the ...
To create a chart, click Add to add a data series. Then, type the series information or enter cell references in the Name ...
To create a chart, click in the Data range box. Then, on the worksheet, select the cells that contain the data and labels ...
To create different sets of assumptions about the variables in your sheet and then switch between these sets, choose Scenarios ...
To create interactive tables that automatically total data, easily hide or show details, and pivot to change perspective ...
To create this stock chart, arrange the data on your sheet in this order: opening price, high price, low price, closing price. ...
To create this stock chart, arrange the data on your sheet in this order: volume traded, high price, low price, closing price. ...
To create this stock chart, arrange the data on your sheet in this order: volume traded, opening price, high price, low price, ...