ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   Excel 2003-Insert Cut Cells (https://www.excelbanter.com/setting-up-configuration-excel/196299-excel-2003-insert-cut-cells.html)

jo819

Excel 2003-Insert Cut Cells
 
Prior to reinstalling Excel 2003, I was able to cut rows from one file and
insert them into a new file using my mouse. Now that the Excel has been
reinstalled, the insert cells option does not appear on the menu, to allow me
to do this. How can I get this option to be available?

StumpedAgain

Excel 2003-Insert Cut Cells
 
The problem is probably that you are trying to now cut from one instance of
excel and insert paste into another instance of excel. For some reason, not
all the options for going from one instance to another are available with
copy/cut/paste. I would suggest opening your destination file within the
same instance of Excel. You should then be able to cut/Insert Cut Cells.
Hope this helps!

--
-SA


"jo819" wrote:

Prior to reinstalling Excel 2003, I was able to cut rows from one file and
insert them into a new file using my mouse. Now that the Excel has been
reinstalled, the insert cells option does not appear on the menu, to allow me
to do this. How can I get this option to be available?


Gord Dibben

Excel 2003-Insert Cut Cells
 
You still can in 2003 but if you happen to be running two instances of Excel
with a workbook open in each the Insert Cut Cells is unavailable.

Close one instance and open both books in one instance.

And then to prevent a new instance of Excel from starting go to
ToolsOptionsGeneral and uncheck "Ignore other apllications."


Gord Dibben MS Excel MVP


On Fri, 25 Jul 2008 07:27:00 -0700, jo819
wrote:

Prior to reinstalling Excel 2003, I was able to cut rows from one file and
insert them into a new file using my mouse. Now that the Excel has been
reinstalled, the insert cells option does not appear on the menu, to allow me
to do this. How can I get this option to be available?




All times are GMT +1. The time now is 04:53 PM.

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