Microsoft Excel 2007 - Manipulating Data

Add to Favourites
Post to:

Excel allows you to move, copy, and paste cells and cell content through cutting and pasting and copying and pasting.Select DataTo select a cell or data to be copied or cut:Click the cellClick and drag the cursor to select many cells in a rangeSelect a Row or ColumnTo select a row or column click on the row or column header.Copy and PasteTo copy and paste data:Select the cell(s) that you wish to copyOn the Clipboard group of the Home tab, click CopySelect the cell(s) where you would like to copy the dataOn the Clipboard group of the Home tab, click PasteCut and PasteTo cut and paste data:Select the cell(s) that you wish to copyOn the Clipboard group of the Home tab, click CutSelect the cell(s) where you would like to copy the dataOn the Clipboard group of the Home tab, click PasteUndo and RedoTo undo or redo your most recent actions:On the Quick Access ToolbarClick Undo or RedoAuto FillThe 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 HandleDrag the Fill Handle to complete the cells

Description
Microsoft Excel 2007 has a completely redesigned user interface. The standard menus along the top have been removed and replaced with a series of toolbars Microsoft calls “The Ribbon.” These tool bars are changed using tabs at the top and try to automatically adjust themselves to the content you are working with. If you select an image it will automatically switch to the picture tools. The new layout seems to offer easier access to most of the features of Excel allowing for more complex documents to be created quicker.

Comments

Want to learn?

Sign up and browse through relevant courses.

Name:
Your Email:
Password:
Country:
Contact no:


Area code Number
Subjects you are interested in:
Word verification: (Enter the text as in image)


Sign Up Already a member? Sign In
I agree to WizIQ's User Agreement & Privacy Policy
1 Member Recommends
14 Followers

Your Facebook Friends on WizIQ

Give live classes, create & sell online courses

Try it free Plans & Pricing

Connect