Thanks Thanks:  0
Page 1 of 2 12 LastLast
Results 1 to 10 of 15

Thread: how to create table like Aladin

  1. #1
    Board Regular
    Join Date
    Aug 2008
    Posts
    515
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default how to create table like Aladin

    In every posting, Aladin create a table that so simple, but i like it
    How to make a table like Aladin's table?


    xyz
    Search Value5
    a13197
    Count3
    b1555
    Values At:RowColc984

    byd11515

    bz





    dy

    how to make a table like that? (i copy paste the table, but the border is gone)
    Last edited by tony567; Jan 30th, 2010 at 12:27 PM.

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    84,628
    Post Thanks / Like
    Mentioned
    41 Post(s)
    Tagged
    8 Thread(s)

    Default Re: how to create table like Aladin

    Quote Originally Posted by tony567 View Post
    In every posting, Aladin create a table that so simple, but i like it
    How to make a table like Aladin's table?


    xyz
    Search Value5
    a13197
    Count3
    b1555
    Values At:RowColc984

    byd11515

    bz





    dy

    how to make a table like that? (i copy paste the table, but the border is gone)
    Select the relevant area in Excel.
    Put borders around the cells.
    Copy the area and past it here.

    Use IE for seeing the pasted exhibit.
    Use IE also for copying the exhibit from the board and pasting it in Excel.


    Edited by Peter_SSs since quite a few people are still having trouble with this.

    You do need another setting that is not mentioned above. There are 2 ways.

    1. Forum Actions (top left of screen)|General Settings|(Scroll down to) Miscellaneous Options|Message Editor Interface|Enhanced Interface ..., or

    2. Forum Actions (top left of screen)|General Settings|(Scroll down to) Miscellaneous Options|Message Editor Interface|Standard Editor - Extra Formatting Controls (this is what I use), but before you want to use Borders/Copy/Paste, click the 'Switch Editor Mode' button at the top left of the Quick Reply window.


    * For IE11 - ActiveX must be activated
    Last edited by Peter_SSs; Aug 13th, 2016 at 04:48 AM. Reason: Navigation links have changed
    Assuming too much and qualifying too much are two faces of the same problem.

  3. #3
    Board Regular
    Join Date
    Aug 2008
    Posts
    515
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: how to create table like Aladin

    Aladin, i'd try, copy paste the cell and the border in excel to here,
    but when i click "Preview Post", suddenly the border is gone... and look like my previous post

  4. #4
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    84,628
    Post Thanks / Like
    Mentioned
    41 Post(s)
    Tagged
    8 Thread(s)

    Default Re: how to create table like Aladin

    Quote Originally Posted by tony567 View Post
    Aladin, i'd try, copy paste the cell and the border in excel to here,
    but when i click "Preview Post", suddenly the border is gone... and look like my previous post
    Looks like such posts cannot be done in About This Board...
    Assuming too much and qualifying too much are two faces of the same problem.

  5. #5
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    84,628
    Post Thanks / Like
    Mentioned
    41 Post(s)
    Tagged
    8 Thread(s)

    Default Re: how to create table like Aladin

    Quote Originally Posted by tony567 View Post
    Aladin, i'd try, copy paste the cell and the border in excel to here,
    but when i click "Preview Post", suddenly the border is gone... and look like my previous post
    Tony,

    Try it in the Test Here forum...
    Assuming too much and qualifying too much are two faces of the same problem.

  6. #6
    Board Regular
    Join Date
    Aug 2008
    Posts
    515
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: how to create table like Aladin

    Thanks Aladin,
    i'd try, but no border, i need a border too

    my "test here" posting is here: http://www.mrexcel.com/forum/showthread.php?p=2200043
    how to add border in the data?

    Wait, i think i should post the table in here too, here you are:

    20 25 30 24 30 36 28 35 42
    ok, it can't be done here.

    yesterday i copy paste from excel, the border is exist, but when i click "preview post" the border is gone
    Now... i copy paste from excel, and the border is not exist even i dont click "preview post"
    is the board setting has been changed?
    Last edited by tony567; Feb 2nd, 2010 at 02:02 AM.

  7. #7
    New Member
    Join Date
    May 2015
    Location
    Pennsylvannia
    Posts
    12
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: how to create table like Aladin

    OXFORD NEW OXFORD Vehicle
    Total Admin Time Police Time Police Time Vehicle Total Miles Fuel
    Hours
    12/31/2014 Wed
    1/1/2015 Thu 0
    1/2/2015 Fri 0
    1/3/2015 Sat 0
    1/4/2015 Sun 0
    1/5/2015 Mon 0
    1/6/2015 Tue 0

  8. #8
    New Member
    Join Date
    Aug 2015
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: how to create table like Aladin

    Cable Other Cable Space
    2,4,1 12 #REF!
    2,4,1 12 #REF!
    2,4,1 18 #REF!
    2,4,1 12 #REF!
    2,4,1 12 #REF!

  9. #9
    New Member
    Join Date
    Aug 2015
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: how to create table like Aladin

    Sheet1
    Cable 1 Cable 2 Space
    2,4,1 12 #REF!
    2,4,1 12 #REF!
    2,4,1 18 #REF!
    2,4,1 12 #REF!
    2,4,1 12 #REF!


    Sheet2
    First Cable Second Cable Space Needed
    12 0,0,0 37.68
    12 1,2,1 38.81
    12 2,4,1 39.81
    12 2,4,2 39.94
    12 3,6,2 40.94
    18 0,0,0 56.52
    18 1,2,1 57.65
    18 2,4,1 58.65
    18 2,4,2 58.78

  10. #10
    MrExcel MVP
    Moderator
    Joe4's Avatar
    Join Date
    Aug 2002
    Posts
    47,381
    Post Thanks / Like
    Mentioned
    37 Post(s)
    Tagged
    7 Thread(s)

    Default Re: how to create table like Aladin

    Brian,

    Look at posts #4 and #5 above. You cannot do it in this thread, as it does not work in the "About This Board" forum.
    Try the "Test Here" forum.
    TIPS FOR FINDING EXCEL SOLUTIONS
    1. Use the built-in Help that comes with Excel/Access
    2. Use the Search functionality on this board
    3. A lot of VBA code can be acquired by using the Macro Recorder.

    "Give a man a fish, feed him for a day. Teach a man to fish, feed him for life!"

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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