rows and columns in spreadsheet

L

little_dorrit

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Is there a way, in Excel, that I can merge cells, rows, or columns, like I can in Numbers?
 
J

John McGhie

Yes there is, but before you do, ask yourself two questions:

1) Is a spreadsheet really the right place to be doing this?

2) Are you sure you don't want to use the data in those cells for anything
later?

The "golden rule" with spreadsheets is to have only ONE "piece" or "kind" of
data in each cell. Once you merge cells, it becomes nearly impossible to
use the data in a formula for anything else later.

If you do not want to do that, you might be better off doing what you are
doing in Word or PowerPoint, which give you greater flexibility with
formatting.

If this is not an issue in your circumstances, then see the Excel Help topic
"Merge or split cells or cell contents" to show you how to do it.

Cheers


Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Is there a way, in Excel, that I can merge cells, rows, or columns, like I can
in Numbers?


--

This email is my business email -- Please do not email me about forum
matters unless you intend to pay!

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410
+61 4 1209 1410, mailto:[email protected]
 

Ask a Question

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.

Ask a Question

Similar Threads


Top