#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
Have you considered using the macro recorder?
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Quick change for all text boxes in a presentation | tmlander | PowerPoint | 1 | 03-09-2012 01:20 AM |
Is this sort of pivot possible in the Excel? | Jamal NUMAN | Excel | 4 | 02-14-2012 02:48 PM |
Find and replace multiple documents change style | BaPW | Word | 0 | 08-14-2011 11:12 AM |
How to sort table having three columns? | Bahir Barak | Word | 2 | 01-20-2011 01:52 PM |
Find and Replace - Variable change | Ssendam | Excel | 1 | 07-16-2009 11:44 AM |