Cell Selection: Maintain area 'shape' and move around wksht

Adamski

New Member
Joined
Aug 5, 2004
Messages
23
Hey there.

Done the search of posts, but found nowt.

Simple question:
I want to delete a bunch of stuff from a workbook.
Mostly rows of data - NOT THE ENTIRE ROW.
Lets say row 15, column E to CK
So I highlight these cells and hit delete.
Now I want to delete the same columns in row 18....
So I have to select cell E18 and then run the mouse all the way to the right, hoping to stop on column CK. I hit delete and then move on to the next row, lets say its row 27...same again, select E27, run across to CK27, hit delete.

Is there a way for me to keep the original cell selection (E15:CK15) and just 'move' it down the sheet, rather than having to keep selecting (i.e. dragging) all the cells in a row time after time?

I don't want a code (although it would be great), I just wondered if there was a keyboard short cut.

Thanks in advance...
 

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

roaze2000

New Member
Joined
Jul 19, 2005
Messages
49
Try clicking the black rectangle with your left mouse button and drag it from your row 15 to row 18...that works for most people
 

Adamski

New Member
Joined
Aug 5, 2004
Messages
23
roaze2000 - thanks, but you misunderstand.
Grabbin the black rectangle copies the contents. Not what I want.

Imagine, for whatever reason, you select cells that form the shape of an L.

Now you want to repeat (i.e. move) that L shape selection somewhere else on your work sheet. Only move the shape - NOT copy the contents.

It's just that I have a load of rows to empty of data.
The same 'AREA' of cells, but in different positions across the worksheet.
So, how can I create an AREA 'MASK' of a bunch of cells that I can easily move around the screen.

I figured there maybe a way, like holding Ctrl+Shft+PageUp+TAB+F4 so that you could drag your selection shape of cells to other areas of the sheet.

Any better?
 

roaze2000

New Member
Joined
Jul 19, 2005
Messages
49
You can do it with ASAP utilities....

search for it in google,

free add in for excel
 

Forum statistics

Threads
1,141,758
Messages
5,708,358
Members
421,566
Latest member
7Nabisco

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top