Video: How to move or resize the selected range in Excel with ASAP Utilities

The following video will show you how to how to move or resize the selected range in Excel by using ASAP Utilities.

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.

By default you can start this utility with the shortcut Control+Alt+M.0003-1-move-or-resize-selected-range


8 Responses to “Video: How to move or resize the selected range in Excel with ASAP Utilities”

  1. Hi Bastien,

    May the couple Live 1000 years !

    Nice to see the new version !
    Moving Ranges….! There is something like this in Excel Utilities by Rob Bovery….. But I could never make any specific use for the same. Do you experienced any particular scenarios where such can be used.

    Kind Regards
    Kanwaljit

  2. Hello Kanwaljit,

    I use this utility a lot in combination with the utility "Select cells based on content, formatting and more.." when I am preparing files or cleaning up data.
    For example when I need to publish race results I receive. The Excel file has a column with end result, start number, team name and names of people in the team below it, and the end time. Then I need to make the team names bold so I select the column with the startnumber, use conditional select to select all non-empty cells and then move the selection one to the right, one to the top and make the team name bold.

    Kind regards,
    Bastien

  3. Hi Bastien,

    May the couple Live 1000 years !

    Thanks for the explanation. Now I have hundred avenues open where I can intend to use it. Thanks again. Being the idle chap I am, here is another suggestion……..

    Presently we can create an Index page with links to all sheets clickable. But what If we need to change the name of all the sheet at once to another name (probable a more organized one)., e.g., in the following case the Sheet Index is the list of sheet names generated with the help of ASAP and New Name is the name required for each corresponding sheet. If there is any way to do this presently I am not aware of that………

    Sheet Index: New Name
    01-Oct to 10-2005
    02-Nov to 11-2005
    03-Dec to 12-2005
    04-Jan to 01-2006
    05-Feb to 02-2006
    06-Mar to 03-2006
    07-Apr to 04-2006
    08-May to 05-2006
    09-Jun to 06-2006
    10-Jul to 07-2006
    11-Aug to 08-2006
    12-Sept to 09-2006
    13-Oct to 10-2006
    14-Nov to 11-2006
    15-Dec to 12-2006
    16-Jan to 01-2007
    17-Feb to 02-2007
    18-Mar to 03-2007
    Apr-07 to 04-2007

    Hope that makes sense.

    Kind Regards
    Kanwaljit

  4. Hello Kanwaljit,

    The following utility is designed to help you with organizing and renaming the sheets.
    Usually there is text in a cell on the sheet which you want to use as the sheet name:
    Sheets » Change name of selected sheets to selected cell's value
    http://www.asap-utilities.com/asap-utilities-excel-tools-tip.php?tip=24&utilities=20&lang=en_us
    I know it is not exactly the same as you suggest, but I'm sure this utility can be useful.

    Kind regards,
    Bastien

  5. Hi Bastien,

    May the couple Live 1000 years !

    Surely, I tried that… But that doesn't work for this purpose…. or I am not aware of the exact steps that are required for the purpose. The present procedure says that the new name should be in Cell A1 of each selected sheet (and if the new names are on a sheet which is not to be renamed, then the names should be in the 1st cell of the selected range for each sheet). What I feel is it would be less time consuming to rename the sheet one by one instead of writing name in cell A1 of each sheet and then using ASAP to rename all of them at once. But if the same can be done through a list like above "Old Name" to "New Name", it would make the things much easier. Have you tried doing something like that…….?

    Kind Regards
    Kanwaljit

  6. Hi Bastien,

    May the couple Live 1000 years !

    Today I was using my favourite utility "Delete Leading Trailing and Excessive Spaces". It gave me the following error. The first line of the selection was a merged cell…

    "Version 4.5.2 – 01.May.2009
    Sorry, Something unexpected went wrong at Code Line 530 :
    Cannot Change part of a merged cell.
    Error 1004
    Excel 2003/ Window XP"

    Kind Regards
    Kanwaljit

  7. Hello Kanwaljit,

    Thank you for your feedback.
    This is indeed a bug. I will fix it and send you an email as soon as the pre-release of the new version is available.
    If things go as planned, that will be later today.

    Kind regards,
    Bastien

  8. This is a very useful little trick – thank you for sharing and creating an easy to follow video.

Pinterest