Select Page

How to move data copy:

There are several ways to copy data. Uses the menu bar’s command options or toolbar icons Selected copies can be copied or moved.

  1. It must be selected to copy and move data. Click on Home and click on Copy command.
  1. Or press Ctrl + C to be the keyboard.
  2. There will be a cursor on the cell that will have to move the gap.
  3. Click the icon on the top. Or, press Ctrl + V to enter the keyboard.

Cut the data cut into the cut

  1. Choose which data cut and move need to be selected.
  2. Home click and then click on Cut command.

 Image Cut Data Cut and Move Home Cut Option ‘Select.

 Or, press Ctrl + X to enter the keyboard.

  1. Now click on the cursor in the cell to enter the data.
  2. Click the Pattern icon. Or, press Ctrl + V to enter the keyboard.

The difference between the cut and copy

Cut

Copy

  1. Due to the cut of data in the document corner, the data is transferred to the place where it is moved and moved to where it is pasted.
  1. Due to copying data in the document, copying data Moves to the specific place, but the data of the same is transferred to the place where it is pasted.

The difference between the cut and copy

Cut

Copy

  1. Due to the cut of data in the document corner, the data is transferred to the place where it is moved and moved to where it is pasted.
  1. Due to copying data in the document, copying data Moves to the specific place, but the data of the same is transferred to the place where it is pasted.

Cell, Row and Column Insert

Extra Row, Column or Cell can be removed or deleted at the corner of Excel’s Sheet. It is to be remembered that in a data table, the database is stored in a database of thousands of documents and 5 writing in Meherpur was incorrectly addressed in the Address Room of the row data in Column. And this is the reason for this mistake All of the following home addresses were wrong. Because the number 6 will be Meherpur in the queue and at 6 numbers that are written in 7 numbers. In this case, if no data is deleted, the row number 5 can be moved to 6, and 6 numbers can be moved to number 7, but the database can be corrected by just one command. This problem can be solved by inserting a new cell.

 Click on the office button and open the Rup1 file created with the Open command and click on Sheet You have to make or create a file in the form of a database of Rup1 files.

Insert unwanted cell

  1. C5 cells will be selected.
  2. From the menu select Home Ribbon, from the Cells command group, click on the Insert button Insert Cells … command.

Insert dialog box will appear. Shift cells right and Shift cells down are displayed.

  1. Shift calls down The radio button will be selected.
  2. Then have to OK OK. The C5 cell will be empty and the data will be dropped down one cell.

Shift calls right Select the radio button and move the data from one cell right to the right. Multiple Cells If selected, that number is the same as for the cell.

 

Insert the blank column.

  1. Select the cell to which the cell should be selected.
  2. From the menu select Home Rihon, from the Cells command group, click on the Insert button Insert Sheet The Columns command must be filled in. Select the Columns radio button and Ok, have to. A new column will be created and the data in the other column will be moved from one column to the right.

If multiple columns or columns are selected, then multiple new columns are created and the data is created The number of columns moved right.

 Insert the blank row

1.Crear the pointer to the cell 5 or select the row number 5 (Row).

  1. When you select Home Ribbon from the menu, click on the Insert button from the Cells command group Inter-Sheet Row command to take. A new blank row will come up and the data will go down a bit.

 If there were multiple row or row cells selected, then more than one new row was found and accordingly the data Would have gone

New Sheet Insert

Although Excel has a workbook of Sheet1, Sheet2 Sheet3 generally. In this situation, new Can be brought to worksheet if needed.

  1. Select Sheet3 from the bottom of the file and select it.
  2. From the menu, select the Home Ribbon; Insert from the command group Insert option Let’s take the sheet command. A new Sheet name can be found.