Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Supervisor
 
Posts: n/a
Default how do you split a cell?

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   Report Post  
Earl Kiosterud
 
Posts: n/a
Default

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   Report Post  
Supervisor
 
Posts: n/a
Default

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   Report Post  
Paul B
 
Posts: n/a
Default

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   Report Post  
Earl Kiosterud
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Maintaining cell reference after sorting GRITS Excel Discussion (Misc queries) 2 April 30th 23 07:42 PM
How do I get one cell to record the time another cell was changed. Reigning in Seattle Excel Discussion (Misc queries) 1 December 17th 04 07:45 PM
How can I split a cell in Excel? LI Associate Excel Discussion (Misc queries) 1 December 14th 04 11:35 PM
Display actual contents of cell xmasbob Excel Discussion (Misc queries) 1 December 6th 04 05:09 PM
copy a cell value not its function KC Mao Excel Discussion (Misc queries) 2 December 4th 04 04:30 AM


All times are GMT +1. The time now is 10:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"