how to create table like Aladin

tony567

Well-known Member
Joined
Aug 23, 2008
Messages
515
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:

Some videos you may like

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,165
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 a moderator:

tony567

Well-known Member
Joined
Aug 23, 2008
Messages
515
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

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,165
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

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,165
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

Well-known Member
Joined
Aug 23, 2008
Messages
515
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:

snyper189

New Member
Joined
May 7, 2015
Messages
12
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

New Member
Joined
Aug 25, 2015
Messages
7
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

New Member
Joined
Aug 25, 2015
Messages
7
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

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
53,001
Office Version
365
Platform
Windows
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,095,545
Messages
5,445,106
Members
405,316
Latest member
joaoamaro

This Week's Hot Topics

Top