I need to insert a column into a range of cells without inserting a column in
the whole worksheet.

It sounds like you don't really want to insert a column. You just
want to insert some cells in some selected rows. If you highlight the
range of cells where you want to insert the "column" then click Insert
- Cells you will be prompted to "Shift cells right", "Shift cells
down", "Entire row" or "Entire column". I suspect from your
description you will want to "shift cells right" since that will be
like inserting a column, for a specific group of rows.

Good luck.

Ken
Norfolk, Va

On Jun 22, 4:03 pm, Retirement Guy
wrote:
I need to insert a column into a range of cells without inserting a column in
the whole worksheet.

I tried that, but perhaps I am explaining it incorrectly. I want to split
the cell into two cells, and maintian the column without adding another
column. If that makes sense...........

" wrote:

It sounds like you don't really want to insert a column. You just
want to insert some cells in some selected rows. If you highlight the
range of cells where you want to insert the "column" then click Insert
- Cells you will be prompted to "Shift cells right", "Shift cells
down", "Entire row" or "Entire column". I suspect from your
description you will want to "shift cells right" since that will be
like inserting a column, for a specific group of rows.

Good luck.

Ken
Norfolk, Va

On Jun 22, 4:03 pm, Retirement Guy
wrote:
I need to insert a column into a range of cells without inserting a column in
the whole worksheet.

What do you expect to see above and below the range of split cells?

You could merge the cells above and below and you would effectively
have a range of rows where there are two columns of total width equal
to the one column above and below; but, merged cells suck. They would
have to be merged a row at a time (or through code) and in the end you
would have a lot of merged cells and merged cells are to be avoided;
not necessarily at all costs, but, usually there is a better way.

Ken


On Jun 22, 5:01 pm, Retirement Guy
wrote:
I tried that, but perhaps I am explaining it incorrectly. I want to split
the cell into two cells, and maintian the column without adding another
column. If that makes sense...........



" wrote:
It sounds like you don't really want to insert a column. You just
want to insert some cells in some selected rows. If you highlight the
range of cells where you want to insert the "column" then click Insert
- Cells you will be prompted to "Shift cells right", "Shift cells
down", "Entire row" or "Entire column". I suspect from your
description you will want to "shift cells right" since that will be
like inserting a column, for a specific group of rows.

Good luck.

Ken
Norfolk, Va

On Jun 22, 4:03 pm, Retirement Guy
wrote:
I need to insert a column into a range of cells without inserting a column in
the whole worksheet.- Hide quoted text -

- Show quoted text -

Cannot be done.

Try this.

Select a range of cells in one column with the range.

InsertShift cells Right


Gord Dibben MS Excel MVP

On Fri, 22 Jun 2007 13:03:01 -0700, Retirement Guy
wrote:

I need to insert a column into a range of cells without inserting a column in
the whole worksheet.