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.

Cut

  • 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".

Select Cell to Cut

Select Cut

Copy

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 Cell to Copy

Select Copy

Paste

  • 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".

Select Cell to Copy

Select Copy

Select Destination to Paste

Text is Pasted

Text is Pasted

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.

select Single Cell

Click Slect Insert

Select Table Column to Left

Column Inserted 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.

select Single Cell

Click Select Insert

Select Table Column to Right

Rows above

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.

Delete Rows

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.

Delete column

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.

computer_concepts_spread_sheet.htm
Advertisements