Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Moving Columns Excel 2007
You can no longer move rows/columns in 2007 like you could in 2003. Help
tells you to grab the move pointer and drag it to a new location. However, rather than move the new column between a couple other columns it wants to replace the contents of one of the existing columns. This task used to be easy. Is there some other way to do this (vs. inserting a blank column and copying and pasting. GRRR). Is there a fix on the way for this? thanks, BK |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Moving Columns Excel 2007
I don't use the mouse often to move/insert ranges but, based on how I do, it
seems the same. When I grab a range it defaults to overwrite the destination but if I hold Shift down it switches to an Insert. -- Jim "BK" wrote in message ... | You can no longer move rows/columns in 2007 like you could in 2003. Help | tells you to grab the move pointer and drag it to a new location. However, | rather than move the new column between a couple other columns it wants to | replace the contents of one of the existing columns. This task used to be | easy. Is there some other way to do this (vs. inserting a blank column and | copying and pasting. GRRR). | | Is there a fix on the way for this? | | thanks, | BK |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Moving Columns Excel 2007
SHIFT and drag will insert the dragged column.
CTRL and drag will overwrite without asking. Alt and drag or straight drag will ask if you want to overwrite. Gord Dibben MS Excel MVP On Fri, 15 Aug 2008 05:52:00 -0700, BK wrote: You can no longer move rows/columns in 2007 like you could in 2003. Help tells you to grab the move pointer and drag it to a new location. However, rather than move the new column between a couple other columns it wants to replace the contents of one of the existing columns. This task used to be easy. Is there some other way to do this (vs. inserting a blank column and copying and pasting. GRRR). Is there a fix on the way for this? thanks, BK |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
why is moving a row slow in excel 2007 where it is fast in 2000 | Excel Worksheet Functions | |||
How do I use moving averages in Excel 2007? | Excel Worksheet Functions | |||
"moving average" Excel 2003 vs Excel 2007 | Excel Worksheet Functions | |||
how to lock pictures from moving or being deleted in excel 2007 | Excel Discussion (Misc queries) | |||
Excel moving horizontal columns to vertical | Excel Discussion (Misc queries) |