What HTML text editor are you using? Some may allow for importing the tables
and might even let you just highlight/copy the excel sheet and paste it into
the body of the page you are working on and might format it accordingly
itself. Always worth a try. I know I have pasted a pre-existing table into a
page before and then was able to adjust the widths if it was needed. See
what happens if you paste the tables into the body, and then check the code
to see how it writes it. It might just need a little tweaking of the tags to
get it to sort itself out right. There may also be some free tutorials
online that can help. You might try Googling something like "Excel to html"
or something like that.
Hope that helps,
Belinda
On Sat, Nov 13, 2010 at 11:03 PM, Linda Blum-Barton <lblumb(a)gmail.com>wrote:
Dan,
Thanks for that idea. I'll play with it and see if it will help. I
thought
maybe the data option of text to columns might solve it but so far I
haven't
made that work either. I have a spreadsheet with 2005 lines in it and I
am
trying to get it posted with the least amount of work - <g>. It should fit
well within a normal screen width without having to scroll over which is
what's frustrating me at the moment.
Thanks again,
Linda B.
----- Original Message -----
From: "Two Run" <tworun.rw(a)charter.net>
To: <gagen(a)rootsweb.com>
Sent: Saturday, November 13, 2010 9:14 PM
Subject: Re: [GAGEN] Excel Help...
> Linda,
>
> I don't have any experience with what you are talking about, but I wonder
> if
> the Print settings might have any influence on how it gets saved to html.
>
> While on the desired worksheet, first go to the Print Setup and set it to
> Fit-To-Page.
>
> Then try setting a Print Area around your data. You can highlight the
> block
> of cells you want, then File | Print Area | Set Print Area. Or you can
> switch to View | Page Break Preview, and drag the borders of the Print
> Area
> wherever you want them.
>
> Try it with the Print Area fitting the data, and alternatively with extra
> blank columns and rows on either side of your data.
>
> Hopefully it will effect what you see in html.
>
> Dan Pierce
>
>
>
> -----Original Message-----
> From: Linda Blum-Barton
> Sent: Saturday, November 13, 2010 3:42 PM
> To: gagen(a)rootsweb.com
> Subject: [GAGEN] Excel Help...
>
> Can anyone help me solve an issue I am having trying to turn an excel
file
> into html? I have done it before but apparently I need written
> instructions
> rather than those trapped in my mind........sigh.
>
> I have saved it as html and also saved the data into a table......but in
> both cases I am having problems controlling the width of it and am not
> sure
> if there is something I can do in Excel to control that before converting
> it......
>
> Any help greatly appreciated!
>
> Linda B.
>
>
> -------------------------------
> To unsubscribe from the list, please send an email to
> GAGEN-request(a)rootsweb.com with the word 'unsubscribe' without the
quotes
> in
> the subject and the body of the message
>
>
> -------------------------------
> To unsubscribe from the list, please send an email to
> GAGEN-request(a)rootsweb.com with the word 'unsubscribe' without the
quotes
> in the subject and the body of the message
-------------------------------
To unsubscribe from the list, please send an email to
GAGEN-request(a)rootsweb.com with the word 'unsubscribe' without the quotes
in the subject and the body of the message