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.
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".
One test is worth a thousand opinions.
Click the * below to say thanks.
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.
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.
One test is worth a thousand opinions.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks