Add new cell pushing other cells right not down

[wimmer]

I need to add a cell to a row and have all the rows underneath move along/down one cell. As it is, the end of the row I am adding to goes 1 cell to the right, (outside my boxes where I am working), I need to add it and to go on the left of the next row down etc etc. Maybe I need to define an area/box to make excel do this but not sure how? Help appreciated.

 

[Michael M]

Hi Wimmer and Welcome to the Board.
If you want to do as requested you would need to use a macro, eg, cell A10, would be

Sub Mve()
Range("A10").Insert Shift:=xlToRight
end sub

 

[Andrew Poulsom]

What exactly are yoou doing to insert a row? If you insert an entire row all the cells move down. If you insert part of a row you get the option to shift cells right or down.

 

[wimmer]

I have 12 rows of 20 cells per row, I cannot go outside the 20 cell width for printing purposes. i need to insert a cell in the top row maintaining the order of the cells and keeping within the 20 cell guideline. Thanks.

 

[wimmer]

Title should read ' Add new cell pushing other cells down not right' !!

 

[Andrew Poulsom]

Select all 20 cells in the row before inserting.

 

[Michael M]

Ahh, sorry, I misunderstood.
From what you are saying, you want to wrap the last cell in the row 'round to the next row down, if you insert a cell ?
If thats' what you want, I'd suggest it can't be done.
You could maybe relocate the values to different cells to accomodate the new one....but that could get really ugly.
I'd suggest refiguring your template / form so that this issue doesn't arise.

 

[wimmer]

Nope. Not what i need sorry. I need to insert 1 cell in the top row of 20, say half way along, with out it pushing cell 20 to the right, I need the contents of cell 20 to become the contents of the next row down position 1, etc etc for the rows below that. Thx.