Multi Copy Paste Serial Number
The other day, a friend of mine asked me an interesting question. He had a Microsoft Word document which contained a long numbered. And he wanted the same list in reversed order. That is, the last item in the list should become the first, second-last should become second and so and so forth. Something like this:. Apple.
Grapes. Peach. FigShould get reversed like. Fig. Peach.
Grapes. AppleThis can easily be done using a VB Script executed on the MS-Word document. But my friend is not a computer programmer –so I did not want to give him such a nerdy suggestion. Therefore, I thought a bit and came up with another neat solution that can also be used by not-so-tech-savvy folks. Here is how you can reverse huge lists in MS-Word. Home tab Sort buttonClick OK button.You will see that the list has reversed! But it is now in a tabular form.
To convert it back into a numbered list, select the table content and copy them.Paste the copied content again in NotepadCopy this content from Notepad and now paste back into MS-Word document.Select the newly pasted reversed list in MS-Word and click on the button that creates numbered list.Selected text will get converted into a numbered list – manually correct numbering should there be any minor problems.Mission accomplished! How does List Reversal Work?Notepad is at the heart of this trick.
Notepad is a simple plain text editor which does not permit any kind of fancy formatting. If you copy formatted text from MS-Word into Notepad -Notepad removes all the formatting and try to present the text in a way as plain as possible.In this case, Notepad converts list numbering into tab character. When we copy text from Notepad and paste in MS-Word to convert it into a table; MS-Word separates list numbers and items on the basis of tab character inserted by Notepad. Rest all is easy enough to understand, I guess! If not, please let me know in comments.READ ALSO:I hope that this trick will save you some time.
Please feel free to ask if you have any questions about this topic. Thank you for using TechWelkin! Another options is to copy the list into Excel, Column B. In Column A1, start to add the highest number of data you want sorted (tip: highlight the column and look at the bottom bar to see the count of rows).
In A2, add the second to highest number, in A3 add third to highest number. (For this example, A1 would have 200, A2 would have 199 and A3 would have 198). Now select A1, A2, and A3 and utilize bottom corner to drag the selection to the last row.
Excel will automatically insert a decreasing number based on the pattern entered into A1 – A3 cells. After completion the drag, use the Sort functionality to sort from smallest to largest sort. Copy/Paste back to document.
Multi Copy Paste Serial Number
So when I want to extend a series or something along those lines, I can highlight a group of cells, then click on the bottom right corner of the highlighting box and drag down. Excel will then attempt to automatically extend the contents as well as it can. Is there a keyboard function that will allow me to do this?
Multi Copy Paste Serial Number Search
I like to use the keyboard to avoid repetitive mouse motions.I can use the shift key and arrow keys to make a selection, but I don't know what (if any) key can trigger this function.I also don't really know what this function is actually called. You can also accomplish this with a macro. Go to View tab - Macro - 'Record Macro'.
Choose an optional name, for example Myautofill (no space in name!). Choose an optional shortcut, for example Ctrl+ H. Click OK to start recording the macro.
Go to Home tab - Editing - Fill - Series. For 'Series in' choose 'Columns', check the 'Trend' option, then click OK.
Go to View tab - Macro - 'Stop Recording'. Your macro is ready! Select a range of cells and hit the shortcut you chose in step 3. For Excel 2016 (and I presume 2013), I added it to the Quick Access Toolbar (I got rid of the Save button because CTRL-S does that), and I replaced it with Fill Series. Go to the Home ribbon. In the Editing group, click on 'Fill'. Right-click on 'Series'.
Select 'Add to Quick Access Toolbar'Now it should appear in the top left of the window. When you press ALT, a number should appear next to the new icon you've added. You can then customise the Quick Access Toolbar and put the 'Fill' option where you want.I got rid of 'Save' and put 'Fill' there instead, so I can now enter the first two values (e.g. '1' in cell A1 and '2' in cell A2), then select those two and more cells below, and hit ALT, 1, and Enter.
The selected cells should then be filled with the series. The mouse is no longer required for this task.