Freepages-Help-L ArchivesArchiver > Freepages-Help > 2010-10 > 1287219948
From: "Barry Carlson" <>
Subject: Re: [FreeHelp] Excel to HTML - tip regarding Excel's auto numbering
Date: Sat, 16 Oct 2010 22:05:48 +1300
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:-
- 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.
|Re: [FreeHelp] Excel to HTML - tip regarding Excel's auto numbering by "Barry Carlson" <>|