how to create table like Aladin

[tony567]

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)

 

[Aladin Akyurek]

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

 

[tony567]

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

 

[Aladin Akyurek]

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...

 

[Aladin Akyurek]

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...

 

[tony567]

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?

 

[snyper189]

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

 

[Brian Hull]

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!

 

[Brian Hull]

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

 

[Joe4]

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.