Dod101 wrote:
If someone can remind me yet again how to install a table from Excel in a TLF post I will be happy to try to post my full table.
Hi Dod,
If you use the link below, you'll get to the
Lemon Fool Software Repository TableFormat page, which has been set up to help specifically with this -
http://lemonfoolfinancialsoftware.weebly.com/tableformat.htmlYou then only need to carry out the following steps -
1. Open your Excel spreadsheet
2. In your spreadsheet, select and right-click
COPY your tabular data (this places the Excel data onto the PC clipboard)
3. On the above
TableFormat web-page, scroll to the bottom and you'll see two
empty boxes - in the upper one, right-click and
PASTE your clipboard spreadsheet data
4. Above the box where you've
PASTED the data, select the
TABLE radio-button
5. Select the
'Create Formatted Text' button that you'll see below the box where you've pasted the data
6. You'll now see some pre-formatted data appear in the lower of the two boxes at the bottom of the page.
7. Use your mouse to select anywhere in that lower box, and then carry out a
CTRL-A to select all the text in that box, and then a
CTRL-C to copy that pre-formatted tabular data to your PC clipboard
8. On the Lemon Fool website, you can use the
TEST BOARD (
https://www.lemonfool.co.uk/viewforum.php?f=28) to create a dummy post
just for testing-purposes, and then
PASTE that pre-formatted text into it.
9. Once you're happy with the
TEST post, you can post up your tabular data
for real on the Lemon Fool board of your choice. The TEST board data is scrubbed fairly regularly, so don't worry about anything left on there.
Hope this helps - let me know if there's any issues with the above process.
Cheers,
Itsallaguess