ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   edit insert dialogue box (https://www.excelbanter.com/excel-discussion-misc-queries/177838-edit-insert-dialogue-box.html)

Norika

edit insert dialogue box
 
In 2000, Excell, I had more option when it came to inserting or deleting. I
had 2003 Excel installed and now when I try to insert a cell, it will only
ask me to shift entire row or entire column. It doesn't allow me to shift
cells down or shift to the right.

David Biddulph[_2_]

edit insert dialogue box
 
How are you trying to do the insert? In Excel 2003 if you have a cell or
cells selected, as distinct from a row or column, you can either choose
Cells from the Insert menu, or right-click and choose Insert. In either
case you'll have the option to move cells to the right or down.
--
David Biddulph

"Norika" wrote in message
...
In 2000, Excell, I had more option when it came to inserting or deleting.
I
had 2003 Excel installed and now when I try to insert a cell, it will only
ask me to shift entire row or entire column. It doesn't allow me to shift
cells down or shift to the right.





All times are GMT +1. The time now is 08:46 PM.

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