Microsoft Excel 2007 tutorial: copy, cut, and delete the cell contents


Copy, cut, and delete the cell contents

XXVII. Copy, cut, delete and the cell contents

In Microsoft Office Excel, you can copy, cut, and delete the contents of a cell or the contents of cells. For example, you want to copy or cut only two words from the phrase "World best learning center" that contained in a cell to another cell on another worksheet, or you intent to remove three words from this phrase.

Note: When you copy or cut a cell or range of cells, Excel displays an animated moving border around the cells. You can remove this border by pressing Esc.

XXVII.1. Copy or cut the contents of a cell

When you copy data in a cell, it means that you need to use this data again at anywhere on a worksheet or another worksheet or workbook. If you cut the data, you want to remove it from the old place to the new one. To copy or cut the data in a cell, do the following:

- Double-click the cell which you want to copy or cut the contents

- Select the contents in a cell that you want to copy or cut

- Right-click the selected text, and then click Copy or Cut on the shortcut menu.

Excel 2007 copy or cut text

Or on the Home tab, in the Clipboard group, click Copy or Cut  commands.

Excel 2007 Cut and Copy commands

Or you can use keyboard shortcut by pressing Ctrl +C or Ctrl +X.

- Click the cell that you want to paste, and then right-click it.

- Click Paste on the shortcut menu. Or click Paste in the Clipboard group, or press Ctrl +V.

XXVII.2. Copy or cut the contents of cells

When you copy or cut data in the whole cell, Excel copies the entire cell with values, cell formats, and comments, or moves the entire cell including the formulas and their resulting values, cell formats, and comments.

- Select the cells that you want to copy or cut, and then right-click it.

- Click Copy or Cut on the shortcut menu.

Or on the Home tab, in the Clipboard group, click Copy or Cut  commands.

Or using keyboard shortcut by pressing Ctrl +C or Ctrl +X.

- Click the cell which you want to paste, and then right-click it.

- Click Paste on the shortcut menu, or click Paste in the Clipboard group, or press Ctrl +V.

XXVII.3. Copy or move the cell contents by using the mouse

Excel allows to use drag and drop editing on a worksheet, so you can use the mouse to copy or move the contents of cell.

+ Copy the cell contents

- Click the cell that you want to copy.

- Point to the border of the selected cell. When the pointer become a move pointer Excel 2007 a move pointer, drag the cell to another location.

+ Move the cell contents

- Click the cell that you want to move.

- Hold down Ctrl while you point to the border of the selected cell. When the pointer become a copy pointer Excel 2007 a copy pointer, drag the cell to another location.

Note: If you want to copy or move a range of cells, follow the steps of copying or moving the cell contents above.

XXVII.4. Delete the contents of a cell

When the contents of a cell are miss spelling or you want to change the information in the cell, you actually want to delete them.

- Double-click the cell which you want to delete its contents.

- Do one of the following:

   1. If you want to delete one character to the right, press Delete key.

   2. If you want to delete one character to the left, press Backspace.

   3. If you want to delete more than one character, select the multiple characters that you want to delete, and then press Delete or Backspace

XXVII.4. Delete the contents of cells

- Select the cells or range of cells that you want to delete their contents.

- Press Delete key, or right-click the selected cells, and then click Clear Contents on the shortcut menu.

Excel 2007 Clear Contents

 


Comments





This website intents to provide free and high quality tutorials, examples, exercises and solutions, questions and answers of programming and scripting languages:
C, C++, C#, Java, VB.NET, Python, VBA,PHP & Mysql, SQL, JSP, ASP.NET,HTML, CSS, JQuery, JavaScript and other applications such as MS Excel, MS Access, and MS Word. However, we don't guarantee all things of the web are accurate. If you find any error, please report it then we will take actions to correct it as soon as possible.