Home | | Computer Technology 11th std | Copy, Cut and Paste - Spreadsheet

Spreadsheet-Basics (OpenOffice Calc) - Copy, Cut and Paste - Spreadsheet | 11th Computer Science : Chapter 7 : Spreadsheet-Basics (OpenOffice Calc)

Chapter: 11th Computer Science : Chapter 7 : Spreadsheet-Basics (OpenOffice Calc)

Copy, Cut and Paste - Spreadsheet

Select the cell or cells you want to copy

Copy, Cut and Paste

 

1. Copy and paste Data

 

·        Select the cell or cells you want to copy

 

·        Select Edit -> Copy or ClickCopy” icon from the standard toolbar or Press Ctrl + C


·        Move the cell pointer to the cell in which you want to paste.

 

·        Select Edit -> Paste or ClickPaste” icon or Press Ctrl + V

 

2. Cut and Paste Data

 

·        Select the cell or cells you want to cut

 

·        Select Edit -> Cut or ClickCut” icon from the standard toolbar or Press Ctrl + X

 

·        Move the cell pointer to the cell in which you want to paste.

 

·        Select Edit -> Paste or Click “Paste” icon or Press Ctrl + V

 

3. Copy and Paste Formula

 

·        The process of Copy and Paste data is used for copying formula.

 

·        When you copy a formula from one cell to another cell, the address of the pasted formula will change according to its row. This is called “Relative Cell Reference” (Refer Figure 7.27).

 

Example:


 

4. Copy a formula from one cell and paste it in multiple cells:


 

Step 1: Copy the formula from H2 using Ctrl + C or Edit -> Copy (or) click Copy” icon.



 

Step 2: Select all cells (i.e. H3 to H11) in which you want to paste this addition formula.

 

Step 3: Paste the copied formula using Ctrl + V or Edit -> Paste (or) Click “Paste” icon.

 

Tags : Spreadsheet-Basics (OpenOffice Calc) , 11th Computer Science : Chapter 7 : Spreadsheet-Basics (OpenOffice Calc)
Study Material, Lecturing Notes, Assignment, Reference, Wiki description explanation, brief detail
11th Computer Science : Chapter 7 : Spreadsheet-Basics (OpenOffice Calc) : Copy, Cut and Paste - Spreadsheet | Spreadsheet-Basics (OpenOffice Calc)


Privacy Policy, Terms and Conditions, DMCA Policy and Compliant

Copyright © 2018-2023 BrainKart.com; All Rights Reserved. Developed by Therithal info, Chennai.