ASAP Utilities how to with ASAP Utilities

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

by Bastien 8 Comment

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.

Note: This has in 2021 be replaced with a new video in a modern version of Excel.

 

Related Posts

8 comments

Kanwaljit`

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

Bastien

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

Kanwaljit`

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

Bastien

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
//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

Kanwaljit`

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

Kanwaljit`

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

Bastien

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

Excel learner

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