Moving cells and columns

**Boston Robby** · 01-21-2012, 03:07 PM

Hi Folks,
I'm trying to put 3 different sets of info on the same document. The top set has 5 columns and different size cells. Now I want to skip down and start another area. When I try to add a column or move a cell, it effects the entire document. Any thoughts on how I can lock the top cells and then start to manipulate the middle cells seperately? Thanks Robby.

**MarvinP** · 01-21-2012, 03:33 PM

Hi Robby and welcome to the forum,

You could put your two ranges on different sheets. You could also put the ranges side by side if you want to insert a column into the second one. I believe you are seeing a normal problem if you try to insert a column. It will insert the column all the way to the last cell in the worksheet.

Another possible answer is not to insert an entire column but insert a range. Select the column in the second table only and right click and insert. It will ask what direction you want to insert. You will click on "Shift cells right".

**Boston Robby** · 01-21-2012, 03:51 PM

Thank you very much for your reply. That definetly helps. The other piece is upon adding the range, any thoughts on how I can format the size of the cell. I did insert the range but when trying to move the column, the cells above move with it.

**MarvinP** · 01-21-2012, 04:02 PM

Hi,

That was the point of my answer. If you insert or move the whole column the table/range above it will be moved/inserted too. You need to only select the range of cells you want to insert and then Shift Right.

I believe this is just how Excel works. Without a sample file or better discription I can't be more specific.