- Computer Concepts Tutorial
- Computer Concepts - Home
- Introduction to Computer
- Introduction to GUI based OS
- Elements of Word Processing
- Spread Sheet
- Introduction to Internet, WWW, Browsers
- Communication & Collaboration
- Application of Presentations
- Application of Digital Financial Services
- Computer Concepts Resources
- Computer Concepts - Quick Guide
- Computer Concepts - Useful Resources
- Computer Concepts - Discussion
Computer Concepts - Editing Worksheet Data
Modifying or adding text or using cut, copy, paste operations to an existing document is known as editing.
To edit data in a worksheet, first open the worksheet by clicking on File → Open.
Next, move cursor to the cell, which you want to edit.
Note that content of the cell is displayed in formula bar as well.
As you perform any operation, it is visible in the formula bar.
Deleting unnecessary data from the cell is called cutting.
In Microsoft Excel, you can cut text from one area of a worksheet and save or paste that text anywhere. When you cut the text, it is stored on clipboard.
If you want to cut any text or content from worksheet, first select the text or content which you want to cut.
To cut, Right Click → Cut.
The shortcut key is "Ctrl + X".
Instead of retyping the same text, Copy function is used which reduces time and effort. By using copy option, you can copy the text from one location to another. Information stored on clipboard stays there until new information is either cut or copied. When you execute cut or copy, you replace old information on the clipboard with whatever you have just cut or copied.
To copy the content, Right Click → Copy.
Shortcut key is "Ctrl + C".
Select your text to highlight it.
First copy the text.
Use mouse to move the cursor to desired position to paste the copied text.
Click paste to insert the copied text in its new place.
You can paste clipboard information as often as you like.
To paste, Right Click & Paste.
Shortcut key is "Ctrl + V".
Inserting and Deleting Rows, and Column
To insert and delete rows and columns in an existing table, position the cursor either before/after/above the spot where you want the insertion/deletion to be.
Right Click → Insert/Delete.
Insert column to the left
After finishing our table, in case we want to insert a column on the left hand side of a particular column. We may use the following steps.
Place the cursor where you want to insert a column in the table.
Right click → Insert column to left.
Insert column to the right
After finishing our table, in case, we want to insert a column on the right hand side of a particular column, follow below steps −
Place the cursor where you want to insert a column into the table.
Right click → Insert column to right.
After finishing the table, in case we want to insert a row on top of a particular row, follow below steps −
Place cursor where you want to insert a row into the table.
Right click → Insert row above.
If you want to delete particular rows in a table, use the following steps −
Select cells or rows you want to delete.
Right click → Delete → Table Rows.
If you want to delete a particular column in a table, use the following steps −
Select column or cells you want to delete.
Right click → Delete → Table Columns.
Changing Cell Height and Width
When we create a table, all the columns may have equal column width or different widths. If you want to change the row height, simply select the row and right click. Then select the Row Height option.
Kickstart Your Career
Get certified by completing the courseGet Started