Posting Excel Tables

[rwmill9716]

I want to learn how to post portions of Excel tables in my posts. I was told to place borders around the cells, copy them and then paste them in my post here. When I do that, the column relationship is lost so the columns don't line up. It looks like this:

Abb BAA
1 4
2 5
3 6


I must be doing something wrong though it seemed so simple. Any help would be appreciated as I see tables included all the time in other posts.

Thanks,

ric

 

[Richard Schollar]

Hi

Doing what you are doing I have found to work only when using Internet Explorer (not Firefox or other browsers) and the only version of IE I have tested this on is IE6.

There are html makers which are add-ins to Excel which can be used to generate a html output which can be pasted into your post and will carry over formatting and formulas. There are two common ones available: my own which you can get if you send me a PM with your email address) or Excel Jeanie which you can get if you type in Excel Jeanie into a search engine. Jeanie is the more comprehensive option but is also more complex and requires you to run an executable on your machine. Mine is totally open and is simply an Excel add-in so you can review the coding behind it and modify it should you wish.

 

[Peter_SSs]

As well as the Internet Explorer issue there are two others to be aware of ..

1. You do require a certain setting, see here

2. It won't work in this 'About This Board' forum so you need to test in the Test Here forum.