Question

how can we change the portion of data in a cell using mouse in MS Excel?​

Answer 1

Press and hold the Shift key, and then drag the column to a new location. You will see a faint "I" bar along the entire length of the column and a box indicating where the new column will be moved. That's it! Release the mouse button, then leave the Shift key and find the column moved to a new position

Answer 2

Use Cut, Copy, and Paste to move or copy cell contents. Or copy specific contents or attributes from the cells. For example, copy the resulting value of a formula without copying the formula, or copy only the formula.

When you move or copy a cell, Excel moves or copies the cell, including formulas and their resulting values, cell formats, and comments.


You can move cells in Excel by drag and dropping or using the Cut and Paste commands.

Move cells by drag and dropping

Select the cells or range of cells that you want to move or copy.

Point to the border of the selection.

When the pointer becomes a move pointer move pointer , drag the cell or range of cells to another location.

Move cells by using Cut and Paste

Select a cell or a cell range.

Select Home > Cut Cut or press Ctrl + X.

Select a cell where you want to move the data.

Select Home > Paste Paste or press Ctrl + V.


Copy cells in your worksheet using the Copy and Paste commands.

Select the cell or range of cells.

Select Copy or press Ctrl + C.

Select Paste or press Ctrl + V.