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:
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:
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, 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...
 
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:
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
 
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!
 
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
 
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.
 

Forum statistics

Threads
1,213,534
Messages
6,114,186
Members
448,554
Latest member
Gleisner2

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
Back
Top