Notepad++ Multi editing

Question

How can i have multiple cursors in Notepad++?? Basically i will have couple of values tab delimited. I need to write query for all of these values. For example, if i get an excel file with values like this

1234 xyz pqr
2345 sdf kkk
...

I want to copy this whole data into Notepad++ and write query at once to insert all these values, like

Insert into tbl (1234, xyz) where clm = 'pqr'
Insert into tbl (2345, sdf) where clm = 'kkk'
...

I used to do it at my old place using Ultredit. Can this be done using Notepad++??

Answer 1

You can use Edit > Column Editor... to insert text at the current and following lines. The shortcut is Alt + C.

Answer 2

Go to Settings > Preferences..., and in the Editing tab, turn on multi-editing. Then you can press and hold the Ctrl and Alt keys, click and drag to select the lines whose columns you wish to edit, and begin typing.

It's much more intuitive, as you can see your edits live as you type.