harjotmann
 
  Home
  Contact
  MBA I
  => Exercise 1,2
  => Exercise 3
  => Grouping information
  => Assignment 3
  => Assesment1
  => Tutorial PowerPoint
  => MST performance
  => Assignment PP
  => excel
  => Excel tute I
  => Excel tute II
  => Excel Tute III
  => Excel Tute IV
  => Excel Tute V
  => Assignment Excel2007
  => Assignment Excel II
  => Important Notice
  MBA II
  Tutorial
  MBA III
  Downloads
  Assesment
  BCA V
Excel Tute III
 
« Working with a Workbook Data Modifying a Worksheet »

Excel allows you to move, copy, and paste cells and cell content through cutting and pasting and copying and pasting.

Select Data
To select a cell or data to be copied or cut:

  • Click the cell

Select Single Cell

  • Click and drag the cursor to select many cells in a range

Select Range of Cells

Select a Row or Column
To select a row or column click on the row or column header.

Select Row

Copy and Paste
To copy and paste data:

  • Select the cell(s) that you wish to copy
  • On the Clipboard group of the Home tab, click Copy

Copy Button

  • Select the cell(s) where you would like to copy the data
  • On the Clipboard group of the Home tab, click Paste

Paste Button

Cut and Paste
To cut and paste data:

  • Select the cell(s) that you wish to copy
  • On the Clipboard group of the Home tab, click Cut

Cut Button

  • Select the cell(s) where you would like to copy the data
  • On the Clipboard group of the Home tab, click Paste

Undo and Redo
To undo or redo your most recent actions:

  • On the Quick Access Toolbar
  • Click Undo or Redo

Undo Redo on Quick Access Toolbar

Auto Fill
The Auto Fill feature fills  cell data or series of data in a worksheet into a selected range of cells. If you want the same data copied into the other cells, you only need to complete one cell.  If you want to have a series of data (for example, days of the week) fill in the first two cells in the series and then use the auto fill feature. To use the Auto Fill feature:

  • Click the Fill Handle
  • Drag the Fill Handle to complete the cells

Fill Handle

 
 
   
Today, there have been 28 visitors (30 hits) on this page!
This website was created for free with Own-Free-Website.com. Would you also like to have your own website?
Sign up for free