Freepages-Help-L Archives

Archiver > Freepages-Help > 2010-10 > 1287151273


From: "Heidi Utley" <>
Subject: Re: [FreeHelp] Excel to HTML - tip regarding Excel's auto numbering
Date: Fri, 15 Oct 2010 09:01:13 -0500
References: <AANLkTimhcpON1ZLit5K+TurDS0FBsP6VX4kS1mmUCra+@mail.gmail.com>


Hi Judy,

How do you go about opening it in Google?

Thanks for sharing valuable info.

Heidi
E-mail:
URL: http://freepages.genealogy.rootsweb.ancestry.com/~heidisfamily
-----------------------------------------------------
----- Original Message -----
From: "J.A. Florian" <>
To: <>; <>
Sent: Friday, October 15, 2010 6:54 AM
Subject: [FreeHelp] Excel to HTML - tip regarding Excel's auto numbering


> In Excel, if you have a simple table, 7 columns across, however long with
> the the A - B - C column headers and auto numbering "on", although it is
> easy to remove the A-B-C Row, it can be a big pain to get the numbes to go
> to "Normal" and not be bold and huge.
>
> People often send me Excel sheets as submissions. When I get cemetery
> databases on Excel, there's a lot to do to change it to HTML code. I open
> it in Google, go to View Source, then start stripping out all the code I
> don't want with Find>Replace. I took out all instances of "bold" and
> "font". I'm left with the table row and column and widths, and of course
> the data.
>
> I then copy it to Frontpage. In Frontpage2000, the settings on the
> stripped
> file showed Normal formatting, Normal Font, Normal Size. But I still had
> Excel A-B-C and numbers in the first column-- big and bold. I highlighted
> the column and tried to use the Bold command to make sure it wasn't really
> bold-- it wasn't, so no effect. The numbers were also centered, even
> though
> it wasn't found in the code. I could not see in the coding what code
> controls the numbering in the stripped Excel to HTML code.
>
> Well, I finally found how to make the row numbering go back to Normal
> looking. I highlighted the column and went to Cell Properties. There, I
> saw a check mark next to "Header Cell". When I unchecked it, the numbers
> look like the rest of the page. I then "cut" the A-B-C header row too.
>
> Interestingly, the code in the table looks exactly the same as before I
> found that check-box. So I thought I'd pass along this tip in case other
> people come across the same problem. It can save hours of trying to
> manually re-enter the numbers in HTML. I'm not sure how you'd find or
> fix the "problem" if not using a WYSIWYG Editor.
>
> Only thing I haven't found a way to fix is that the numbering in Excel
> starts on the A - B - C column header, not on line 1 of data. So if Excel
> says there are 816 burial names, it's actually 815 minus the A-B-C header
> row (which is removed). To save time, I end up putting a "Note" that the
> numbering is one-off rather than re-typing numbers.
>
> Judy
>
> -------------------------------
> To unsubscribe from the list, please send an email to
> with the word 'unsubscribe' without
> the quotes in the subject and the body of the message

This thread: