Trying to split a cell in Excel 2003, just like in Word Tables
 

Click in a cell, or select multiple cells that you want to split.
On the Table menu, click Split Cells .
Select the number of columns or rows you want to split the selected cells
into. This is the information I get in MS Word 2003, but cannot find the
function in MS Excel 2003, can someone help?

Trying to split a cell in Excel 2003, just like in Word Tables
 

Kjandar,

The "cells" you are splitting in Word are from a table, which is an object
placed on the word document. The cells in excel are part of the spread
sheet, and can not be "split". Maybe better layout planning would help.There
are 256 columns and over 65000 rows, so with so many cells available why
would you need to split any of them?
Mike Rogers


"Kjandar" wrote:

Click in a cell, or select multiple cells that you want to split.
On the Table menu, click Split Cells .
Select the number of columns or rows you want to split the selected cells
into. This is the information I get in MS Word 2003, but cannot find the
function in MS Excel 2003, can someone help?

Trying to split a cell in Excel 2003, just like in Word Tables
 

Not possible and neither is a good way to design in Excel, what you
basically do is that you split one cell so it would look like

cell1|cell2
c e l l 3

if you would translate that to excel it means that cell3 becomes merged and
it causes a lot of problems. You can check that by making a table in word
like than and then paste it into excel




















pasted into A1 will make row 2 merged and there is no practical use of
having that in a spreadsheet except for looks. You can't calculate normally
using formulas that take ranges. You can't paste in a range of values
without getting messages like "cannot change part of a merged cell"


--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"Kjandar" wrote in message
...
Click in a cell, or select multiple cells that you want to split.
On the Table menu, click Split Cells .
Select the number of columns or rows you want to split the selected cells
into. This is the information I get in MS Word 2003, but cannot find the
function in MS Excel 2003, can someone help?

God, I just LOVE self-appointed experts who know what's best for everyone else. If I didn't have a practical use for splitting a cell in Excel, I wouldn't have gone looking for a solution and I never would have found this post. Just because YOU don't have a need for it doesn't make it of "no practical use". You must work at Microsoft, where the philosophy is "take it or leave it - what the customer wants is of no concern".

Funny how I'm only trying to split a cell to work a round a limitation of Excel that Open Office and Libre Office do not have. That limitation is only one hyperlink per cell. Microsoft obviously doesn't see it as a limitation, and I suppose you don't either. The only workaround is to use mulitple cells, but I'll be damned if I'm going to create extra columns for the appearance of split cells, then have to merge all those cells in every other row in the spreadsheet (it's at 757 rows and counting) to get them back to the single cell I need.

You may say Excel isn't the proper tool for what I'm trying to do, and that I should use a Word table instead, but in that case please tell me how to make a Word table with 42 columns (and counting) by 757 rows (and counting). And, I need to be able to add rows and columns without affecting the size/position/formatting of the existing rows and columns. Seems like Excel is the right tool for this job, except for the hyperlink limitation. I'd use Libre Office in a heartbeat, but this is at work and I'm constrained to using Office.

In any case, get off your high horse and open your mind; just because you don't want to do something doesn't mean anyone who does is foolish. Quite the opposite, in fact.