Here are two relevant features to explore when dealing with a concept o
"splitting cells." These actually treat selected cells in a row a
ONE, therefore JOINING, not SPLITTING.
-FORMAT... CELLS... ALIGNMENT... CENTER ACROSS SELECTION
or
-FORMAT... CELLS... ALIGNMENT... MERGE CELLS
If all you want to do is some heading formatting (putting a headin
across multiple columns), use CENTER ACROSS SELECTION-- it doesn't ge
in the way when moving cells or when cut/paste the way MERGE CELL
does. In fact, I am able avoid MERGE CELLS entirely in some ver
complex and good-looking spreadsheets
The spreadsheet user has one column for dates checks were issued. Sometimes
there are two checks. There may be 10 entries (rows) of data out of 100 that
she would like to be able to enter both payment dates in this column. Right
now she is entering both dates separated by several spaces and drawing a
vertical line down the middle of the cell(s) to make it look like two
separate cells in the same column. I'm pasting an example below. Hope it
works.
Attached to this reply is a spreadsheet with the CENTER ACROSS SELECTIO
formatting method applied to put a heading across the two date
columns. Dates are entered in two cells next to each other. Seems t
be one answer to the user requirement
Thank you. This was the solution I presented to her, but it is a very long
spreadsheet with all sorts of merged cells and other preexisting formatting
that would be messed up by adding another column. I know I can split
individual cells in Dreamweaver and was just hoping it might be possible in
Excel.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
