how to create excel like tables

RiaanP

RiaanP

Moderator
Joined
11 Aug 2008
Posts
26,759
Reaction score
2,452
Location
Centurion
ever wanted to put your tank parameters up in a nice excel like table, but it all comes out messed up?

example
2014/12/03 8 1140 390 2014/12/04 8 1080 370 2014/12/05 8 1140 380 2014/12/07 8 1200 380 2014/12/09 8 1170 410 2014/12/12 8 1140 400

But that is not what you wanted.

2014/12/03 | 8 | 1140 | 390
2014/12/04 | 8 | 1080 | 370
2014/12/05 | 8 | 1140 | 380
2014/12/07 | 8 | 1200 | 380
2014/12/09 | 8 | 1170 | 410
2014/12/12 | 8 | 1140 | 400
 
how to do it.
In your excel spreadsheet, insert a new column between each columns you have.
Use the The '|' character; concatenation character, or pipe character. Normally above your enter button. Straight down line character.

Insert that between each cell you have. Repeat down for all the rows. Copy and paste it over all the other blank lines between your column data. But you cannot copy and paste directly from excel to here. Paste first in notepad or any other simple editor. Not MSword. Then copy and paste here. This action will loose the cell format instructions excel copied with your data.

This would end up with something like:

2014/12/03 | 8 | 1140 | 390
2014/12/04 | 8 | 1080 | 370
2014/12/05 | 8 | 1140 | 380
2014/12/07 | 8 | 1200 | 380
2014/12/09 | 8 | 1170 | 410
2014/12/12 | 8 | 1140 | 400
 
OK, getting there.

Now, to get the table thing working. Select or highlight your data. Then, at the top of the quick reply box (that is the box like area you are typing away when entering the text of a post). You will see a little box like icon, with a blue bar on top and faint grid lines. If you hover over it with your mouse, a tooltip could pop up saying "Wrap
tags around selected text" Select that while you still have your table data highlighted.

2014/12/03 | 8 | 1140 | 390
2014/12/04 | 8 | 1080 | 370
2014/12/05 | 8 | 1140 | 380
2014/12/07 | 8 | 1200 | 380
2014/12/09 | 8 | 1170 | 410
2014/12/12 | 8 | 1140 | 400

Be careful not to select a empty line above your data. Must start from the first character of your data.
 
Last edited:
Next. What about an heading.
That would be fun.

But this is a bit tricky.

After you hit the TABLE wrap tag, before you post your reply.
Change the first line, add
="head"
just after TABLE, but before the ] character

Date|PH|Magnesium|Calcium
2014/12/03 | 8 | 1140 | 390
2014/12/04 | 8 | 1080 | 370
2014/12/05 | 8 | 1140 | 380
2014/12/07 | 8 | 1200 | 380
2014/12/09 | 8 | 1170 | 410
2014/12/12 | 8 | 1140 | 400
 
Last edited:
above I added a new heading row.

Date|PH|Magnesium|Calcium

Not needed if you did included the heading in your data on the excel spreadsheet.

Can always use the Preview button on the "Post Reply" box to see and check if your table will come out right. Preview is not available on the "Quick Reply" box.
 
Last edited:
Riann I can help you out with a special course I didn at uni
 
You must log in or register to reply here.
Back
Top Bottom