You can use cutpaste in Excel to relocate functions, formulas, charts, and other data.

When working with large amounts of data in Excel, you might find the need to copy and paste something that youve already written, or perhaps wholly move a selection.

Whether you are working with data within a single worksheet, multiple worksheets, or even various workbooks, there are easy shortcuts you can use the cut, copy, and paste.

Copying data in Excel is convenient when you need to duplicate functions, formulas, charts, and other data.

The new location can be on the same or different worksheet or even in a completely different workbook.

As in all Microsoft programs, there is more than one way of accomplishing a task.

When the copy command is activated, the clipboard temporarily stores a duplicate of the selected data until you paste it into the destination cell or cells.

Other methods of copying data that dont involve using the clipboard include using the fill handle and drag and drop with the mouse.

The easiest way to cut, copy, and paste, arguably, is with keyboard shortcuts.

The keyboard key combinations for copying and pasting data are.

Ctrl C activates the copy command Ctrl V activates the paste command.

Click the destination cell when copying multiple cells of data, click the cell in the top left corner of the destination range.

To select multiple non-adjacent cells with the arrow keys, use the Ctrl key.

While the options available in the context menu, or right-click menu, usually change depending upon the object selected, the cut, copy and paste commands are always available.

Right-click on the selected cell(s) to open the context menu.

Click on the destination cell when copying multiple cells of data, click on the cell in the top left corner of the destination range.

The copy and paste commands are in the Clipboard section on the left-hand side of the Home tab of the ribbon.

To move data, you need to cut and paste it from one location to the new one.

Excel For Mac 2016 Data Won'T Paste Into Cells