Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-18-2012, 11:43 AM
userman userman is offline quick replace, sort, change columns Windows XP quick replace, sort, change columns Office 2003
Advanced Beginner
quick replace, sort, change columns
 
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
  #2  
Old 05-01-2012, 06:24 AM
dazwm dazwm is offline quick replace, sort, change columns Windows XP quick replace, sort, change columns Office 2007
Advanced Beginner
 
Join Date: May 2012
Posts: 59
dazwm is on a distinguished road
Default

Have you considered using the macro recorder?
Reply With Quote
Reply

Thread Tools
Display Modes


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
quick replace, sort, change columns 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
quick replace, sort, change columns How to sort table having three columns? Bahir Barak Word 2 01-20-2011 01:52 PM
quick replace, sort, change columns Find and Replace - Variable change Ssendam Excel 1 07-16-2009 11:44 AM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 10:45 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft