quick replace, sort, change columns

[userman]

hello!



I am searching how to do these in EXCEL:

1) select cells and then replace the text of each selected cell with *something*, with one click
2) set as default to always "expand selection" and select "no header row", before sorting, and select all cells with data before sorting
3) drag and drop columns to change their position (eg, drag and drop column A, between column B and column C, so that it will become column B)

any idea?

thanks!

[dazwm]

Have you considered using the macro recorder?