Excell, why oh why can't you just move rows up and down !!!!!

[Guest]

You know, back before excell, when it was multiplan on the original Mac's,
you could easily move rows and columns, inserting them INBETWEEEEEN other
rows and colums. Twenty years later you still havn't corrected the idiotic
proceedure required to move rows and columns in Excel. When you drag or
paste a row or column it should default to slipping in INBETWEEEEEN the
others. You could even have a cute little bar appear to indicate the
difference between inserting INBETWEEEEEEN things and overwriting them (like
Multiplan had). I have looked and looked for years and can't find a better
work around in Excell than to create a blank row to be over written by the
one I want to move there and then cutting and pasting the row I'm moving and
then going back and erasing the blank row Excell creates in it's place.
That's perfectly rediculous.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...6-a8d354ad55e3&dg=microsoft.public.excel.misc

 

[Ken Wright]

So what you are saying is that you haven't tried selecting the rows in
question, then right-clicking between the row headers and the rows, dragging
to where it needs to go to, then letting go and choosing the 'Move here'
option, at which point Excel will (and I quote)

default to slipping in INBETWEEEEEN the others

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission
------------------------------­------------------------------­----------------

 

[Sandy Mann]

to where it needs to go to, then letting go and choosing the 'Move here'

In XL 97 at least this replaces the column/row that it is covering. I
assume that you mean "Shift {Right/Down} and Move"

--
Regards

Sandy
(e-mail address removed)
Replace@mailinator with @tiscali.co.uk

 

[Ken Wright]

LOL - Oops - Knew it was one of those damn options

Thanks for the catch Sandy.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission
------------------------------­------------------------------­----------------

 

[Guest]

Well, actually that's a big improvement, using cut & paste that way, except
that it inserts the gap above the one selected for some reason.... Thanks

 

[Jonibenj]

Why not follow this procedure:

1. Select the row/column you want to move and press Ctrl+X (for th
'cut' operation)
2. Go to the required place and right click on the row/column afte
the point at which you want to insert
3. Select the command that says 'insert copied cells'

The row/column will be inserted, and the gap from whence it was take
will be closed up! The same procedure can be used to transfer mor
than one row/column at a time. However, when moving between sheets o
separate workbooks, the original gap will need to be deleted.

Jonatha

 

[Guest]

Phil,

I'm not trying to sound like a miser by saying this, but you could simply
click on the row/column 'below' where you want it to go and inset the
cut/copied row/column.....

hope your enjoying your day mate

R,
Chris.