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

Just a further comment that I've said before but I failed to state in the "tip" email I sent earlier... I can't open the Excel sheets because my Excel is older than the submitter's program and I've not had extra time to learn a different program (like Open Office). When I saw that gmail could open files in a browser, it means I don't have to worry about using a program. My method of opening the sheet in a browser and then switching Excel code to what I want in HTML may not be the best for everyone, but it is working for me. I've identified "effects" I hate (like valign=top or valign=bottom for cell data) and I remove the "ickky" code along with fonts, etc. My biggest problems have been those Excel headers, the number column, and trying to adjust really wide columns to smaller columns. The header and numbers have been the worst issues for me, so I was tickled to find a solution. Some other method may be better for other people, but using Find/Replace gives me control over what I'm changing or taking out. Plus, it helps me learn more about what the codes are doing (especially the Excel code effects I don't like--LOL). Judy On Fri, Oct 15, 2010 at 7:54 AM, J.A. Florian <cageycat@gmail.com> wrote: > 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 > -- -- WASHINGTON COUNTY PA WEBSITES::: http://freepages.misc.rootsweb.com/~florian/ Coordinator of the Washington County PAGenWeb: http://www.rootsweb.com/~pawashin/