How can I merge cells in an AppleWorks spreadsheet?

Question

Level 1

5 points

How can I merge cells in an AppleWorks spreadsheet?

I'm running Appleworks 6.2.9.

I have spreadsheet in which I'd like to merge some cells to enter a string of text. The Help menu shows the following:

After selecting the cells, choose Merge Cells from the Table menu.

I DON'T see a Table menu.

I figure if it's in the Help menu, it MUST be in the program SOMEWHERE. I just don't see it.

Any suggestions?

iMac 2.6GHz, Mac OS X (10.5.5)

Posted on Dec 21, 2008 1:09 PM

Reply

Answer 1

Best reply

Peggy

Level 8

41,601 points

Jan 12, 2011 6:59 AM in response to Peter WP

AppleWorks does not merge cells in spreadsheets. You can, though, get the same effect in a couple of ways.

1. Text in a cell will overflow into empty cells the right if left aligned, to the left if right aligned & to both sides if center aligned.

2. Create a floating text box to hold the text.

Reply

Answer 2

Barry

Level 9

59,861 points

Dec 17, 2010 8:19 AM in response to Peter WP

The Help article refers to cell in a Table in a word processing document. As Peggy notes, AppleWorks does not support merging cells in spreadsheets.

Regards,
Barry

Reply

Answer 3

Peter WP Author

Level 1

5 points

Dec 17, 2010 8:20 AM in response to Peter WP

Thanks for both of your replies!

Peggy-Prior to posting I did a forum search and saw your reply to a similar question. That's the solution I wound up using.

Brian-Thanks for the clarification on where the Merge Cells command works.

Reply