View Single Post
 
Old 04-18-2012, 11:43 AM
userman userman is offline Windows XP Office 2003
Advanced Beginner
 
Join Date: Sep 2010
Posts: 52
userman is on a distinguished road
Default quick replace, sort, change columns

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!
Reply With Quote