MS Excel 2007 - Lesson 4: Working with data

TipsMake.com - Excel allows you to move, copy and paste cells and content boxes through cut and paste or copy and paste .

Select data in Excel 2007 table

To select a cell or data area to copy or cut:

• Click on the box

MS Excel 2007 - Lesson 4: Working with data Picture 1

• Click and drag the cursor to select multiple cells in an area

MS Excel 2007 - Lesson 4: Working with data Picture 2

Select a row or column in Excel:

To select a row or column, click at the beginning of each row or column.

MS Excel 2007 - Lesson 4: Working with data Picture 3

Copy and Paste data in Excel 2007

To copy and paste data:

• Select the cell you want to copy

• On the Clipboard group of the Home tab, click Copy (or press the Excel Ctrl + C shortcut combination)

MS Excel 2007 - Lesson 4: Working with data Picture 4

• Select the cell where you want to paste data into it.

• On the Clipboard group of the Home tab, click Paste (or press Ctrl + V ).

MS Excel 2007 - Lesson 4: Working with data Picture 5

Cut and Paste data in Excel 2007

To cut and paste data:

• Select the cell you want to cut

• On the Clipboard group of the Home tab, click Cut (or press Ctrl + X ).

MS Excel 2007 - Lesson 4: Working with data Picture 6

• Select the cell where you want the data to be pasted

• On the Clipboard group of the Home tab, click Paste

Undo and Redo features in Excel 2007

To Undo or Redo the actions you have just taken:

• On the Quick Access Toolbar

• Click Undo ( Ctrl + Z ) or Redo ( Ctrl + Y )

MS Excel 2007 - Lesson 4: Working with data Picture 7

The auto-fill feature of Excel 2007

Auto Fill feature helps you automatically fill data into cells or data series into a worksheet into a selected area. If you want the same data to be copied into different cells, you only need to complete a box or if you want to have a data series (like, days of the week) fill in the first 2 cells in the series and then It uses Auto Fill feature.

To use Auto Fill feature:

• Click Fill Handle (control hook in the lower right corner of the box)

• Drag the Fill Handle to automatically fill in the cells.

MS Excel 2007 - Lesson 4: Working with data Picture 8

Next lesson: MS Excel 2007 - Lesson 5: Edit Worksheet

Previous article: MS Excel 2007 - Lesson 3: Working with Workbook