Change Language:

Features of Microsoft Excel Part 2

3. Editing Workbook

The process of making changes in the workbook is called Editing. It is the most important feature of Microsoft Excel. Mostly the editing activities are performed on the selected data of cells by selecting commands from the Edit menu or using icons on the toolbar. Some features of editing are explained below.

i) Copy / Move & Paste

In Excel, you can also copy or move data from one location of worksheet to another location or to another worksheet of different workbook or even to another application program. The data is copied or moved through clipboard. From clipboard, it can be pasted anywhere into the worksheet or any other application program.

The commands that are used for this purpose are:

Copy - This command is used to copy the selected data to clipboard.

Cut - It is used to move the selected data to the clipboard.

Paste - It is used to paste (insert) the text or item from the clipboard into the specified location of worksheet

ii) Deleting in Excel

You can delete the data of a cell or range of dells and the cells as well. Similarly, the rows or columns or entire worksheet can be deleted from the workbook.

iii) Inserting in Excel

You can insert new rows, columns, cells and worksheets in Excel. When new row is inserted the contents of the worksheet are moved one row downward. Similarly, when new column is inserted, the contents of the worksheet are moved one column rightward. In case of cells, when a new cell is inserted, the existing cells move in the direction you specify to make room for the new cell.

iv) Undoing & Redoing in Excel

Like other Windows applications, Excel also provides the facilities of Undo command to cancel the actions of different operations and Redo command to cancel the action of Undo command.

v) Finding & Replacing in Excel

You can also search data in worksheet as well as replace data with another one. Excel provides the similar commands as used in Microsoft Word. The procedure to apply these commands is also similar.

vi) Proofing the Excel Worksheet

You can also check the spelling of text entered into the worksheet cells and can correct the wrong spelling. Other features of this tool are same as mentioned in Microsoft Word.

v) Hiding / Un-hiding Rows & Columns

You can hide the rows and columns of the worksheet. The hidden rows and columns are not printed on the printer.

The hidden rows and columns can be un-hidden or displayed very easily for editing or printing data of their cells.

• [Microsoft Office] - Features of Microsoft Excel Part 3
• [Microsoft Office] - Features of Microsoft Excel Part 1
• [Microsoft Office] - Introduction to Microsoft Excel
• [Microsoft Office] - Microsoft Excel Common Used Functions
• [Microsoft Office] - Date related functions in Microsoft Excel
• [Microsoft Office] - How to use Pivot Table in Excel
• [Microsoft Office] - Components of Microsoft Excel Window
• [Microsoft Office] - How to convert documents in PDF file
• [Microsoft Office] - Protect excel and word document with password
• [Computer Software] - Types of Computer Software
• [Computer Hardware] - Un Common Computer Input Devices
• [Computer Software] - Computer Virus
• [Internet Tips] - Email Communication using Microsoft Outlook Express
• [Computer Software] - Introduction to Word Processing
• [General Computer] - Introduction to Programming Languages