Headlines
Published On:Friday 6 January 2012
Posted by Muhammad Atif Saeed

Manuplating the Data in Microsoft Excel

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

About the Author

Posted by Muhammad Atif Saeed on 16:54. Filed under . You can follow any responses to this entry through the RSS 2.0. Feel free to leave a response

By Muhammad Atif Saeed on 16:54. Filed under . Follow any responses to the RSS 2.0. Leave a response

0 comments for "Manuplating the Data in Microsoft Excel"

Leave a reply

Visit Counters

About Me

My photo
I am doing ACMA from Institute of Cost and Management Accountants Pakistan (Islamabad). Computer and Accounting are my favorite subjects contact Information: +923347787272 atifsaeedicmap@gmail.com atifsaeed_icmap@hotmail.com

    Online Visitors:

    Blog Archive

x

Welcome to eStudy.Pk....Get Our Latest Posts Via Email - It's Free

Enter your email address:

Delivered by FeedBurner