Moving your Data

Dragging and Dropping Cells

1. Select the cells or range of cells that you want to move or copy.
2. Do one of the following: 

• To move a cell or range of cells, point to the border of the selection. When the pointer becomes a move pointer, drag the cell or range of cells to another location. 
• To copy a cell or range of cells, hold down Ctrl while you point to the border of the selection. When the pointer becomes a copy pointer, drag the cell or range of cells to another location.

Note: Excel replaces existing data in the paste area when you move cells. 

How to Cut, Copy, and Paste Cells

1. Select the cell that you want to move or copy. 
2. On the Home tab, in the Clipboard group, click Cut and Copy.
   
3. Select the upper-left cell of the paste area.
4. On the Home tab, in the Clipboard group, click Paste.

• If you click the arrow below Paste, you can choose from several paste options to apply to your selection.

Excel pastes the cut or copied data into consecutive rows or columns. If the paste area contains hidden rows or columns, you might have to unhide the paste area to see all of the copied cells.

When you copy or paste hidden or filtered data to another application or another instance of Excel, only visible cells are copied.

Tip: To move or copy a selection to a different worksheet or workbook, click another worksheet tab or switch to another workbook, and then select the upper-left cell of the paste area. 

How to Cut, Copy, and Paste Multiple Cells

1. Select the cells that you want to move or copy.
2. Select the upper-left cell of the paste area. 
3. On the Home tab, in the Clipboard group, click Paste.

Using Paste Special

You can use the Paste Special dialog box to copy complex items from a program other than Excel and paste those items into an Excel worksheet.

• Source -Displays the name of the source data and its location. If you copied the data from a program that did not provide the source data and its location to the Clipboard, the source is identified as "Unknown." 
• Paste - Inserts or embeds the Clipboard contents at the insertion point in the format specified in the As box. When you select this option, the Clipboard contents are pasted or embedded as an object, but no link is created. If the data is embedded as an object, the source program is started when you double-click the worksheet data, and you then use the source program to edit the data. 
• Paste link- Creates a link from the pasted data to its source file. When you select this option, changes that are made to the source file will be reflected in the worksheet.  
• As Specifies - the type of data that you want to paste from the Clipboard. 
• Display as an icon - Displays the Clipboard contents as an icon in the worksheet. When you select this check box, an icon appears in the destination area that you can click to see the embedded or linked data. Use this option if you do not want the embedded or linked data to be displayed in the worksheet. 
• Result- Describes the effects of the options that you select.

Inserting and Deleting Cells, Rows, and Columns

Inserting Rows into a Worksheet

Do one of the following;  

1. To insert a single row, select either the whole row or a cell in the row above which you want to insert the new row. For example, to insert a new row above row 5, click a cell in row 5. 
2. To insert multiple rows, select the rows above which you want to insert rows. 
3. Select the same number of rows as you want to insert. For example, to insert three new rows, you select three rows. 
4. To insert non-adjacent rows, hold down Ctrl while you select nonadjacent rows. 

Do one of the following:

1. Right-click the selected cells and then click Insert.
2. On the Home tab, in the Cells group, click the arrow under Insert, and then click Insert Sheet Rows.
   

Note: When you insert cells on a worksheet, the references adjust accordingly, whether they are relative or absolute cell references. The same behavior applies to delete cells, except when a deleted cell is directly referenced by a formula. If you want references to adjust automatically, it's a good idea to use range references when you can in your formulas, instead of specifying individual cells. 

Inserting Columns into a Worksheet

Do one of the following:

• To insert a single column, select the column or a cell in the column immediately to the right of where you want to insert the new column. For example, to insert a new column to the left of column B, click a cell in column B. 
• To insert multiple columns, select the columns immediately to the right of where you want to insert columns. 
• Select the same number of columns as you want to insert. For example, to insert three new columns, you select three columns.
• To insert nonadjacent columns, hold down Ctrl while you select nonadjacent columns. 

Do one of the following:

• Right-click the selected cells and then click Insert.
• On the Home tab, in the Cells group, click the arrow under Insert, and then click Insert Sheet Columns.
  

Deleting Rows within a Worksheet

1. Select the rows that you want to delete. 
2. On the Home tab, in the Cells group, click the arrow next to Delete, and then click Delete Sheet Columns. 

Note: You can right-click a selection of cells, click Delete, and then click the option that you want. You can also right-click a selection of rows or columns and then click Delete. 

Deleting Columns within a Worksheet

1. Select the rows that you want to delete.
2. On the Home tab, in the Cells group, click the arrow next to Delete, and then click Delete Sheet Columns. 

Note: You can right-click a selection of cells, click Delete, and then click the option that you want. You can also right-click a selection of rows or columns and then click Delete. 

Using Undo, Redo, and Repeat

You can undo, redo, or repeat many actions in Microsoft Word, PowerPoint, and Excel. You can undo saves, even after you have saved, and then save again, as long as you are within the undo limits. 

Undo an action

• To Undo you must press Ctrl + Z until you've fixed the mistake. 
• Or press Alt + Backspace to do the same thing. 
• If you prefer your mouse, click Undo on the Quick Access Toolbar. 
   
• You can't undo some actions, such as clicking commands on the File tab or saving a file. If you can't undo an action, the Undo command changes to Can't Undo. 
• To undo several actions at the same time, click the arrow next to Undo, select the actions in the list that you want to undo, and then click the list.

Redo an action

• To redo something you've undone, press Ctrl+Y or F4. (If F4 doesn't seem to work, press the F-Lock key, then F4). 
• Or click Redo on the Quick Access toolbar. (The Redo button only appears after you've undone an action.)

Repeat an action

• To repeat something simple, such as a paste operation, press Ctrl+Y or F4 (If F4 doesn't seem to work, press the F-Lock key, then F4).

Notes:

• By default, the Repeat command is not available on the Quick Access Toolbar in Excel. If you want to repeat the last action, you need to add the Repeat command to the Quick Access Toolbar first. 
• Some actions, such as using a function in a cell in Excel, can’t be repeated. If you can't repeat the last action, the Repeat command changes to Can't Repeat.