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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |