Posting a spreadsheet?

[mrsxllifts]

Hi

I have a three column by 40 row speadsheet I would like to post on the Lotteryheads forum, is this possible?

I have tried doing it by posting it as a picture but it comecs out too small or too fuzzy to read.

Is there some new-fangled thingymagig that can help me?

Thanks

Hannah

[mrmr96]

Can't "post a spreadsheet" but you've got 2 half decent options.
i) post is as a jpeg image of a screen print.
ii) Use the table function in PH as follows:

This code:

||=Heading=||=Heading 2=||=Heading 3=||
|| Row1Cell1 || Row1Cell2 || Row1Cell3 ||
|| Row2Cell1 || Row2Cell2 || Row2Cell3 ||

Produces this table:

Heading	Heading 2	Heading 3
Row1Cell1	Row1Cell2	Row1Cell3
Row2Cell1	Row2Cell2	Row2Cell3

[mrsxllifts]

Hi,

The jpeg seems to come out either too small or unreadable.

I think the table option is going to be the one, I'm just too lazy to type it out and hoped for a eaier option!

Thanks for the help.

[mrmr96]

mrsxllifts said:

Hi,

The jpeg seems to come out either too small or unreadable.

I think the table option is going to be the one, I'm just too lazy to type it out and hoped for a eaier option!

Thanks for the help.

You don't need to type it out - you're using excel!! Put your data in columns A B and C starting at row 1, and then I'll make some code to put in col D, row 1, and then drag down. (2 secs)

[mrsxllifts]

Ahh, yes, I get you. Stick the lines in a seperate column! As you can tell, computers aren't my strong point!

Thank you!

[mrmr96]

Ok, put this on the heading row:
="||="&A1&"=||="&B1&"=||="&C1&"=||"

And put this on the 2nd row (first data row), and then drag down:
="|| "&A2&" || "&B2&" || "&C2&" ||"

Then copy that column and post it.
(Don't forget to credit me in your post! )

[bobr]

Other option is to upload to google docs, and post a link up

[mrsxllifts]

You're a star! It not true what they say about you

[mrmr96]

Hey, your idea works well too, just make 4 new columns of "sticks" (one to the left, between each column of data and one to the right) then you can copy and paste the whole lot, without having to use a formula.

[mrsxllifts]

No, your idea makes me look clever-er!

[xllifts]

mrsxllifts said:

No, your idea makes me look clever-er!

as if!