Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
In Excel 2002, I can select a range, cut it, select where I want to move the
range to and choose Insert Cut Cells and Excel will make room and insert the cut cells. This is very useful for rearranging a long list of items. In Excel 2003, when I do this, Insert Cut Cells never appears. What changed? Can I get this back? |
#2
![]() |
|||
|
|||
![]()
Looks the same to me in Excel 2003 as 2002. It's at the top of the Insert
menu (after a Cut) and also on the right click menu. -- Jim "Johnny Naperville" wrote in message ... | In Excel 2002, I can select a range, cut it, select where I want to move the | range to and choose Insert Cut Cells and Excel will make room and insert the | cut cells. This is very useful for rearranging a long list of items. In Excel | 2003, when I do this, Insert Cut Cells never appears. What changed? Can I get | this back? |
#3
![]() |
|||
|
|||
![]()
Any chance you have an event macro firing (worksheet_selectionchange??)?
It could be clearing the clipboard. Johnny Naperville wrote: In Excel 2002, I can select a range, cut it, select where I want to move the range to and choose Insert Cut Cells and Excel will make room and insert the cut cells. This is very useful for rearranging a long list of items. In Excel 2003, when I do this, Insert Cut Cells never appears. What changed? Can I get this back? -- Dave Peterson |
#4
![]() |
|||
|
|||
![]()
"Dave Peterson" wrote:
Any chance you have an event macro firing (worksheet_selectionchange??)? It could be clearing the clipboard. That must have been the issue. I turned off all of the Add-Ins and it works now. Thank you for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Use functions when cells are merged | Excel Worksheet Functions | |||
insert rows and update linked cells | Excel Discussion (Misc queries) | |||
Help adding text values | Excel Worksheet Functions | |||
How can I get "Insert copied cells..." to not be grayed-out? | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions |