how to create excel like tables

Discussion in 'Forum Usage' started by RiaanP, 15 Dec 2014.

  1. RiaanP

    RiaanP Moderator

    Joined:
    11 Aug 2008
    Posts:
    23,163
    Likes Received:
    1,231
    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
     
  2. AdS Guest




    to hide all adverts.
  3. RiaanP

    RiaanP Thread Starter Moderator

    Joined:
    11 Aug 2008
    Posts:
    23,163
    Likes Received:
    1,231
    Location:
    Centurion
    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
     
  4. RiaanP

    RiaanP Thread Starter Moderator

    Joined:
    11 Aug 2008
    Posts:
    23,163
    Likes Received:
    1,231
    Location:
    Centurion
    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: 15 Dec 2014
  5. RiaanP

    RiaanP Thread Starter Moderator

    Joined:
    11 Aug 2008
    Posts:
    23,163
    Likes Received:
    1,231
    Location:
    Centurion
    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

    [TABLE="head"]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
    [/TABLE]
     
    Last edited: 15 Dec 2014
    tekkengal likes this.
  6. RiaanP

    RiaanP Thread Starter Moderator

    Joined:
    11 Aug 2008
    Posts:
    23,163
    Likes Received:
    1,231
    Location:
    Centurion
    above I added a new heading row.

    [TABLE="head"]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: 15 Dec 2014
  7. Midnight Reefer

    Midnight Reefer

    Joined:
    8 Aug 2013
    Posts:
    346
    Likes Received:
    7
    Location:
    no comment
    Riann I can help you out with a special course I didn at uni
     
  8. RiaanP

    RiaanP Thread Starter Moderator

    Joined:
    11 Aug 2008
    Posts:
    23,163
    Likes Received:
    1,231
    Location:
    Centurion
    OK, can be great. Problem is that whatever we do, must work within the software that drives this site.
     
Recent Posts

Loading...
Similar Threads - create excel tables Forum Date
Are all Nano's created equal Beginner Discussions 5 Jan 2016
HOW TO - create a private forum? Pet Stop SA 14 Oct 2015
New Zealand to create giant Sth Pacific sanctuary, banning fishing, mining Internet 29 Sep 2015
Create a feeding frenzy with the Ocean Nutrition Seaweed Clip JungleAquatics.NET BLOG 15 Jun 2015
Create a public display aquarium without spending money. Aquascaping 11 Mar 2010
create micro plankton General Discussions and Advice 1 Dec 2008
Excellent after sales service from Aquaria Sa Aquaria 28 Jul 2016