You can do this too
Download now, it's easy
ASAP Utilities menu
Language:
Select » Move or resize selected range...
With this utility you can easily move or resize your selected range of cells.This utility will only change you selected range of cells only, not the data underneath it.
This is very powerful tool in combination with for example the "Conditional row and column select, hide or delete..." utility. For example if you have to make the cells in column B bold where the value in column A is "The Netherlands". You can then use the conditional select on column A and then use this "move" utility to move your selected range one column to the right. You then have selected all cells in column B that have in the same row the value "The Netherlands" in column A.
By default you can start this utility with the shortcut Control+Alt+M.
Video example
Screenshots
Example screenshot: 1 Move or resize selected range
Starting this utility
In the Excel menu choose ASAP Utilities » Select » Move or resize selected range...Additional keywords:
Select another column, Scroll
Select another column, Scroll
« Return to the list of “Select” utilities.
© 1999-2010 - Bastien Mensink - ASAP Utilities - Excel tools - A Must in Every Office BV - The Netherlands 