Manipulate Numbers Document For Free

Edit content: Double-click a cell to make the insertion point appear, then type. To move the insertion point, click where you want it, then type. Replace content: Click the cell, then start typing. The existing content is overwritten.

You can edit an existing formula so that it refers to different cells. Double-click the results cell containing the formula you want to edit. The formula editor opens. Do any of the following: ... Press Return or click the Checkmark button in the formula editor when you're done.

Change an existing formula Double-click the result cell with the formula you want to edit. The formula editor opens, displaying the formula. ... Do any of the following: Change the cell references: Select the existing cell addresses you want to change, then select the new cells. ... Press Return or click.

Select a cell, click on it. Then click fx and choose ?Convert Formula To Text In Cell?.

Tap a chart, then tap Edit References. Do any of the following: Remove a data series: Tap the dot for the row or column you want to delete, then tap Delete Series. Add an entire row or column as a data series: Tap the header cell for the row or column.

Create a custom number format Select the cells you want to format. In the Format sidebar, click the Cell tab. Click the Data Format pop-up menu, then choose Create Custom Format. Type a name for your format, then click the Type pop-up menu and choose Number. Do any of the following to specify the format:

Replace formulas with their calculated values Select the cell or range of cells that contains the formulas. If the formula is an array formula, select the range that contains the array formula. ... Click Copy . Click Paste . Click the arrow next to Paste Options. , and then click Values Only.

Delete a formula but keep the results Select the cell or range of cells that contains the formula. Click Home > Copy (or press Ctrl + C). Click Home > arrow below Paste > Paste Values.