Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
I have a few forms that I made for work and need to modify a few things. I
was wondering if it is possible to split a cell without changing the column width and inserting a new column and changing that width to keep the form format correct. Nobody here at works has any idea so the next best place to ask is here. Thank you in advance for any answers. |
#2
![]() |
|||
|
|||
![]()
Super,
You can insert another column, then adjust the width of the two columns to equal that of the original column. To insert a column, select the column to the right of where you want to insert, then do Insert - Columns. Now to adjust any column width, drag the border, up in the header (A, B, C...). -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Supervisor" wrote in message ... I have a few forms that I made for work and need to modify a few things. I was wondering if it is possible to split a cell without changing the column width and inserting a new column and changing that width to keep the form format correct. Nobody here at works has any idea so the next best place to ask is here. Thank you in advance for any answers. |
#3
![]() |
|||
|
|||
![]()
Thanks for the info, Karl, but in my post I specifically stated I did not
want to go that route. I want to split one single cell without adding a column and adjusting widths. I do appreciate your answer. Sup "Earl Kiosterud" wrote: Super, You can insert another column, then adjust the width of the two columns to equal that of the original column. To insert a column, select the column to the right of where you want to insert, then do Insert - Columns. Now to adjust any column width, drag the border, up in the header (A, B, C...). -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Supervisor" wrote in message ... I have a few forms that I made for work and need to modify a few things. I was wondering if it is possible to split a cell without changing the column width and inserting a new column and changing that width to keep the form format correct. Nobody here at works has any idea so the next best place to ask is here. Thank you in advance for any answers. |
#4
![]() |
|||
|
|||
![]()
Supervisor, you can not split a cell in excel, you can center across
selection or merge cells, would that help? -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Supervisor" wrote in message ... Thanks for the info, Karl, but in my post I specifically stated I did not want to go that route. I want to split one single cell without adding a column and adjusting widths. I do appreciate your answer. Sup "Earl Kiosterud" wrote: Super, You can insert another column, then adjust the width of the two columns to equal that of the original column. To insert a column, select the column to the right of where you want to insert, then do Insert - Columns. Now to adjust any column width, drag the border, up in the header (A, B, C...). -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Supervisor" wrote in message ... I have a few forms that I made for work and need to modify a few things. I was wondering if it is possible to split a cell without changing the column width and inserting a new column and changing that width to keep the form format correct. Nobody here at works has any idea so the next best place to ask is here. Thank you in advance for any answers. |
#5
![]() |
|||
|
|||
![]()
Super,
I wasn't sure which you were asking about. Unfortunately, you can't split a single cell. You can in a table in Front Page, or in Word, but not in Excel. If you absolutely have to, you could put another column, then merge all the cells except the one where you want a split. This isn't really recommended, as merged cells are generally troublesome, and avoided by most folks. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Supervisor" wrote in message ... Thanks for the info, Karl, but in my post I specifically stated I did not want to go that route. I want to split one single cell without adding a column and adjusting widths. I do appreciate your answer. Sup "Earl Kiosterud" wrote: Super, You can insert another column, then adjust the width of the two columns to equal that of the original column. To insert a column, select the column to the right of where you want to insert, then do Insert - Columns. Now to adjust any column width, drag the border, up in the header (A, B, C...). -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Supervisor" wrote in message ... I have a few forms that I made for work and need to modify a few things. I was wondering if it is possible to split a cell without changing the column width and inserting a new column and changing that width to keep the form format correct. Nobody here at works has any idea so the next best place to ask is here. Thank you in advance for any answers. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
How do I get one cell to record the time another cell was changed. | Excel Discussion (Misc queries) | |||
How can I split a cell in Excel? | Excel Discussion (Misc queries) | |||
Display actual contents of cell | Excel Discussion (Misc queries) | |||
copy a cell value not its function | Excel Discussion (Misc queries) |