ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   What happened to Insert Cut Cells? (https://www.excelbanter.com/excel-discussion-misc-queries/54306-what-happened-insert-cut-cells.html)

Johnny Naperville

What happened to Insert Cut Cells?
 
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?

Jim Rech

What happened to Insert Cut Cells?
 
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?



Dave Peterson

What happened to Insert Cut Cells?
 
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

Johnny Naperville

What happened to Insert Cut Cells?
 
"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.


All times are GMT +1. The time now is 06:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com