User talk:PS123456

How can I split a cell?

PS123456 (talk) 20:26, 10 August 2009 (UTC)


 * Brief answer, because I'm busy: You can't. You'd have to make a table with the maximum number of rows/columns required, and use the "rowspan" and/or "colspan" thing for all the ones that *weren't* split. Hope that makes sense. If you need more clarification and an example, let me know on my talk page and I'll get back to you ASAP. Cheers,  Chzz  ►  21:39, 10 August 2009 (UTC)

Help with tables
How do I create a table? It is the same format as excel, and would be the same as the one on the Industry Benchmark Classification page.

Is it possible to import an excel sheet, rather than manually adding all the content of each row and column, since the sheet is quite long? Also, on the Industry Benchmark Clasification page, certain rows have been merged. How can I do this?

Thanks

Reply

When you post on a talk page (such as this), please remember to "sign" your name by typing ~ at the end of the message - this will add your username, and the date and time.

The format for a simple table looks like this;

...which produces this;

To 'merge columns', you use syntax like this;

...which produces this...

For more on this, see WP:TABLES.

I don't know of any clever way to automatically import something from Excel; I'm afraid it's rather a fiddly process, but it can be speeded up with a bit of clever search/replace.

As with everything else, work on it in your userspace before making it live, such as make a page called User:PS123456/my test page - you can click on that redlink to make the page.

Note that Wikipedia is not a directory, hence it might not be appropriate to add a large table of data.

For more help, you can either;


 * Leave a message on my own talk page;
 * Use another here,;
 * Talk to us live, with this or this.

Best wishes,  Chzz  ►  19:45, 10 August 2009 (UTC)
 * Actually, there is a tool to convert from Excel to wiki format. The page Help:Table links to http://excel2wiki.net/index.php which can be used.  Just copy and paste cells from Excel, press submit, and the page will give the formatting for a table that can be used in Wikipedia.  --Mysdaao talk 19:51, 10 August 2009 (UTC)

Welcome and introduction
Hi, PS123456. This is NOT some automated message...it's from a real person. You can talk to me right now. Welcome to Wikipedia! I noticed you've just joined, and wanted to give you a few tips to get you started. If you have any questions, please talk to us. The tips below should help you to get started. Best of luck!  Chzz  ►  19:45, 10 August 2009 (UTC)