Forum Discussion
how to insert a row at another place which I had cut
pratimabeli , it was just the file you uploaded. Here's the video of the drag and drop holding the shift key down...
pratimabeli If it is just cutting one row and pasting it above another is what you need, thus no other logic that could be solved by, e.g. sorting in a table, try the following:
Select row 10 and right-click. Select "Cut" from the pop-up menu.
Now select row 4 and right-click. Select "Insert cur Cells"
This will then have cut out the content of the original row 10 and placed it above the original row 4.
The same result can be achieved by drag-and-drop. Select row 10 and aim the mouse pointer over its edge until you see a four-arrow-headed plus sign. Press and hold Shift, click, drag and drop the row into its required destination.
Riny_van_Eekelen . Thank you very much for this . But the point is that when I select the row number 10 and right click, the "Cut" option from pop up menu is shown grayed out.
Even when I select row 10 and use Control "X" and then select row 4 and right click, even the "Insert Cut Cell" option is again shown grayed out here also.
With the help of technical person from Microsoft helpline, I have checked all the settings, even repaired the MS office but still problem is persisting.
pratimabeli There are a number of reasons that it could be grayed out, which you may have already checked. Is the sheet or workbook protected, are there merged cells, is there an object, ... It would be best if you could share the workbook for us to see. Another thought is can you select row 4 and 'insert row'? that would be helpful info to know also and if you can then can you select some cells and copy/cut and paste?
mtarler Thanks for the response. Please note that neither the sheet nor the work book is protected. None of the cells is merged nor any object is there. I have removed all such things i.e passwords, merger of cells etc.
I have tried to selected row 4, right click but again the insert option in popup menu is grayed out.
Similarly if I select a single cell, right click, only copy option is available which I can select and paste the value any where. But here again the "Cut" option is grayed out.
As requested, I have attached the workbook here for your views.
