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...
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.
pratimabeli , Both techniques Riny_van_Eekelen mentioned work for me without any issue.
Still no success. I would be happy to have workbook where you could perform the requisite action. Further as mentioned you in the email I got, did not find any video showing them in action.
Alo for me the sheet works without problems ... for safety I have unlocked all cells ... maybe the problem comes from there.
Enclosed the file with the unlocked cells and the path to it.
Path: Select cell or area.
Right mousekey
Format cells
protection
Remove the locked hook
OKI would be happy to find out if I could help.
Nikolino
I know I don't know anything (Socrates)
