If you copy a range of cells that include hidden data (either hidden or filtered), the hidden data is also copied. A new table is created with the pasted cells. Paste outside of an existing table to create a new table: Drag the cells outside the table. The pasted cells adopt the formatting of the new location. Paste cell contents without the style: Choose Edit >В Copy, select the cells where you want to paste, then choose Edit > Paste and Match Style. Paste a cell style: Choose Format >В CopyВ Style (from the Format menu at the top of your screen), select the cells where you want to paste the style, then choose Format > Paste Style. New rows or columns are added for the copied cells. Paste without overwriting: Choose Edit >В Copy, select the destination cells, then choose Insert > Copied Rows or Insert > Copied Columns (from the Insert menu at the top of your screen). If your data range contains formulas but you want to paste only the results, choose Paste Formula Results. Select the top-left cell where you want to paste the data (or select an area of the same dimensions as the cells youвЂ™re pasting), then choose Edit >В Paste. Paste and overwrite existing content: Choose Edit >В Copy (from the Edit menu at the top of your screen). Existing data is replaced by the new data. Move the data: After selecting the cells, click and hold the cells until they appear to rise off the table, then drag them to another location in the table. Select the cells you want to copy or move. When you copy a cell, or move a cellвЂ™s data to a new location in the table, the cellвЂ™s properties are also copied or moved, including its data format, fill, border, and comments.

Restore an earlier version of a spreadsheet.

Save a large spreadsheet as a package file.

Place objects inside a text box or shape.

Format Chinese, Japanese, or Korean text.

Use a keyboard shortcut to apply a style.

Create, rename, or delete paragraph styles.

Bold, italic, underline, and strikethrough.

Format a spreadsheet for another language.

Select text and place the insertion point.

Add a legend, gridlines, and other markings.

Add column, bar, line, area, pie, donut, and radar charts.

Calculate values using data in table cells.

Quickly calculate a sum, average, and more.

View the source data for a pivot table value.

Change how pivot table data is sorted, grouped, and more.

Add calculations to summarize group data.

Add checkboxes and other controls to cells.

Use VoiceOver to create formulas and autofill cells.Intro to images, charts, and other objects.

How to delete an underline in excel