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

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 :-)
------------------------------­------------------------------­----------------


"Sandy Mann" <sandymann2@xxxxxxxxxxxxxx> wrote in message
news:uQriTO%23tFHA.2952@xxxxxxxxxxxxxxxxxxxxxxx
>> 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
> sandymann@xxxxxxxxxxxxxx
> Replace@mailinator with @tiscali.co.uk
>
>
> "Ken Wright" <ken.wright@xxxxxxxxxxxxxxxxxx> wrote in message
> news:%23vtXmB%23tFHA.3740@xxxxxxxxxxxxxxxxxxxxxxx
>> 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 :-)
>> ------------------------------­------------------------------­----------------
>>
>>
>>
>> "Phil H" <PhilH@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:C352F0FA-6EC6-47FD-B106-A8D354AD55E3@xxxxxxxxxxxxxxxx
>>> 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/community/en-us/default.mspx?mid=c352f0fa-6ec6-47fd-b106-a8d354ad55e3&dg=microsoft.public.excel.misc
>>
>>
>
>


.