I have added a version of the file for earlier versions of Excel. http://members.iinet.net.au/~nickred/temp/little_table.htm Open Office will open these files also. Regards /Nick/ Home http://members.iinet.net.au/~nickred/ <http://members.iinet.net.au/%7Enickred/> Sites managed http://freepages.genealogy.rootsweb.ancestry.com/~registryofdeeds/index.html <http://freepages.genealogy.rootsweb.ancestry.com/%7Eregistryofdeeds/index.html> http://www.igrsoc.org/index.htm http://members.iinet.net.au/~nickred/majuratennis/ <http://members.iinet.net.au/%7Enickred/majuratennis/>
Nick Reddan's example of creating an HTML table format within the spreadsheet is a good one. I've had a look at it and found that one stage can be eliminated, and when the spreadsheet example found at:- http://countjustonce.com/test/simple-table.html - is opened, the formula found in cell G11 is all that is needed to copy the table to its left. Just copy and "fill down" the desired number of rows and the table will be copied over complete with the HTML formatting. The additional HTML formating above and below the table contents is also entered in column "G" using the standard format in the formula field, e.g ="<!doctype html>'" etc.. To copy the result into your text editor, just highlight, copy and paste the contents in column "G" into your editor and save. Thanks Nick for sharing the simplified HTML table generation method. Barry
Can you all let me know if you are receiving my posts of late? I haven't seen them coming thru, and some of yours including this one are going into my Junk/Spam Folder. Thanks! Kathie B. (Also, somewhat unrelated: my son bought me some "Legacy" genealogy software for my birthday and I'd like some opinions on the product before I open it! Thanks again!) -- On Sat, 10/16/10, Barry Carlson <barrycarls@gmail.com> wrote: From: Barry Carlson <barrycarls@gmail.com> Subject: Re: [FreeHelp] Excel to HTML - tip regarding Excel's auto numbering To: freepages-help@rootsweb.com, "Nick Reddan" <nickred@webone.com.au> Date: Saturday, October 16, 2010, 5:05 AM Nick Reddan's example of creating an HTML table format within the spreadsheet is a good one. I've had a look at it and found that one stage can be eliminated, and when the spreadsheet example found at:- http://countjustonce.com/test/simple-table.html - is opened, the formula found in cell G11 is all that is needed to copy the table to its left. Just copy and "fill down" the desired number of rows and the table will be copied over complete with the HTML formatting. The additional HTML formating above and below the table contents is also entered in column "G" using the standard format in the formula field, e.g ="<!doctype html>'" etc.. To copy the result into your text editor, just highlight, copy and paste the contents in column "G" into your editor and save. Thanks Nick for sharing the simplified HTML table generation method. Barry ------------------------------- To unsubscribe from the list, please send an email to FREEPAGES-HELP-request@rootsweb.com with the word 'unsubscribe' without the quotes in the subject and the body of the message