Home | Blog | Software | Reviews and Features | Forum | Help | Donate | About us
topbanner_forum
  *

avatar image

Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
  • December 10, 2016, 08:47:11 AM
  • Proudly celebrating 10 years online.
  • Donate now to become a lifetime supporting member of the site and get a non-expiring license key for all of our programs.
  • donate

Author Topic: quick replace, sort, change columns in EXCEL  (Read 810 times)

kalos

  • Member
  • Joined in 2006
  • **
  • default avatar
  • Posts: 1,477
    • View Profile
    • Donate to Member
quick replace, sort, change columns in EXCEL
« on: April 18, 2012, 10:53:06 AM »
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!

kunkel321

  • Supporting Member
  • Joined in 2009
  • **
  • Posts: 464
    • View Profile
    • Donate to Member
Re: quick replace, sort, change columns in EXCEL
« Reply #1 on: April 18, 2012, 02:07:42 PM »
Other than the 'dragging' part, you're describing things that can be accomplished entirely via keyboard, and therefor could also be recorded as a macro....  Also, be sure to check out the (previously mentioned) ASAP Utilities.  It has some advanced selecting capabilities.  (though I don't know if the ASAP functions can be recorded)

kalos

  • Member
  • Joined in 2006
  • **
  • default avatar
  • Posts: 1,477
    • View Profile
    • Donate to Member
Re: quick replace, sort, change columns in EXCEL
« Reply #2 on: April 18, 2012, 02:42:05 PM »
I did it so easily with macro recorder!!! thanks!!!