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,203
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,203
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,203

ADVERTISEMENT

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

ADVERTISEMENT

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
56,655
Office Version
  1. 365
Platform
  1. 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,127,652
Messages
5,626,093
Members
416,161
Latest member
David1966Lewis

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top