+ Reply to Thread
Page 1 of 17 1 2 3 11 ... LastLast
Results 1 to 15 of 243

How to post a range - headers and data?

  1. #1
    Forum Contributor
    Join Date
    12-22-2010
    Location
    Rio, Brazil
    MS-Off Ver
    Excel 2010, 2016
    Posts
    209

    How to post a range - headers and data?

    Hi,

    How to post a range of my worksheet keeping the alignment of the cells (rows/columns)?

    I tried using IE10: select range; put borders; copy; paste in the forum reply page.

    But it didn't work as expected - the cells were not aligned with headers and the spacing was messed up.

    I tried also Go Advanced > Table but i could see only html tags...

    Am i missing something or is always preferable attach a file?

    Thanks in advance for any help.

    Marcelo
    Marcelo Branco

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO200;Win10/MSO2016
    Posts
    9,141

    Re: How to post a range - headers and data?

    The easiest way is to use [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags. You might have to make slight adjustments.

    Please Login or Register  to view this content.
    Ben Van Johnson

  3. #3
    Forum Contributor
    Join Date
    12-22-2010
    Location
    Rio, Brazil
    MS-Off Ver
    Excel 2010, 2016
    Posts
    209

    Re: How to post a range - headers and data?

    Ben,

    Thank you for the tip.

    I'll try the CODE tags.

    MArcelo

  4. #4
    Forum Contributor
    Join Date
    12-22-2010
    Location
    Rio, Brazil
    MS-Off Ver
    Excel 2010, 2016
    Posts
    209

    Re: How to post a range - headers and data?

    Just testing

    Please Login or Register  to view this content.
    It seems ok

    Thanks again, Ben

  5. #5
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,892

    Re: How to post a range - headers and data?

    Let me test a couple of samples...

    Please Login or Register  to view this content.
    If I make that 1st column wider:

    Please Login or Register  to view this content.
    As you can see it only looks OK when the data is of a relatively uniform width.
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  6. #6
    Forum Contributor
    Join Date
    12-22-2010
    Location
    Rio, Brazil
    MS-Off Ver
    Excel 2010, 2016
    Posts
    209

    Re: How to post a range - headers and data?

    Hi Biff,

    Nice to "see" you

    Yes, I understand what you are saying. It seems that not always is possible to post a nice and understandable table using copy and paste.

    Do you know how to do tables like these?
    http://www.excelforum.com/excel-form...ple-cells.html

  7. #7
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,892

    Re: How to post a range - headers and data?

    Unfortunately, I don't know how to make those kinds of tables. Wished I did.

    They use html table tags.

    EDIT: Correction. They use the BB code tags.

    At that link, on the top post, click the "Reply With Quote" button and you'll see the code used to produce the tables.

    I don't understand it at all!

    If anyone that reads this post knows how to make those kinds of tables how about posting a little tutorial for us?
    Last edited by Tony Valko; 08-25-2013 at 11:14 AM.

  8. #8
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    41,418

    Re: How to post a range - headers and data?

    Editing that thread to see what they did gives info that to me, make it seem easier to just post a sample W/B lol...
    (I may end up editing/posting a cpl of times to show the code)

    [table="width: 200, class: grid, align: left" "]"
    [tr]
    [td]cat[/td]
    [td]pet store 1[/td]
    [/tr]
    [tr]
    [td]dog[/td]
    [td]pet store 1[/td]
    [/tr]

    and that was just for the 1st 2 rows!!
    Last edited by FDibbins; 08-24-2013 at 05:44 PM.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think some-1 helped you

    Regards
    Ford

  9. #9
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO200;Win10/MSO2016
    Posts
    9,141

    Re: How to post a range - headers and data?

    tr = table row
    td = table data (cell)

    the [td][/td] 's must be wrapped by [tr][/tr] in all cases. Note that the data to be displayed must be within [td][/td] tags (e.g.) [td]Ben[/td]

    here's one with two rows, 3 columns each
    Please Login or Register  to view this content.
    results in:



    here's one with three rows, row one has tow columns, row two has only one and row three has five:


    Please Login or Register  to view this content.
    resulting in:
    Last edited by protonLeah; 08-24-2013 at 06:04 PM.

  10. #10
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    41,418

    Re: How to post a range - headers and data?

    Thanks Ben - like I said - almost easier to post a sample workbook

  11. #11
    Forum Contributor
    Join Date
    12-22-2010
    Location
    Rio, Brazil
    MS-Off Ver
    Excel 2010, 2016
    Posts
    209

    Re: How to post a range - headers and data?

    TESTING

    < Table > <tr><td> </td><td>A</td><td>B</td></tr> < tr > <td>1</td><td>Name</td><td>Scores</td></tr>
    < tr > <td>2</td><td>John</td><td>30</td></tr>
    < tr > <td>3</td><td>Mary</td><td>32</td></tr>
    < tr > <td>4</td><td>Mike</td><td>34</td></tr>
    < tr > <td>5</td><td>William</td><td>36</td></tr>
    </table>

    I found this in the internet
    http://dailydoseofexcel.com/archives...-from-a-range/

    But...no success...
    Last edited by mlcb; 08-24-2013 at 06:46 PM.

  12. #12
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    38,470

    Re: How to post a range - headers and data?

    Entia non sunt multiplicanda sine necessitate

  13. #13
    Forum Contributor
    Join Date
    12-22-2010
    Location
    Rio, Brazil
    MS-Off Ver
    Excel 2010, 2016
    Posts
    209

    Re: How to post a range - headers and data?

    Name Scores
    John 30
    Mary 32
    Mike 34
    William 36

    With some adjustment in the code...

    Success!

    New code

    Please Login or Register  to view this content.

  14. #14
    Forum Contributor
    Join Date
    12-22-2010
    Location
    Rio, Brazil
    MS-Off Ver
    Excel 2010, 2016
    Posts
    209

    Re: How to post a range - headers and data?

    I don't know why the code is not appearing correctly

    I used CODE tags, but something is wrong (???)

  15. #15
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    41,418

    Re: How to post a range - headers and data?

    your code looked fine to me?

+ Reply to Thread
Page 1 of 17 1 2 3 11 ... LastLast

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1