Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Insert a column within a range of cells
I need to insert a column into a range of cells without inserting a column in
the whole worksheet. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Insert a column within a range of cells
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Insert a column within a range of cells
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Insert a column within a range of cells
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 - |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Insert a column within a range of cells
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert range of cells with a function | Excel Worksheet Functions | |||
How can I insert and delete rows within a locked cell range column | Excel Worksheet Functions | |||
Insert contents of various cells in a column into one cell? | Excel Discussion (Misc queries) | |||
insert picture to a specfic range of cells | Excel Discussion (Misc queries) | |||
how insert same text in empty cells in column (10000 rows) | Excel Worksheet Functions |