Forum Discussion
how to insert a row at another place which I had cut
In order to move a particular row say row number 10, above the row number 4, need to cut the row number 10 and insert it above the row number 4, what should I do or which functionality of excel will help me to perform this function
pratimabeli , it was just the file you uploaded. Here's the video of the drag and drop holding the shift key down...
10 Replies
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?
Assuming your rows are arranged in an orderly fashion, preferably as a Table (column headings, consistent types of data in each column, etc), it should be fairly easy to use Data....Sort. If there's no column specifically attuned to your exact desired order--you don't say WHY you might want what's now in row 10 to be moved to row 4--you could always add another column with numbers in them, from 1 to 10 (or whatever) and make sure that the one you want in row 4 carries the number 4.
If none of that makes sense, perhaps you could post a copy (devoid of any personal or private information) so it could be demonstrated with your actual spreadsheet.
